Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist 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: 2441
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 Compare yesterday's date to the one o... migusd SYNCSORT 8 Fri Sep 22, 2017 11:35 pm
No new posts FUSE - IBM MQ - CICS integration error Kevin Vaz CICS 1 Mon Sep 18, 2017 4:31 pm
No new posts Split 1 file into 10 output Files - S... Prasanth Kumar SYNCSORT 5 Sat Sep 16, 2017 12:02 am
No new posts BUILD OUTFIL based on condition other... balaji81_k DFSORT/ICETOOL 13 Fri Sep 08, 2017 11:06 pm
No new posts Reply MQ open error Vignesh Sid COBOL Programming 5 Thu Sep 07, 2017 6:02 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us