Interested to Buy Any Domain ? << Click Here >> for more details...
wht steps we need will coding cobol and db2 pgm ?
- 6 Answers
- 10606 Views
- CGI, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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
| Is This Answer Correct ? | 10 Yes | 0 No |
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.
| Is This Answer Correct ? | 1 Yes | 0 No |
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.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / niveditha
This question does not make any sense. please explain correctly
| Is This Answer Correct ? | 1 Yes | 2 No |
Can we able to find all the Table names under a Particular Plan?
What are foreign keys?
How do you Load a table ?? and what is Load replace ?
Do we have any optinon to search part of integer in DB2 as we have for character Like,SUBSTR optins?
What do you mean by between and in? Is between inclusive of specified range values?
What is db2 and what is the use of db2 optimizer?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
Suppose we are doing transaction in a table and abend happened in between. Suppose i have completed the transaction upto X rows and I want to start the transaction again where the abend happened. I don't want to do the transaction from the first record. Then what i have to do.
How connect db2 database to datastage?
What is host variable in db2 cobol?
What is meant by concurrency?
How to test SQL -911 error while developing COB-DB2 program
COBOL 
