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
 

 

Error while copying records from Flat file into VSAM file...

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
dhanashreeakhade

New User


Joined: 11 Mar 2008
Posts: 8
Location: pune

PostPosted: Tue Apr 07, 2009 7:33 pm    Post subject: Error while copying records from Flat file into VSAM file...
Reply with quote

I have a requirment wherein I want to create a VSAM file from a Flat file.

The Flat file has a record length of 49. (first 10 columns is for the unique key field, rest are for the other data).

In VSAM file, I want the first key field (length 10) and one more field of length 8, i.e. my VSAM file will have a record length of 18.


In one step I have created a VSAM cluster with recordsize(18, 18).
And in other step I am using REPRO to copy the Sequential dataset into VSAM.


REPRO INFILE(REPROIN) OUTFILE(REPROUT)

However I am getting an error as :-
IDC3351I ** VSAM I/O RETURN CODE IS 108 - RPLFDBWD = X'8408006C'
IDC31467I MAXIMUM ERROR LIMIT REACHED.

Can someone help me to get this resolved.

Thanks,
Dhanashree
Back to top
View user's profile Send private message

superk

Moderator Team Head


Joined: 26 Apr 2004
Posts: 4649
Location: Raleigh, NC, USA

PostPosted: Tue Apr 07, 2009 7:36 pm    Post subject: Reply to: Error while copying records from Flat file into VS
Reply with quote

At what point did you sort the flat file so that the keys are in the correct sorted order, and so that the record length has been reduced to 18?
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8593
Location: Back in jolly old England

PostPosted: Tue Apr 07, 2009 7:38 pm    Post subject:
Reply with quote

And have you bothered to look at the messages and codes manual for the relevant message codes before posting here.

This is a help forum, not a manual look up service.
Back to top
View user's profile Send private message
Robert Sample

Global Moderator


Joined: 06 Jun 2008
Posts: 8117
Location: East Dubuque, Illinois, USA

PostPosted: Tue Apr 07, 2009 7:41 pm    Post subject:
Reply with quote

The manuals link at the top of the page includes the Messages and Codes (MAC) which says for IDC3351I I/O error:
Quote:
108
The RECLEN specified was larger than the maximum allowed, equal to 0, or smaller than the sum of the length and the displacement of the key field of the base cluster or related alternate index (AIX). The RECLEN was not equal to the slot size specified for a relative record data set.
Trying to copy a 49-byte record into an 18-byte record does not work. You need to run a utility to extract only the desired 18 bytes before the REPRO or write a program to load only the desired 18 bytes into the file.
Back to top
View user's profile Send private message
arvind.m

Active User


Joined: 28 Aug 2008
Posts: 205
Location: Hyderabad

PostPosted: Tue Apr 07, 2009 7:43 pm    Post subject:
Reply with quote

i think what you are trying do is wrong. See below description.

Code:

IDC3351I ** VSAM {OPEN¦CLOSE¦I/O} RETURN CODE IS return-code             
       {RPLFDBWD=nnnnnnnn}                                               
                                                                         
Explanation:  An error was encountered during virtual storage access     
method (VSAM) open, close, or action request processing, as indicated in
the text of the message.                                                 
                                                                         
In the message text:                                                     
                                                                         
nnnnnnnn  The meaning of RPLFDBWD, the RPL Feedback Word. For detailed   
          information on the RPL Feedback Word, see z/OS DFSMS Macro     
          Instructions for Data Sets.                                   
                                                                         
rc        The return code, as follows:   
For a Logical I/O Error   
  108  The RECLEN specified was larger than the maximum allowed,   
       equal to 0, or smaller than the sum of the length and the   
       displacement of the key field of the base cluster or         
       related alternate index (AIX). The RECLEN was not equal to   
       the slot size specified for a relative record data set.     


Code:

IDC31467I MAXIMUM ERROR LIMIT REACHED                                         
                                                                             
Explanation:  The number of errors encountered has reached the error limit   
value.                                                                       
                                                                             
System Action:  Processing terminates.                                       
                                                                             
Application Programmer Response:  If ERRORLIMIT value is too low, set a       
different value and rerun the job.  ERRORLIMIT has a default value (you       
may wish to allow REPRO to detect more errors than the default value) and     
rerun the job.                                                               
Back to top
View user's profile Send private message
arvind.m

Active User


Joined: 28 Aug 2008
Posts: 205
Location: Hyderabad

PostPosted: Tue Apr 07, 2009 7:45 pm    Post subject:
Reply with quote

Yes as Robert said first you need to copy required fields into another file maybe using SORT and then try to REPRO into a VSAM FILE.
Back to top
View user's profile Send private message
dhanashreeakhade

New User


Joined: 11 Mar 2008
Posts: 8
Location: pune

PostPosted: Tue Apr 07, 2009 7:56 pm    Post subject:
Reply with quote

Thanks for the response.
I will try to copy only required columns in some other dataset and then to the VSAM file.
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
No new posts copying data without knowing location arunsoods DFSORT/ICETOOL 6 Thu Jul 20, 2017 1:03 pm
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


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