Interested to Buy Any Domain ? << Click Here >> for more details...
wht r the requirements for writing a cobol-db2 pgm ?
- 4 Answers
- 8828 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 |
How to resolve -917 sql code in DB2?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
i know the stpes 2 create an executable CICS/DB2 cobol code. 1. DB2 Precompiler converts the SQL Statements into COBOL API statements and creates another member with Acess plans. CodeA results in CodeB (code with API calls) & CodeC ( Access Plans ) 2.Code B is compiled/linked 2 create an exceutable.(codeE) 3.Now CodeC is binded to the database on which CodeE will be run. Can somebody provide me the sample JCLs for precompile/compile/link/bind.
Which isolation level provides highest data integrity?
What is cursor stability in db2?
What is database manager in db2?
What is a Resource Control Table(RCT)? Describe its characteristics.
How to find primary key of a table in db2?
how to resolve -811
how to resolve -805 . how to see dbrm and package not found
In BIND, isolation level parameter specifies the duration of page lock and ACQUIRE, RELEASE also do almost the same thing. What is the exact difference between the two? Do they work in conjunction while executing SQL queries and obtaining locks?
which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit
COBOL 
