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 the difference between group by and order by?
how to check the table is empty or not?
How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.
What is the clustering index in the db2 database?
What is a collection?
What do you mean by NOT NULL? When will you use it?
What is DCLGEN?
If the main program has only cobol statements and subprogram has the db2 statements what is the procedure for precompilation. for which program we need to do the precompilation
What is multi row fetch in db2?
What is the SQL query to select, delete and get count of duplicate rows in DB2?
wht is d/f b/w inner join and outer join ? d/f group by and order by having by ?
what will be the output of the below given query, if no matching records are found : (a.) 0 (b.) null (c.) error select Avg(salary) from TableA where Deptno = 'insurance'