Un-Answered Questions { DB2 }

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

6684


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 ?

1698


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

6211


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

1808


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

4155


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

3778


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

10699


what is db2 restart?

1682


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?

1926


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?

6772


what is the responsibility of the construction superintendent

1652


How to resolve deadlock issue

17901


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

1620


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

3106


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?

1612