View previous topic :: View next topic
Author
Message
Danielle.Filteau New User Joined: 02 Dec 2014Posts: 16 Location: Canada
Hi,
I'm new to Syncsort and am ready to tear my hair out, for something that should be simple yet all I get are syntax errors.
I have a file header and I wish to add the system date to it, then write it back out. I cannot seem to get OVERLAY to work.
Code:
* Active CCID search Rundate: yyyy-mm-dd-hh.mm.ss
* PF10/PF11 to show additional columns
*
* CCID Env # System Subsys CCID-Eff CCID-Xpry CreateBy
*---+----1----+----2----+----3----+----4----+----5----+----6----+----7-
it ran but didn't overlay anything, the output looks exactly the same as the input.
Code:
SYNCSORT FOR Z/OS 2.1.3.0R U.S. PATENTS: 4210961, 5117495 (C)
SYSIN :
SORT FIELDS=COPY
OUTFIL FNAMES=ACTSRCH,
IFTHEN=(WHEN=(3,8,CH,EQ,C'Active'),
OVERLAY=(49:&DATE4)),
IFTHEN=(WHEN=(3,8,CH,NE,C'Active'),
BUILD=(1,140))
WER813I INSTALLATION OPTIONS IN MFX LOAD LIBRARY WILL BE USED
WER276B SYSDIAG= 11280078, 20442245, 20442245, 22994775
WER164B 6,916K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX REQUESTED,
WER164B 0 BYTES RESERVE REQUESTED, 2,388,660 BYTES USED
WER108I SORTIN : RECFM=FB ; LRECL= 200; BLKSIZE= 27800
WER073I SORTIN : DSNAME=SXSC.NDVRC1.CCID.ACTSRCH.HDR
WER110I ACTSRCH : RECFM=FB ; LRECL= 200; BLKSIZE= 27800
WER074I ACTSRCH : DSNAME=DXF125.SXSC.NDVRC1.CCIDVAL.ACTSRCH
WER410B 5,888K BYTES OF VIRTUAL STORAGE AVAILABLE ABOVE THE 16-MEGABYTE LINE,
WER410B 0 BYTES RESERVE REQUESTED, 2,241,204 BYTES USED
WER405I ACTSRCH : DATA RECORDS OUT 7; TOTAL RECORDS OUT 7
WER211B SYNCSMF CALLED BY SYNCSORT; RC=0000
WER449I SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE
WER416B SORTIN : EXCP'S=1,UNIT=3390,DEV=25C0,CHP=(98999A9B9C9D,1),VOL=END20
WER416B OUTFIL WAS USED FOR SORTOUT
WER054I RCD IN 7, OUT 7
WER169I RELEASE 2.1 BATCH 0539 TPF LEVEL 3.0
WER052I END SYNCSORT - TESTACT,SRCHNXT1,,DIAG=E000,7306,C822,00C4,A8DE,4CAB,8
What the heck am I doing wrong?
thanks
Back to top
daveporcelan Active Member Joined: 01 Dec 2006Posts: 792 Location: Pennsylvania
Try:
Code:
IFTHEN=(WHEN=(3,6,CH,EQ,C'Active'),
I believe it is start,length not start,end
Also you should not need the second IFTHEN statement
Back to top
Danielle.Filteau New User Joined: 02 Dec 2014Posts: 16 Location: Canada
Thank you!!!! that was it.
Back to top
Bill Woodger Moderator Emeritus Joined: 09 Mar 2011Posts: 7309 Location: Inside the Matrix
Note Dave's point about not needing the second IFTHEN. If you are not changing any of the data, you can just leave it as it is (more efficient to run as well as less code).
If you effectively want an ELSE/OTHERWISE, look at IFTHEN=(WHEN=NONE...
Back to top
Danielle.Filteau New User Joined: 02 Dec 2014Posts: 16 Location: Canada
Thanks, the second IFTHEN was removed. On to the next challenge: joining data from 2 files to fill in the report data.
Back to top
Please enable JavaScript!