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 is check point and restart Logic ? why do we go for that ??
a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.
could you give me an example how, where i code CHECKPOINT and restart...I need and example....thanks..
How to define the data items to receive the fetch items for the SQL?
What is db2 and what is the use of db2 optimizer?
How does DB2 store NULL physically?
what is utility for parm lib
What is the difference between spufi and qmf?
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
What is db2 plan table?
I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?
Compare a subselect to a join?