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 a plan and package in db2?
What is the logical entity between plan and Package?
How are write I/Os from the buffer pool executed?
What is a base table?
What is difference between isnull and coalesce?
What is a subselect? Is it different from a nested select?
What types of tables are there in the db2 database?
What keyword does an SQL SELECT statement use for a string search?
what is the name of the default db2 catalog database?
Is the primary key a clustered index?
How and when does the db2 enforces the unique key?
What is the maximum number of columns in a db2 table?