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 happens in bind step in a db2 program?
Are view updateable?
How to compare data between two tables in db2?
When is the skeleton cursor table created?
What is dbrm library?
When would you prefer to use VARCHAR?
can we view the access paths created by dbrm ? how ? thx
i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.
What is the use of with ur in db2?
What is lock escalation?
What is cursor stability?
What does runstats do in db2?