IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

Overlay the system date


IBM Mainframe Forums -> SYNCSORT
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
Danielle.Filteau

New User


Joined: 02 Dec 2014
Posts: 16
Location: Canada

PostPosted: Fri Mar 03, 2017 1:16 am
Reply with quote

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
View user's profile Send private message
daveporcelan

Active Member


Joined: 01 Dec 2006
Posts: 792
Location: Pennsylvania

PostPosted: Fri Mar 03, 2017 1:23 am
Reply with quote

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
View user's profile Send private message
Danielle.Filteau

New User


Joined: 02 Dec 2014
Posts: 16
Location: Canada

PostPosted: Fri Mar 03, 2017 2:37 am
Reply with quote

Thank you!!!! that was it.
Back to top
View user's profile Send private message
Bill Woodger

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix

PostPosted: Fri Mar 03, 2017 2:43 am
Reply with quote

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
View user's profile Send private message
Danielle.Filteau

New User


Joined: 02 Dec 2014
Posts: 16
Location: Canada

PostPosted: Fri Mar 03, 2017 2:46 am
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic View Bookmarks
All times are GMT + 6 Hours
Forum Index -> SYNCSORT

 


Similar Topics
Topic Forum Replies
No new posts Sysplex System won't IPL at DR site I... All Other Mainframe Topics 2
No new posts Modifying Date Format Using DFSORT DFSORT/ICETOOL 9
No new posts Need to convert date format DFSORT/ICETOOL 20
No new posts How to delete a user's alias from the... JCL & VSAM 11
No new posts Need help to append a date&tsp at... DFSORT/ICETOOL 9
Search our Forums:

Back to Top