what is a plan and how do you refer the plan in the
program?
Answers were Sorted based on User's Feedback
Answer / harsha
plan is executable.it contains access path.we will refer
plan in jcl as plan name.generally all information abt the
plan will be there in sysibm.sysplan
Is This Answer Correct ? | 5 Yes | 0 No |
Answer / guest
The DBRM name is the program name and should be bound to a
plan before the DB2 program can be executed. The plan is
nothing but bound DBRMs or packages.
Is This Answer Correct ? | 0 Yes | 1 No |
Can we use select query in a loop to fetch multiple rows in a COBOL PROGRAM? If so, what is the advantage of cursor?
What do you mean by storage group (stogroup)?
What is null value in db2?
What error I will get if my select query gives multiple row while executing a Cobol-DB2 program.How can I solve it without using a cursor.
4 Answers Cap Gemini, Verizon,
Give a brief description of db2 isolation levels?
What is an alias?
While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?
For Null indicator we have 3 values 0,-1,-2. 0->Not nulll -1->Null -2->Value truncated If ther is any possibility to have any positive value other than 0 in Null indicator.If it is so then when we will get and what is the value?
Define declaration generator (dclgen).
how to fetch multiple records without using cursor
Where can you declare a cursor in a cobol-db2 program?
Where is the access path logic created by the DB2 Optimizer stored?