In cobol+DB2program if the code of cobol program has changed
than i have to do precompilation once again?
Answers were Sorted based on User's Feedback
Answer / sachin
Yes,
cobol+DB2program(is Main pgm)---->Changed----> Precompile
once again
cobol+DB2program(is Sub pgm)---->Changed(SUB)---->
Precompile (Sub) once again, Precompile(Main) Not required.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / mdvasanth86
If you are making changes to the COBO code and not touching
the Embedded SQL code, you can have the LEVEL - Db2
precompiler option set and Compile and link edit the
program. No BINDING REQUIRED.
| Is This Answer Correct ? | 1 Yes | 1 No |
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?
How do you eliminate duplicate values in db2?
What is the difference between cursor stability and repeatable read isolation levels?
What is coalesce in db2?
Where besides the DB2 catalog is database object information stored by DB2?
a cursor normally gets closed once we provide a commit . If u try to close the same cursor with close cursor command later after providing the commit will there be any sql-error.
What parameters are used to control the free space in DB2?
How could one combine a set of incremental image copies into a single copy?
What is the difference between base table and view?
What is the difference between SYNONYM and ALIAS?
How do we specify index to include or not during bind process.
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...