can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

858

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

4209

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

2116

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?

4246

have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

281

Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.

1339

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 ?

801

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

788

what is utility for parm lib

716

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

811

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

759

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?

880

what is the sqlcode -501

6849

File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

1236

ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE

556