Answer / ankitha

when you start coding any DB2 pgms you should include SQLCA
and DCLGEN member in w-s section and perform activities of
coding which need to be processed in procedure division.
all statements should be scoped in EXEC SQL and END-EXEC scope
only and you should precompile, create package and plan, you
should run this pgm by using plan. these are the steps we
follow these days.
i this this will help you

Answer / 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.

Answer / naren

Pre-Compile
BIND
Run JCL

Answer / jujubi

when you start coding any DB2 pgms you should include SQLCA
and DCLGEN member in w-s section and perform activities of
coding which need to be processed in procedure division.
all statements should be scoped in EXEC SQL and END-EXEC
scope
only and you should precompile, create package and plan, you
should run this pgm by using plan. these are the steps we
follow these days.

Answer / lu

your question is not clear.....

Answer / niveditha

This question does not make any sense. please explain correctly

What is a DB2 bind?

1 Answers   Logica CMG,

Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

0 Answers  

When you are working with the project after coding what will u do? Like what type of documents u will prepare? How will u do testing?

2 Answers  

What does the CHECK Utility do ?

1 Answers  

What is the syntax required for the creation of a cursor?

1 Answers  

What happens in bind step in a db2 program?

0 Answers  

Explain the benefits you can get from mainframe connect?

0 Answers  

How to resolve deadlock issue

5 Answers   IBM,

what is SPUFI ?

2 Answers  

What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)

2 Answers  

what's the error code for Unique Index Violation?

2 Answers  

What is correlation names?

1 Answers