is there any restrictions for unions ?
Answers were Sorted based on User's Feedback
Answer / i go crazy
Union can be used in a cobol db2 pgm, only restriction is it has to be operated using a CURSOR.
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / mehdee
- There is no restriction for UNIONs in DB2 COBOL coding,
but you can think of logical restrictions, for example if
the DB2 tables are so big that your program will run fast
if just access them individually as needed.
| Is This Answer Correct ? | 0 Yes | 3 No |
What will the FREE command do to a plan?
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,
Q3. How will you fetch duplicate values from a DB2 table?
What is the function of logging in the db2 database?
What techniques will be used to avoid deadlock??
What is the use of DELGEN in DB2? Can we Write the program with out using it?
What is a page?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID register contain?
3 Answers Cap Gemini, Tech Mahindra,
B37 abend during spufi?
Explain in detail about buffer manager and its functionalities?
What is correlated subquery?