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 |
db2 restart logic ?
Is it mandatory to use DCLGEN? If not, why would you use it at all?
I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.
How do you prepare a COBOL + DB2 program from coading till execution ?
pls explain the precompilation process of cobol-db2 pgm
In terms of DB2 indexing, what is the root page?
How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?
What is explain in db2?
if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.
Q4. How will you get the count of record without using COUNT verb in query?
What is DB2 (IBM Database 2)?
Explain what are the various isolation levels possible?