MVSFORUMS.com Forum Index MVSFORUMS.com
A Community of and for MVS Professionals
 
 FAQFAQ   SearchSearch   Quick Manuals   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Search found 5 matches
MVSFORUMS.com Forum Index
Author Message
  Topic: DELETE utility
paleeshwaran

Replies: 7
Views: 3018

PostForum: Database   Posted: Tue May 25, 2010 2:56 pm   Subject: DELETE utility
Thanks Kolusu! It worked!
  Topic: DELETE utility
paleeshwaran

Replies: 7
Views: 3018

PostForum: 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

PostForum: 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

PostForum: 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

PostForum: 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
 
Page 1 of 1
All times are GMT - 5 Hours
Jump to:  


MVSFORUMS
Powered by phpBB © 2001, 2005 phpBB Group