Un-Answered Questions { DB2 }

How to test SQL -911 error while developing COB-DB2 program

6706


before altering a table is it necessary to lock ? if lock what is it ? how to do ? ifi want to lock a table what is that command ?

1710


can we view the access paths created by dbrm ? how ? thx

6236


What r the comman abends in db2, jcl and cobol???????

1814


what is diffrence b/w file-aid tool and file-aid utility???

4172


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 ?...

3786


SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

10745


what is db2 restart?

1687


I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1934


Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?

6817


what is the responsibility of the construction superintendent

1660


How to resolve deadlock issue

17943


i want to maintain uniqueness on pdf without make lf??????????

1629


When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?

3114


in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

1622