| Author |
Message |
Topic: DELETE utility |
paleeshwaran
Replies: 7
Views: 3018
|
Forum: Database Posted: Tue May 25, 2010 2:56 pm Subject: DELETE utility |
| Thanks Kolusu! It worked! |
Topic: DELETE utility |
paleeshwaran
Replies: 7
Views: 3018
|
Forum: Database Posted: Tue May 25, 2010 1:06 pm Subject: DELETE utility |
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 ... |
Topic: DELETE utility |
paleeshwaran
Replies: 7
Views: 3018
|
Forum: Database Posted: Tue May 25, 2010 12:57 pm Subject: DELETE utility |
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 ... |
Topic: DELETE utility |
paleeshwaran
Replies: 7
Views: 3018
|
Forum: Database Posted: Tue May 25, 2010 12:53 pm Subject: DELETE utility |
| 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 ... |
Topic: DELETE utility |
paleeshwaran
Replies: 7
Views: 3018
|
Forum: Database Posted: Tue May 25, 2010 12:47 pm Subject: DELETE utility |
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 |
| |