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.

487

is it compulsory commitment control in journal?

1299

How do we specify index to include or not during bind process.

1037

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 ?

725

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

2987

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

4721

How to restart a DB2 program?

605

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 ?

1054

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

1046

what is utility for parm lib

984

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?

1123

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?

4856

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

7309

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

5165

what is the responsibility of the construction superintendent

988