View previous topic :: View next topic
|
Author |
Message |
srinivas_443
New User
Joined: 19 Dec 2007 Posts: 11 Location: chennai
|
|
|
|
Hi all
Please explain any one….
I have a flat file having duplicates in that and I need to load to VSAM file.
I need to sort before loading into VSAM?
Regards,
Srinivas Jala |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
use DFSORT to sort, drop your dups and load to the vsam file.
lots of examples in the dfsort/utilities forum |
|
Back to top |
|
|
srinivas_443
New User
Joined: 19 Dec 2007 Posts: 11 Location: chennai
|
|
|
|
Hi Brenholtz,
I have one question here with duplicates we can load in to VSAM? VSAm will take duplicates are not? Please clarify this.
Regards,
Srinivas Jala |
|
Back to top |
|
|
prav_06 Warnings : 1 Active User
Joined: 13 Dec 2005 Posts: 154 Location: The Netherlands
|
|
|
|
Hi ,
KSDS cannot take duplicates in its key region, rest ESDS and RRDS can take , so it all boils down to what type of VSAM ds u r using, can u get back with the type of VSAM file u use ???
Thamilzan. |
|
Back to top |
|
|
agkshirsagar
Active Member
Joined: 27 Feb 2007 Posts: 691 Location: Earth
|
|
|
|
Quote: |
I have one question here with duplicates we can load in to VSAM? VSAm will take duplicates are not? |
You can load VSAM file using a PS file which contains duplicate records but duplicates wont get loaded in KSDS file.
There is a parameter named ELIMIT which can control the number of "error records " REPRO will ignore. An error record can be a duplicate.
If the limit specified in ELIMIT is exceeded ( if number of duplicates are more than ELIMIT) then REPRO command will be terminate with an error. |
|
Back to top |
|
|
srinivas_443
New User
Joined: 19 Dec 2007 Posts: 11 Location: chennai
|
|
|
|
Hi
Thanks for all your help and support
Regards,
Srinivas Jala |
|
Back to top |
|
|
|