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


Please Help Members By Posting Answers For Below Questions

What is data manager?

695


How can tablespace be moved to another dasd volume that is allocated for that tablespace?

851


What are db2 tables?

742


Describe major components of db2?

739


What is a system catalog table in db2?

682






What is clone table?

684


Can one database have multiple instances?

662


can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

1896


I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

2848


What is concurrency?

799


what are bind concepts in db2 cobol?

730


How can you count the number of rows from a table tab?

721


How to view db2 table structure?

683


Before you give the explain statement, what are the prerogatives?

652


What is image copy in db2?

649