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 |
If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
When is the skeleton cursor table created?
What is the significance of DB2 free space and what parameters control it?
What is a db2 schema?
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
max number of columns in a db2 table?
What is a DB2 bind?
What is the use of value function?
What is a bind card?
What is multi row fetch in db2?
how to resolve -805 . how to see dbrm and package not found