wht r the requirements for writing a cobol-db2 pgm ?
- 4 Answers
- 7595 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 will the DB2 optimizer do?
What is db2 optimizer?
What is referential integrity?
How to fetch the uncommited data from table ?
How to compare data between two tables in db2?
cobol-db2 runjcl please?
How to find primary key of a table in db2?
What are leaf pages?
1) I have 3 programs : PGMA, PGMB, PGMC. PGMA calls PGMB and PGMB calls PGMC. I have to do inserts, updates in all the 3 pgms. 2) Say PGMC has done its work successfully and returned to PGMB 3) PGMB had an SQL error while doing some update 4) PGMA has already done some updates before calling PGMB all are running under the same CICS region. What will happen if I issue SYNCPOINT ROLLBACK in PGMB when it abends ? Does all the changes in PGMA,B,C rollback ? (because all the pgms belong to same task).
In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?
Before you give the explain statement, what are the prerogatives?
Do we need cursor for Count(*)?
COBOL 
