How do you prepare a COBOL + DB2 program from coading till
execution ?
Answer / 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 |
What is a db2 package?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What does the sqlcode of -818 pertain to?
What is a SELECT statement?
If the base table underlying a view is restructured, eg. attributes are added, does the application code accessing the view need to be redone?
What are the three DB2 date and time data types and their associated functions?
Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is a db2 collection?
Define data page.
How many databases can be created inside an instance in db2 ?
How to restart a DB2 program?