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

Copy QSAM to VSAM using IDCAMS: RECORD OUT OF SEQUENCE ERROR


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8797
Location: Welsh Wales

PostPosted: Fri May 18, 2007 3:43 pm
Reply with quote

Quote:

KSDS key length: 23
KSDS key location: 8


This isn't LISTCAT - probably fileaid. Is the key location shown an offset or true position.

Also, back in the dark and distant past I recall when an extended facilities KSDS was defined the same problem ocurred, and was fixed by increasing the length of the VSAM definition by 4. Maybe worth trying with a 70 70 definition.
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3156
Location: Tucson AZ

PostPosted: Fri May 18, 2007 3:48 pm
Reply with quote

Shrimathi Krishnan wrote:
fixed block sire.. recl=66
How can you prove this?

What was the sort message number that preceded this error:
RECORD OUT OF SEQUENCE - KEY FOLLOWS :
000000 F2F8F8F6 F2F9F9E2 F0
What does the above number represent, it is only nine bytes long?

What does the following represent:
cusno billnum
2890 100
2899 201
2899 202
2899 203
The above does not coincide to the VSAM key or the sorted fields of STTNO and KEYDTE?

SORT FIELDS=(9,19,CH,A,28,4,BI,A)

CUSNO01 1 66 66
3 CUSNOK3 GROUP
5 CUSNO X(7)
5 CUSNOTPE X
5 CUSNOK1 GROUP
7 STTNO X(19)
7 KEYDTE S9(9) comp

KSDS key length: 23
KSDS key location: 8
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Fri May 18, 2007 7:34 pm
Reply with quote

Hello,

Your sort fields do not look at all like your sample data icon_confused.gif
Back to top
View user's profile Send private message
Shrimathi Krishnan

New User


Joined: 19 Apr 2007
Posts: 39
Location: Chennai

PostPosted: Mon May 21, 2007 11:36 am
Reply with quote

Hi all

Thanks a lot for all ur time and suggestions. As suggested i checked again with the sort fields and also made a change in the VSAM cluster definition. I got the desired output..
Once again thanks a lot to all of you....
Back to top
View user's profile Send private message
dick scherrer

Moderator Emeritus


Joined: 23 Nov 2006
Posts: 19244
Location: Inside the Matrix

PostPosted: Tue May 22, 2007 3:13 am
Reply with quote

You're welcome icon_smile.gif
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 -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts How to split large record length file... DFSORT/ICETOOL 10
No new posts Error to read log with rexx CLIST & REXX 11
No new posts Error when install DB2 DB2 2
No new posts SFTP Issue - destination file record ... All Other Mainframe Topics 2
No new posts Access to non cataloged VSAM file JCL & VSAM 18
Search our Forums:

Back to Top