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 |
if suppose i am having an ACCOUNT table with 3 coloumns ACC. NO,ACC. NAME,ACC. AMOUNT . If a unique index is also defined on ACC.NO and ACC.NAME then write a query to retrieve account holders records who have more than 1 ACC.
Where besides the DB2 catalog is database object information stored by DB2?
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
where can we use index and subscript ? with example ?
What is the physical storage length of date data type?
What is package versioning? Please give an example.
What is the SQL Communications Area and what are some of its key fields?
pls tell me abt the normalization five types....
What is a Cartesian product?
List down the data types in the db2 database.
What is difference between rollback and commit?
What is buffer pool and list some of them?