Interested to Buy Any Domain ? << Click Here >> for more details...
One program calling 5 subprograms, its a cobol db2 program,
after precompilation how many plans and packages will
created?
- 3 Answers
- 18612 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / sarath
when u precompile a Db2 program you will get (n+1) DBRMs
where n indicates no. of subprograms. So in our case you
will get 6 DBRMs. Through Binding process you can get
minimum of 1 package and maximum of 6 packages. But finally
you will get only one plan.
| Is This Answer Correct ? | 27 Yes | 2 No |
Answer / vat
Not trying to be cute, but, to the question "after
precompilation how many plans and packages will
created?" the answer would be zero.
You would have to do bind to even talk about packages/plans.
| Is This Answer Correct ? | 14 Yes | 1 No |
Answer / snehasis
If it generate 6 DBRM, then there is no possibility to have
1 package. The reason is one package can contain only one
DBRM. But yes for all these DBRM and Packages it will be
only one plan.
| Is This Answer Correct ? | 9 Yes | 3 No |
What if we fail to give values in columns declared as NOT NULL ?
can any one give the list of some important sql abend codes which r frequently asked in interviews?
Can you Average the Characters ?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
Once you create a view, where would information about the view be stored?
What do you mean by NOT NULL WITH DEFAULT? When will you use it?
how to fetch multiple records without using cursor
In which column of which DB2 catalog would you find the length of the rows for all tables?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What are the three DB2 date and time data types and their associated functions?
I have 3 cursors declared. Cursor1 retieves some data. Based on this curso2 will also fetches some data. In cursor3 (using for some updation) I'm using the data retrieved by the above 2 cursor. My question is, while working with cursor3, periodically if I give commit, will all the three crsors will be closed or only cursor3 will be closed?
Can DB2 be accessed by TSO users? If yes, which command is used to invoke DB2?
COBOL 
