View previous topic :: View next topic
|
Author |
Message |
dhanashreeakhade
New User
Joined: 11 Mar 2008 Posts: 8 Location: pune
|
|
|
|
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 |
|
|
superk
Global Moderator
Joined: 26 Apr 2004 Posts: 4652 Location: Raleigh, NC, USA
|
|
|
|
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 |
|
|
expat
Global Moderator
Joined: 14 Mar 2007 Posts: 8797 Location: Welsh Wales
|
|
|
|
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 |
|
|
Robert Sample
Global Moderator
Joined: 06 Jun 2008 Posts: 8697 Location: Dubuque, Iowa, USA
|
|
|
|
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 |
|
|
arvind.m
Active User
Joined: 28 Aug 2008 Posts: 205 Location: Hyderabad
|
|
|
|
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 |
|
|
arvind.m
Active User
Joined: 28 Aug 2008 Posts: 205 Location: Hyderabad
|
|
|
|
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 |
|
|
dhanashreeakhade
New User
Joined: 11 Mar 2008 Posts: 8 Location: pune
|
|
|
|
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 |
|
|
|