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 |
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?
Explain about rct in db2?
What is universal database?
What is role in db2?
What will the COMMIT accomplish?
what is Runstats? Whem will u choose to runatats?
I want to fetch the 10th row of a table which has been changed.How can I do it without going thru all the rows.
What does a deadlock mean in DB2?
What is the role of union all and union
Which transaction use a command thread ?
Explain in detail about buffer manager and its functionalities?
This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.