wht steps we need will coding cobol and db2 pgm ?
Answer Posted / yuvaevergreen
step1>>put all the sql statements in cobol program inside
exec sql and end-exec.Because precompiler identifies using
sql using these keywords.
step2>>all sql statements should be within 12th and 72th
column in program.
step3>>Include the dclgen if created or use the host
variable declaration name and sqlca.
step4>>precompile,compile,bind,linkedit and execute.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?
How to create backup table in db2?
What type of database is db2?
What is dbrm?
What is the maximum length of sqlca?
What are db2 objects?
Describe major components of db2?
How is the value function used?
How can you find out the # of rows updated after an update statement?
What is dbrm? When it will be created?
What is db2 command?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
List out the data types available.
How can you do the explain of a dynamic sql statement?
How can you quickly find out the # of rows updated after an update statement?