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: 4648
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: 7931
Location: Bellevue, IA

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 Fail to change physical VSAM filename... jacobdng CICS 0 Fri Jan 20, 2017 12:36 pm
No new posts SORTJOIN - Copy Matched and Unmatched... Steve Ironmonger DFSORT/ICETOOL 5 Tue Jan 17, 2017 4:26 pm
No new posts how to recover an uncataloged VSAM da... archanamuthukrishnan All Other Mainframe Topics 3 Wed Jan 11, 2017 6:18 pm
No new posts OO COBOL compile error Virendra Shambharkar COBOL Programming 3 Tue Jan 10, 2017 6:05 pm
No new posts Underlying DB2 VSAM LDS - SMF recording vasanthz All Other Mainframe Topics 6 Thu Jan 05, 2017 4:20 am


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