Can we declare DB2 HOST variable in COBOL COPY book?
Answers were Sorted based on User's Feedback
Answer / a.roselin
No, We cant declare it in Cobol copy book, why because,
Copy book is not expand during the precompilation, But if
you declare it in DCLGEN, it will be expanded during
precompilation.
| Is This Answer Correct ? | 6 Yes | 8 No |
Answer / arup
the below code is working fine....
COPY DSBPRDDS.
DSBPRDDS is a DCLGEN.
| Is This Answer Correct ? | 0 Yes | 2 No |
what happend with out using Commit,when closing cursor and program?
How can you classify the locks in db2?
Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?
what is utility for parm lib
How to test SQL -911 error while developing COB-DB2 program
What is package in cobol db2?
what is the use of bind parameter, Replace?
What is db2 plan table?
what are extents?
db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.
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 use of DELGEN in DB2? Can we Write the program with out using it?