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
 

 

RDW Error when parsing CSV VB file

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

New User


Joined: 17 Feb 2007
Posts: 39
Location: Chennai

PostPosted: Tue Sep 14, 2010 1:16 pm    Post subject: RDW Error when parsing CSV VB file
Reply with quote

Hi all,

I am using the below Sort card to format a CSV file with a header record (FB format). It works fine as expected.

Code:
//S010 EXEC PGM=ICETOOL
//SYMNAMES DD *
FLD1,%01
FLD2,%02
FLD3,%03
FLD4,%04
COMMA,','
DELM,'~'
/*
//IN1 DD DSN=TSOPURU.CSV.INPUT#FB,DISP=SHR
//TOOLIN DD *
DATASORT FROM(IN1) TO(OUT1) HEADER USING(CTL1)
/*
//CTL1CNTL DD *
 SORT FIELDS=(1,8,CH,A)
 INREC PARSE=(FLD1=(FIXLEN=10,ENDBEFR=COMMA),
              FLD2=(FIXLEN=10,ENDBEFR=COMMA),
              FLD3=(FIXLEN=5,ENDBEFR=COMMA),
              FLD4=(FIXLEN=8,ENDBEFR=COMMA)),
 BUILD=(FLD1,DELM,FLD2,DELM,FLD3,DELM,FLD4,DELM)
/*
//OUT1 DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//TOOLMSG DD SYSOUT=*
//DFSMSG DD SYSOUT=*


Here the input is a FB file. When I change the input to a VB file, I am getting the below error.

Code:
WER108I  IN1      : RECFM=VB   ; LRECL=   255; BLKSIZE= 27998
WER235A  INREC    RDW NOT INCLUDED
WER211B  SYNCSMF  CALLED BY SYNCSORT; RC=0000
WER449I  SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE


I am aware theriotically that this error is because of not including RDW (5 bytes) in the inrec.

Please some advise me how this sort card should be changed.
Back to top
View user's profile Send private message

Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue Sep 14, 2010 2:28 pm    Post subject:
Reply with quote

Please post the "Data Set Information" for the DSN# TSOPURU.CSV.INPUT#FB. because what you say
Quote:
Here the input is a FB file.
and what your error message show
Quote:
WER108I IN1 : RECFM=VB ; LRECL= 255; BLKSIZE= 27998
does not go with each other.
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2433
Location: Netherlands, Amstelveen

PostPosted: Tue Sep 14, 2010 2:45 pm    Post subject:
Reply with quote

Anuj Dhawan wrote:
Please post the "Data Set Information" for the DSN# TSOPURU.CSV.INPUT#FB. because what you say
Quote:
Here the input is a FB file.
and what your error message show
Quote:
WER108I IN1 : RECFM=VB ; LRECL= 255; BLKSIZE= 27998
does not go with each other.


Anuj,

thats after the TS changed the input to a VB dataset.

Quote:
When I change the input to a VB file, I am getting the below error.
Back to top
View user's profile Send private message
purusothaman

New User


Joined: 17 Feb 2007
Posts: 39
Location: Chennai

PostPosted: Tue Sep 14, 2010 2:48 pm    Post subject:
Reply with quote

Dear Peter,

Thanks for clarification provided on behalf of me.

Dear Anuj,

I got the error message only after changing the input to a VB file.

Please let me know if you need any other information.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue Sep 14, 2010 3:19 pm    Post subject:
Reply with quote

Sorry about the fast fingers icon_redface.gif. Try using this:
Code:
BUILD=(1,4,FLD1,DELM,FLD2,DELM,FLD3,DELM,FLD4,DELM)
Back to top
View user's profile Send private message
purusothaman

New User


Joined: 17 Feb 2007
Posts: 39
Location: Chennai

PostPosted: Tue Sep 14, 2010 4:15 pm    Post subject:
Reply with quote

Anuj,

It worked like a breeze . Thanks for the quick solution. icon_biggrin.gif
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


Joined: 22 Apr 2006
Posts: 6258
Location: Mumbai, India

PostPosted: Tue Sep 14, 2010 5:40 pm    Post subject:
Reply with quote

The blind squirrel finds an acorn once in a while ... icon_smile.gif
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 Converting Variable block file to Fix... bhavana yalavarthi DFSORT/ICETOOL 10 Tue May 16, 2017 2:20 pm
No new posts Getting error while opening a variabl... apandey1 COBOL Programming 5 Fri May 05, 2017 12:22 pm
No new posts Issue with NDM process to transmit ES... chetanambi All Other Mainframe Topics 6 Wed May 03, 2017 10:52 am
No new posts File processing vishwakotin Mainframe Interview Questions 9 Fri Apr 28, 2017 11:38 am
No new posts Occurrence of various strings within ... TS70363 JCL & VSAM 1 Thu Apr 27, 2017 8:18 pm


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