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
What is the difference between nvl and coalesce?
What is host variable in db2 cobol?
What is lock escalation in db2?
What is a Foreign Key?
what is utility for parm lib
Explain dclgen.
How to execute stored procedures?
List some fields from sqlca?
What is cobol db2?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
When reorg is used?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
What does db2 plan contain?