MVSFORUMS.com

[paleeshwaran]

Hi,

Greetings! I am trying to find if there is any DB2 utility where we can DELETE rows from a table, by reading primary key from a file.

Please advise and Thanks in Advance!

~ Peace
Palee

[kolusu]

paleeshwaran,

It would be easier to just unload the file and remove the duplicates based on the primary key and reload it back again. Alternatively you can generate the Delete SQL commands reading a file and run it thru DSNTIAUL

Kolusu

[paleeshwaran]

Actually i thought about that option. But my DB have too many bad data, So if i remove duplicates the chances of Bad data being picked up for LOAD are high. So, i am thinking of an option where i can DELETE based on primary key extract from a file. Please advice

[paleeshwaran]

Kolusu,

Apologies! i just noticed your recommendation on DSNTIAUL. Could you please let know delete command that should be given in SYSIN and how the where clause of DELETE can be referrenced to a file value? Thanks

[kolusu]

[paleeshwaran]

I have a primary key which is timestamp and no duplicates. I have account record which are duplicates some of them are bad data and some of them are good data.

For example below is the data that i have
2009-01-01.00.00.00.000001 ACCOUNT1 XXXXXGOOD
2009-01-01.00.00.00.000002 ACCOUNT1 XXXXXBAD
2009-01-01.00.00.00.000003 ACCOUNT2 XXXXXBAD1
2009-01-01.00.00.00.000004 ACCOUNT2 XXXXXBAD2
2009-01-01.00.00.00.000005 ACCOUNT2 XXXXXGOOD

I just want to delete only record 2, 3 & 4. I already have them in a file. Now i am looking for a utility to delete these records based on primary key(which is the timestamp)

[kolusu]

[paleeshwaran]

Thanks Kolusu! It worked!