| View previous topic :: View next topic |
| Author |
Message |
bundy_rum
Beginner
Joined: 15 Feb 2004
Posts: 9
Topics: 5
Location: Australia
|
 Posted: Tue Mar 14, 2006 12:39 am Post subject: Out-Of-Seq records in KSDS |
 |
|
ANyone got any idea's as to how I can backup/eliminate my out-of-seq records in my KSDS. I'm using just a straight REPRO infile/outfile. I have about 100 records that are out-of seq. I would like to get these records into a file by itself, so I can sort and reload.
Cheers... |
|
| Back to top |
|
 |
Ravi
Beginner
Joined: 27 Jun 2005
Posts: 88
Topics: 2
|
| Posted: Tue Mar 14, 2006 12:43 am Post subject: |
|
|
| Use SORT with vsam-key ascending as the sort criteria. This should solve the problem |
|
| Back to top |
|
|
bundy_rum
Beginner
Joined: 15 Feb 2004
Posts: 9
Topics: 5
Location: Australia
|
| Posted: Tue Mar 14, 2006 12:47 am Post subject: |
|
|
| Thks - have you got an example to help illustrate ? |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12369
Topics: 75
Location: San Jose
|
| Posted: Tue Mar 14, 2006 8:53 am Post subject: |
|
|
| Quote: |
Thks - have you got an example to help illustrate ?
|
bundy_rum,
Try this
| Code: |
//STEP0100 EXEC PGM=SORT
//SYSOUT DD SYSOUT=*
//SORTIN DD DSN= YOUR FLAT FILE WITH OUT OF SEQ KEYS,
// DISP=SHR
//SORTOUT DD DSN=YOUR VSAM CLUSTER,
// DISP=OLD
//SYSIN DD *
SORT FIELDS=(P,L,FM,A)
/*
//* P = Position of the key
//* L = Length of the key field
//* FM = Format of the key field (Ch for character...)
//* A = Ascending sequence
|
Hope this helps.....
Cheers
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
bundy_rum
Beginner
Joined: 15 Feb 2004
Posts: 9
Topics: 5
Location: Australia
|
| Posted: Wed Mar 15, 2006 12:29 am Post subject: |
|
|
Thks - the issue I have is the only data I have is in the VSAM file itself. I have no seq file of the data to sort. So, how do I create the seq file ? (REPRO doesn't seem to work as it ejects the out-of-seq records - If I could capture these, that would be different!). Having the KSDS as the input to the sort, doesn't seem to work either.
Cheers |
|
| Back to top |
|
|
kolusu
Site Admin
Joined: 26 Nov 2002
Posts: 12369
Topics: 75
Location: San Jose
|
| Posted: Wed Mar 15, 2006 8:09 am Post subject: |
|
|
| Quote: |
Having the KSDS as the input to the sort, doesn't seem to work either.
|
bundy_rum,
Sort can be used to sort a vsam KSDS. What exactly do you want to do ? It is not clear as to what you are trying to do. Please post a detailed information about what you are trying to accomplish and we will suggest a solution.
Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu |
|
| Back to top |
|
|
bundy_rum
Beginner
Joined: 15 Feb 2004
Posts: 9
Topics: 5
Location: Australia
|
| Posted: Thu Mar 16, 2006 12:51 am Post subject: |
|
|
Hi - I am trying to back up the data, but get IDC3314I **RECORD OUT OF SEQUENCE - KEY FOLLOWS: messages. REPRO is not working and a SORT gives me ICE076A 0 VSAM INPUT ERROR L(12) SORTIN ?
Cheers |
|
| Back to top |
|
|
Frank Yaeger
Sort Forum Moderator
Joined: 02 Dec 2002
Posts: 1618
Topics: 31
Location: San Jose
|
| Posted: Thu Mar 16, 2006 11:30 am Post subject: |
|
|
The ICE076A L(12) error means "An attempt was made to perform sequential or skip-sequential processing against a record whose key/record number does not follow the proper ascending/descending sequential order". I think that's telling you you can't process a VSAM data set with out-of-sequence keys in the normal way (VSAM GET). The key is defined as part of the VSAM data set and has nothing to do with what you specify for DFSORT, so I don't think a COPY will work either.
_________________
Frank Yaeger - DFSORT Development Team (IBM)
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
DFSORT is on the Web at:
www.ibm.com/storage/dfsort |
|
| Back to top |
|
|
|
|
|
FAQ
Search
Quick Manuals
Register
Profile
Log in to check your private messages
Log in
