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

IDCAMS copy ** Source : flat file ** Destination:VSAM


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

New User


Joined: 13 Oct 2006
Posts: 15

PostPosted: Wed Feb 07, 2007 12:58 pm
Reply with quote

Hi,

My JCL needs to copy a flat file ( record count : 563670 ) into a VSAM file.
Out of the total count given above, 9100 records are not being copied as it gives me the following msg...

IDC3302I ACTION ERROR ON TU47.N@AR.INTERNAL.FORMAT.VSAM
IDC3314I **RECORD OUT OF SEQUENCE - KEY FOLLOWS:
000000 F6F9F8F1 F0F8F3F6 F9F1F0F0 F0F0F0

I ve looked into the msg and there ( in programmer's response ) was a mention of using "skip sequential processing".

Que 1. It asks me to rerun the step with the above "skip sequential processing". How to do that?

Que. 2.Does this "skip sequential processing" require Reuse option to be set for the VSAM file?

Que. 3. I ve read somewhere that during such a copy process, the system stops processing the command ( maybe abends ) if it encounters 4 cases of RECORD OUT OF SEQUENCE. Why hasnt it done so in my case?

Sequencing the input file is not a solution for me as the file size is huge...
Plz help

Raman
Back to top
View user's profile Send private message
William Thompson

Global Moderator


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

PostPosted: Wed Feb 07, 2007 2:27 pm
Reply with quote

You are attempting to load a KSDS file with data that is out of sequence. rather than "skip sequential" processing, sort the input instead of just copying it.
Back to top
View user's profile Send private message
Verma,Raman

New User


Joined: 13 Oct 2006
Posts: 15

PostPosted: Wed Feb 07, 2007 2:56 pm
Reply with quote

Hi William,

I am sorting the file in a previous step. But that sort is not being comprehensive and some records are being missed.

Meanwhile, I tried with some other sort criterias on the same file and got some success...now the problem records are reduced to 35 from 9100 but they are still there.
Thanks...
Back to top
View user's profile Send private message
William Thompson

Global Moderator


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

PostPosted: Wed Feb 07, 2007 3:07 pm
Reply with quote

No records are being missed, the sort is not sorting the complete KSDS key, fix that and all will be good.
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 Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
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
No new posts Need help for File Aid JCL to extract... Compuware & Other Tools 23
Search our Forums:

Back to Top