wht steps we need will coding cobol and db2 pgm ?
- 6 Answers
- 8564 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 |
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
How to check table size in db2 sap?
what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??
What is tablespace?
4. A DB2 application is bound with uncommitted Read isolation level.It issues a request that retrieves 20 rows out of 200000 in the table. Which of the following descrbes the rows that are locked as a result of this request? a. None of the rows are locked. B.The retrieved rows are locked. C.The last row of the result set is locked. D.The rows not previously updated by another application are locked.
How to know the primary key of a table without defining the primary key in the table?
Hi. I am currently working as a application developer. I would like to persue a DB2 certification exam. Can anybody please provide me the details about this exam like Syllabus, Cost and how to take the certification?
What is a db2 tablespace?
What is the advantage in De-normalizing tables in DB2?
db2 maintains information about the data... a.in tables. b.in a set of tables known as db2 catalog. c.in db2 database. d.none of the above.
What is the difference between nvl and coalesce?
What are the rules for db2 programming?
COBOL 
