Page 1 of 1

On Syncsort

Posted: Wed Jul 29, 2009 3:50 pm
by biswaranjan
Hi,

In My input file I'm hving some $ segments. While trying to extract it using sort I'm getting the below error message.

INCLUDE/OMIT FIELD BEYOND RECORD

$ --> Column is 28 and the I/P is a VB file.

$05:ABC
$165:MNO
$11:PQR

I used

SORT FIELDS=COPY
INCLUDE COND=(32,3,CH,EQ,C'$05')

Could anyone help me on this? Is it like $ is not of CH format?

Thanks,
Biswa.

Posted: Thu Jul 30, 2009 8:40 am
by Gerry Ciccheti
Hi Biswa,

as the file is VB, some of recods are less than 34 bytes long ie. your search is reaching beyond the length of the record.

Try adding this before SORT FIELDS=COPY

OPTION VLSHRT



Gerry

Posted: Tue Aug 04, 2009 11:02 pm
by Alissa Margulies
Here is another alternative.

Code: Select all

//S1 EXEC PGM=SORT,PARM='VLTESTI=2'