Syncsort to use date validation in ccyymmdd format

tswastik · New User Joined: 01 Jun 2005 Posts: 3 Location: Minnetonka

Hi,

I was trying to remove the records from my input file on the basis of a date field when that is 72 months older. The field I am looking is in 2075th location and it is in CCYYMMDD format.

SORT FIELDS=COPY
INCLUDE COND=(2075,8,ZD,GE,&DATE1P-2190)
END

The sort control card looks okay. But when I was executing it gives me the following error. Could somebody able to tell me why I am getting Include Beyond Record error.

WER250A INCLUDE/OMIT FIELD BEYOND RECORD
WER211B SYNCSMF CALLED BY SYNCSORT; RC=0000
WER449I SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE

enrico-sorichetti · Posted: Sat Oct 18, 2008 11:13 pm

dick scherrer · Posted: Sat Oct 18, 2008 11:39 pm

Hello and welcome to the forum,

Are you by chance working a variable length file that contains short(er) records?

tswastik · New User Joined: 01 Jun 2005 Posts: 3 Location: Minnetonka

Hi d.sch.,

You are correct, I am using a variable length recrod and my header record was shorter (even though my detail records are of good length). I rectified the issue and now it is working fine.

Thanks for your quick reply on this matter.

dick scherrer · Posted: Mon Oct 20, 2008 9:40 am

You're welcome - good to hear it is working

d

Arun Raj · Posted: Mon Oct 20, 2008 10:11 am