wht steps we need will coding cobol and db2 pgm ?
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 |
What are the benefits of using the db2 database?
5 rows are inserted to a DB2 Table. Next 3 of those are updated, then a rollback is issued. What would happen when the rollback is issued?
What is a Foreign Key?
0 Answers Tavant Technologies, Zensar,
How do I import data from excel to db2?
Are view updateable?
What is cursor stability?
What are the isolation levels possible ?
Hi this is sures. i need to practice the ibm mainframes.could u telme how can i get userid from IBM.how much cost they will collect for one user id.can send me the details please.thanq
What is db2 bind?
What is the purpose of the DSNC transaction ?
When one binds a PACKAGE ( of a plan ) what package information is stored and where it is stored?
How to view db2 table structure?