|
View previous topic :: View next topic
|
| Author |
Message |
Danielle.Filteau
New User
Joined: 02 Dec 2014
Posts: 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 2006
Posts: 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 2014
Posts: 16
Location: Canada
|
|
|
|
| Thank you!!!! that was it. |
|
| Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011
Posts: 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 2014
Posts: 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 |
|
|
|
|
  |
All times are GMT + 6 Hours |
|
