wht r the requirements for writing a cobol-db2 pgm ?

Answers were Sorted based on User's Feedback



wht r the requirements for writing a cobol-db2 pgm ?..

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

wht r the requirements for writing a cobol-db2 pgm ?..

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

wht r the requirements for writing a cobol-db2 pgm ?..

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

wht r the requirements for writing a cobol-db2 pgm ?..

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

Post New Answer

More DB2 Interview Questions

How do I start db2 in windows?

0 Answers  


Explain what are the various isolation levels possible?

0 Answers  


How do I add a column to a table in db2?

0 Answers  


What is RUNSTATS?

3 Answers  


What is the use of value function?

0 Answers  






My DB2 program first read the data from a file and then it look into a table with the data it got from the file.If we did not bind the program , should the file read before SQL execution be success??

2 Answers   Xansa,


Name the lockable units in DB2?

0 Answers  


Is schema the same as database?

0 Answers  


What is cursor with hold option in db2?

0 Answers  


What is a clustering index?

2 Answers  


What information can you find in SYSIBM.SYSLINKS table?

1 Answers   TCS,


What is sqlcode -811?

7 Answers   Accenture, CTS, TCS,


Categories