wht r the requirements for writing a cobol-db2 pgm ?
Answers were Sorted based on User's Feedback
Answer / tej
1. Declare the table structure you wanted to access in
working storage section or linkage section.(Can use DCLGEN
here).
2.Declare host variables in Working storage section.(if
DCLGEN used no need of declaring these host variables
separately).
3.Include SQLCA.
3.Now you can add the embedded SQL statements to your program.
Please add if i missed any other info..
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / yuvaevergreen
Steps in program preparation
>>Step 1: Process SQL statements
>>Step 2: Compile (or assemble) and link-edit the
application
>>Step 3: Bind the application
>>Step 4: Run the application
| Is This Answer Correct ? | 1 Yes | 1 No |
Answer / ali baba
writing a pgm does not involve running it - answer #2 and #3
got that wrong.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / ajay kumar ande
3 steps..........
1.)pre-compilation
2.)bind
3.)run
1.PRECOMPLATION
// jobcard job......
// act01 exec pgm=dsnhpc
// DBRMLIB DD DSN=
// act01 exec pgm=IGYCRCTL
// SYSLOAD DD DSN=&&TEMP,DISP=PASS
// act01 exec pgm=IEWL
// SYSLMOD DD DSN=&&TEMP,DISP=OLD
BIND
// act01 exec pgm=IKJEFT01
// DBRMLIB DD DSN=
SYSIN DD *
BIND PLAN( ) MEM( ) ISOLATION(CS) ACTION(REP)
RUN
// act01 exec pgm=IKJEFT01
SYSIN DD *
RUN PROG( ) PLAN( ) LOADLIB( )
| Is This Answer Correct ? | 0 Yes | 1 No |
Differentiate between cs and rr isolation levels? Where do you specify them?
How to execute stored procedure in db2 command editor?
What do you mean by storage group (stogroup)?
query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop
what is the difference between join and union?
wht is d/f between union and joins ?
What is the purpose of the QUIESE Utility?
What is catalog database in db2?
How do I delete a table in db2?
Can one database have multiple instances?
Can we declare cursor in Procudere division or open the cursor in the Working storage section. Is there any particular rules in the usage of cursors lifecycle
Explain package in db2 and its advantages?