IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

SUGGEST ME TO REMOVE DUPLICATES while loading


IBM Mainframe Forums -> DB2
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Sachinincsc

New User


Joined: 01 Oct 2008
Posts: 11
Location: Philadelphia, USA

PostPosted: Tue Oct 21, 2008 3:58 pm
Reply with quote

Can you please suggest me the LOAD CARD if I need to remove the DUPLICATES and Also the RESUME YES option.

I know RESUME YES will automatically remove the duplicates but in my case there is no primary key on the TABLE.

So the LOAD is not removing the DUPLICATES.

Is There Any way to Check while loading that for certain particular columns if the values are same We can discard the records ??
Back to top
View user's profile Send private message
anandinmainframe

Active User


Joined: 31 May 2007
Posts: 171
Location: India

PostPosted: Tue Oct 21, 2008 4:05 pm
Reply with quote

Hi Sachin,
As you dont have primary key on the TABLE, why dont you sort it on the whole length.
Back to top
View user's profile Send private message
Sachinincsc

New User


Joined: 01 Oct 2008
Posts: 11
Location: Philadelphia, USA

PostPosted: Tue Oct 21, 2008 4:59 pm
Reply with quote

I Wish I could..

but requirement is little precise as i mentioned. I CANT add a SORT step in the Load JCL.
Back to top
View user's profile Send private message
acevedo

Active User


Joined: 11 May 2005
Posts: 344
Location: Spain

PostPosted: Tue Oct 21, 2008 5:08 pm
Reply with quote

AFAIK, the only way is creating a unique index on those columns.
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10872
Location: italy

PostPosted: Tue Oct 21, 2008 6:35 pm
Reply with quote

Quote:
but requirement is little precise as i mentioned. I CANT add a SORT step in the Load JCL.


has anybody thought , instead of removing the duplicates, about removing people who set such &derogatory_adjective requirements ..

Quote:
...the only way is creating a unique index on those columns. ...


but maybe there is also a requirement not to create indexes icon_biggrin.gif

Homework ????
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> DB2

 


Similar Topics
Topic Forum Replies
No new posts Sortjoin and Search for a String and ... DFSORT/ICETOOL 1
No new posts Remove leading zeroes SYNCSORT 4
No new posts How to remove block of duplicates DFSORT/ICETOOL 8
This topic is locked: you cannot edit posts or make replies. Compare files with duplicates in one ... DFSORT/ICETOOL 11
No new posts To Remove spaces (which is in hex for... JCL & VSAM 10
Search our Forums:

Back to Top