How do you prepare a COBOL + DB2 program from coading till
execution ?
- 1 Answers
- 10189 Views
- Amdocs, Xansa, I also Faced
- E-Mail Answers
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 |
How do I delete a table in db2?
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
What is CHECK PENDING ?
Q4. How will you get the count of record without using COUNT verb in query?
What are the different types of base tables?
In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
How to rename a table in DB2 ?
What are column-name qualifiers used?
what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??
Is schema the same as database?
COBOL 
