Interested to Buy Any Domain ? << Click Here >> for more details...
wht r the requirements for writing a cobol-db2 pgm ?
- 4 Answers
- 8772 Views
- IBM, I also Faced
- E-Mail Answers
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 |
What are the different types of base tables?
the dd name for ksds is dest1 and what is the dd name for alternate index of ksds ? a.dest b.dest1 c.dest1a d.dd1
what is difference between Plan and Package
What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)
How would you move a tablespace (using STOGROUP) to a different DASD volume allocated to that tablespace?
What type of database is db2?
I have a DB2 table which has 1000 rows.after udatingg first 110 rows, my job abends. Now what I have to do if I want to restart the job next time so that it should start updating from 111th row (without updating first 110 rows again).
What is cursor with hold option in db2?
What is multi row fetch in db2?
Cursors can be declared in both working-storage & procedure division, Agreed. But is there any difference? If could you please suggest what is the difference. TIA
i want to maintain uniqueness on pdf without make lf??????????
Explain how can you do the explain of a dynamic sql statement?
COBOL 
