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 |
What is table space in db2?
explain about index with examples
How many Buffer pools are there in DB2 and what are they?
Mention the downsides of page level lock.
What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?
Explain packages.
What are the functions in DB2?
can you use symbolic parameters in JOB?
What is the function of buffer manager?
On which levels locks can be applied?
What is normalization and what are the five normal forms?
What does db2 blu stand for?