|
View previous topic :: View next topic
|
| Author |
Message |
purusothaman
New User
Joined: 17 Feb 2007
Posts: 39
Location: Chennai
|
|
|
|
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 |
|
 |
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
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 |
|
|
PeterHolland
Global Moderator
Joined: 27 Oct 2009
Posts: 2481
Location: Netherlands, Amstelveen
|
|
|
|
| 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 |
|
|
purusothaman
New User
Joined: 17 Feb 2007
Posts: 39
Location: Chennai
|
|
|
|
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 |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
Sorry about the fast fingers  . Try using this:
| Code: |
| BUILD=(1,4,FLD1,DELM,FLD2,DELM,FLD3,DELM,FLD4,DELM) |
|
|
| Back to top |
|
|
purusothaman
New User
Joined: 17 Feb 2007
Posts: 39
Location: Chennai
|
|
|
|
Anuj,
It worked like a breeze . Thanks for the quick solution.  |
|
| Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006
Posts: 6250
Location: Mumbai, India
|
|
|
|
The blind squirrel finds an acorn once in a while ...  |
|
| Back to top |
|
|
|
|
