Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

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

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
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    Post subject: IDCAMS copy ** Source : flat file ** Destination:VSAM
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: 3158
Location: Tucson AZ

PostPosted: Wed Feb 07, 2007 2:27 pm    Post subject:
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    Post subject:
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: 3158
Location: Tucson AZ

PostPosted: Wed Feb 07, 2007 3:07 pm    Post subject:
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    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
This topic is locked: you cannot edit posts or make replies. Fetching data from BAI File arunsoods JCL & VSAM 1 Wed Jul 19, 2017 4:28 pm
No new posts Write out NODUPS but just from one file Jay Villaverde DFSORT/ICETOOL 8 Fri Jul 14, 2017 12:44 am
No new posts How to add header with Date(YYMMDD) i... Rajan Moorthy DFSORT/ICETOOL 2 Thu Jul 06, 2017 11:44 pm
No new posts How to generate a new unique Input fi... for1ranjith CLIST & REXX 11 Sat Jul 01, 2017 12:09 pm
No new posts Writing a file using online program grvtomar PL/I & Assembler 3 Fri Jun 30, 2017 1:06 pm


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us