what is the process of precompiler?2 9943
what is REORG? what is the use?4 8668
How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?2 4014
How do you filter out the rows retrieved from a Db2 table ?1 5785
What is a clustered index?1 9074
When will you chose to run RUNSTATS?1 6051
What does DML stand for and what are some examples of it?3 4863
What is meant by a unit of recovery?1 3371
What is CHECK PENDING ?4 11129
What is a thread?3 3991
What is filter factor?2 7369
What's the maximum number of volumes that can be added to a STOGROUP?1 6033
I am having n number of records in a table which consists of emp-name is one of the field among them. Now i want to change the first letter of every name with capital.
is it compulsory commitment control in journal?
How do we specify index to include or not during bind process.
While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?
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 ?...
can we view the access paths created by dbrm ? how ? thx
How to restart a DB2 program?
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 ?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
what is utility for parm lib
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?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
How to test SQL -911 error while developing COB-DB2 program
what is the responsibility of the construction superintendent