MVSFORUMS.com

[Pavani Donepudi]

Hi,

I am looking for a solution for the following req. I need to update one column with a value for the entire table records which has approximately 800000 (800 Thousands records). Update is simple but probably because of the huge data, it is resulting in -904.

Unfortunately I need to achieve this only via SQLs.

UPDATE TABLE1
SET COLUMN3 = 'N'
WHERE COLUMN1 = 'A'
AND DATE_COL IS NULL;

Any clue on this would be appreciated.

Regards,
Pavani.

[bauer]

Hi,

-904 = Unavialable resource. Check SQLCA (or Spufi output ..) which resource in unavailable. Is table (pages of table) accessed by other programs/ user during executing your update?

Try lock table before updating.

regards,
bauer