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 |
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.
0 Answers ITC Infotech, Syntel,
How can you get the number of rows impacted by the last executed query?
This was related to -811 sqlcode, In a COBOL DB2 program which accesses employee table and selects rows for employee 'A', it should perform a paragraph s001-x if employee 'A' is present. In this case it gets -811 sqlcode, but still it process the paragraph s001-x. What could be wrong in my code.
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
i want to maintain uniqueness on pdf without make lf??????????
What are catalog tables in db2?
Is the primary key a clustered index?
Update command
For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?
What is the syntax for FETCH in DB2 ?
What is a clustered index?
What is image copy?