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 buffer pool?
Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?
How do you retrieve the first 5 characters of firstname column of db2 table emp?
How to get Top 10 Salaries from a Table
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
What is the difference between TYPE 1 index & TYPE 2 index
What does the REORG Utility do?
Which DB2 catalog tables are used to produce a list of table column by table for all tables in a database?
can we update the table by using cursors can anyone post the query?
COBOL PRECOMPILER ERROR: "XXXXXX" (TABLE) PREVIOUSLY DECLARED OR REFERENCED DCLGEN VARIABLES GETS IMPORTED TWICE FOR ONLY ONE EXEC SQL STATEMENT. WHAT COULD BE THE PROBLEM?
What happens to a tablespace when its recovery infromation has been removed and a full recovery is no longer possible?
How do I connect my db2 database to ibm?