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

eliminate dups in VB file


IBM Mainframe Forums -> DFSORT/ICETOOL
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
anatol

Active User


Joined: 20 May 2010
Posts: 121
Location: canada

PostPosted: Tue Feb 13, 2018 2:59 am
Reply with quote

Hello,
I have VB file - is it possible to remove dups checking full record ... I don't know the each record length or positions to check ... just remove dups for full record.
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2481
Location: @my desk

PostPosted: Tue Feb 13, 2018 3:22 am
Reply with quote

anatol wrote:
Hello,
I have VB file - is it possible to remove dups checking full record ... I don't know the each record length or positions to check ... just remove dups for full record.
Yes it is possible. Look for OPTION VLSHRT examples here.
Back to top
View user's profile Send private message
anatol

Active User


Joined: 20 May 2010
Posts: 121
Location: canada

PostPosted: Tue Feb 13, 2018 3:33 am
Reply with quote

yes, OPTION VLSHRT will work with VB, but I don't know the positions to use ON(x,y,f) for NODUPS
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2481
Location: @my desk

PostPosted: Tue Feb 13, 2018 5:56 am
Reply with quote

anatol wrote:
yes, OPTION VLSHRT will work with VB, but I don't know the positions to use ON(x,y,f) for NODUPS
But you know the LRECL of the VB data set, don't you? You just need to substitute the LRECL(- RDW length) in your ON(....) if you are using PGM=ICETOOL or SORT FIELDS=(...) if you are using PGM=SORT.

Keep in mind that NODUPS will suppress ALL the duplicate records. If you need to retain the very first duplicate record you might need FIRST.
Back to top
View user's profile Send private message
anatol

Active User


Joined: 20 May 2010
Posts: 121
Location: canada

PostPosted: Tue Feb 13, 2018 6:32 am
Reply with quote

good idea, but I don't know how to do that. Lets actual length of records are 10,10,30,30,40,40,40,10,50,50 how I should put it in ON parameter?
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8569
Location: Dubuque, Iowa, USA

PostPosted: Tue Feb 13, 2018 5:35 pm
Reply with quote

LRECL has nothing to do with the actual record lengths -- it is a single constant number that represents the longest possible record in the data set.
Back to top
View user's profile Send private message
anatol

Active User


Joined: 20 May 2010
Posts: 121
Location: canada

PostPosted: Tue Feb 13, 2018 6:32 pm
Reply with quote

Sorry - my mistake ... I was thinking that OPTION VLSHRT ignore the records if length is shorter than in ON() parameter. It worked - thank you
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 -> DFSORT/ICETOOL

 


Similar Topics
Topic Forum Replies
This topic is locked: you cannot edit posts or make replies. Writng matched records into output fi... DFSORT/ICETOOL 11
No new posts Compare the file record count percent... DFSORT/ICETOOL 4
No new posts compare two file to find position/dat... SYNCSORT 2
No new posts Converting a file from PD to display ... SYNCSORT 4
No new posts Record count of RECFM=U tape file DFSORT/ICETOOL 17
Search our Forums:

Back to Top