How do you prepare a COBOL + DB2 program from coading till
execution ?
Answer Posted / kaushik datta
1.Code the program with all DB2 statements inside EXEC
SQL/END-EXEC statements
2.Compile the program with suitable compile JCL/ENDEVOR.In
endevor give proper processor group
3.Package Bind the program. M.5.1.5.4
4.Create proper JCL to run that.You can you IKJEFT01
5. Run the JCL.Your program loadb should be in the library
mentioned in the STEPLIB of run JCL
| Is This Answer Correct ? | 9 Yes | 4 No |
Post New Answer View All Answers
Why do we need reorg in db2?
What is db2 purescale?
How many databases are there?
What is a Foreign Key?
What do you mean by rollback?
What is runstats db2?
How to test SQL -911 error while developing COB-DB2 program
Explain the function done by data manager?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
Which component is used to execute the sql statements?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
Which isolation level provides highest data integrity?
How to find primary key of a table in db2?
What are the 2 sqlcodes that are returned?