On Syncsort

In this Mainframe Forum - You can post your queries on DFSORT, ICETOOL , SyncSort & JCL Utilities

Moderators: Frank Yaeger, Moderator Group

Post Reply
biswaranjan
Member
Posts: 20
Joined: Thu Aug 28, 2008 10:41 am

On Syncsort

Post by biswaranjan » Wed Jul 29, 2009 3:50 pm

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.

Gerry Ciccheti
Member
Posts: 16
Joined: Thu Jul 30, 2009 7:52 am

Post by Gerry Ciccheti » Thu Jul 30, 2009 8:40 am

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

Alissa Margulies
Member
Posts: 25
Joined: Tue Apr 28, 2009 10:53 pm
Location: USA
Contact:

Post by Alissa Margulies » Tue Aug 04, 2009 11:02 pm

Here is another alternative.

Code: Select all

//S1 EXEC PGM=SORT,PARM='VLTESTI=2'
Alissa Margulies
SyncSort Mainframe Product Services
zos_tech@syncsort.com
201-930-8260

Post Reply

FREE TUTORIALS

Tutorials
Free tutorials from mainframegurukul
  • JCL Tutorial
    Covers all important JCL concepts.
  • Cobol Tutorial
    This tutorials covers all Cobol Topics from STRING to COMP-3.
  • DB2 Tutorial
    DB2 Tutorial focuses on DB2 COBOL Programming.
  • SORT Tutorial
    This Tutorial covers all important aspects of DFSORT with examples
  • CICS Tutorial
    This CICS tutorial covers CICS concepts and CICS Basics, CICS COBOL Programming.
Interview
Mainframe Interview questions



Other References
Mainframe Tools and others