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 null indicator in db2?
What is performance tuning db2?
How do you Load a table ?? and what is Load replace ?
How to create db2 table in mainframe?
What is an asychronous write?
What is a view? Why use it?
What is the cascade rule and how does it relate to deletions made with a subselect?
Is ibm db2 open source?
What can the Locate option of the Repair Utility accomplish?
pls tell me abt the normalization five types....
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 COBOL picture clause for a DB2 column defined as DECIMAL(11,2)?