Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Usergroups Profile Log in to check your private messages Log in
 

 

Syncsort Process data prior to current day

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Fri Jun 03, 2011 2:53 pm    Post subject: Syncsort Process data prior to current day
Reply with quote

I got the below error. It seems that DATE5 is not recognized.

Code:

 SYNCSORT FOR Z/OS  1.3.2.0R    U.S. PATENTS: 4210961, 5117495   (C) 2007 SYNCSO
                                          XXXXXXXXXXXXXXXX   z/OS   1.11.0   
 PARMEXIT : VSCORET=12M,MSG=SC                                                 
 SYSIN :                                                                       
   SORT FIELDS=COPY                                                             
   OUTREC IFTHEN=(WHEN=INIT,OVERLAY=(38:WKDAY,DATE5,DATE5)),                   
   IFTHEN=(WHEN=(38,3,CH,EQ,C'MON'),OVERLAY=(41:DATE1(-)-3)),                   
   IFTHEN=(WHEN=NONE,OVERLAY=(41:DATE1(-)-1))                                   
   OUTFIL BUILD=(1,37),                                                         
   INCLUDE=((9,26,CH,GE,41,26,CH),AND,(9,26,CH,LE,67,26,CH))                   
 DATA DICTIONARY SYMBOLS SUBSTITUTED :                                         
 SORT FIELDS=COPY                                                               
 OUTREC IFTHEN=(WHEN=INIT,OVERLAY=(38:C'FRI',DATE5,DATE5)),IFTHEN=(WHEN=(38,3,CH
                                             *                                 
 EQ,C'MON'),OVERLAY=(41:DATE1(-)-3)),IFTHEN=(WHEN=NONE,OVERLAY=(41:DATE1(-)-1))
 OUTFIL BUILD=(1,37),INCLUDE=((9,26,CH,GE,41,26,CH),AND,(9,26,CH,LE,67,26,CH)) 
 WER161B  ALTERNATE PARM USED                                                   
 WER268A  OUTREC STATEMENT  : SYNTAX ERROR                                     
 WER211B  SYNCSMF  CALLED BY SYNCSORT; RC=0000                                 
 WER449I  SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE                                 
Back to top
View user's profile Send private message

gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1703
Location: Australia

PostPosted: Fri Jun 03, 2011 2:58 pm    Post subject:
Reply with quote

Hi,

Kolusu's solution is for DFSORT not SYNCSORT which you are using..


Gerry
Back to top
View user's profile Send private message
gylbharat

Active Member


Joined: 31 Jul 2009
Posts: 565
Location: Bangalore

PostPosted: Fri Jun 03, 2011 3:10 pm    Post subject:
Reply with quote

We have DFSORT also installed in the system. But every time it points to SYNCSORT.
Back to top
View user's profile Send private message
Bill Woodger

DFSORT Moderator


Joined: 09 Mar 2011
Posts: 7308

PostPosted: Fri Jun 03, 2011 3:12 pm    Post subject:
Reply with quote

Well, they can't both be in the same load-library, so find where DFSORT is...
Back to top
View user's profile Send private message
PeterHolland

Global Moderator


Joined: 27 Oct 2009
Posts: 2431
Location: Netherlands, Amstelveen

PostPosted: Fri Jun 03, 2011 3:42 pm    Post subject:
Reply with quote

You can use probably use DFSORT/SYNCSORT as PGMNAME.
Back to top
View user's profile Send private message
sqlcode1

Active Member


Joined: 08 Apr 2010
Posts: 578
Location: USA

PostPosted: Fri Jun 03, 2011 7:48 pm    Post subject:
Reply with quote

gylbharat,
Refer to this thread where Frank answered to your question/concern over having DFSort but not being able to use it.

http://ibmmainframes.com/viewtopic.php?p=268648&highlight=#268648

If you are having both (DFSort and Syncsort) installed, then you need to use proper loadlibs to invoke respective sorts. My guess is that you are still referring to DFSort invoked by DB2 utilities.

DATE5 came out with OCT-2010 ptf, so if you "really" have DFSort installed then ask your sysadmin to install latest PTF.
Read about OCT-2010 in Frank's post here :- http://ibmmainframes.com/viewtopic.php?t=51870

Thanks,
Back to top
View user's profile Send private message
Frank Yaeger

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Fri Jun 03, 2011 10:57 pm    Post subject:
Reply with quote

Quote:
You can use probably use DFSORT/SYNCSORT as PGMNAME.


PGM=DFSORT and PGM=SYNCSORT are NOT supported by DFSORT. Of course, a site can assign them as aliases for DFSORT and may well do that with PGM=SYNCSORT, but probably not with PGM=DFSORT.

If a site has Syncsort as the primary sort product (PGM=SORT uses Syncsort), and also has a license for DFSORT, the correct way to use DFSORT (with PGM=SORT) is to JOBLIB or STEPLIB to the correct private libraries in which your System Programmer installed DFSORT.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Data replication from multiple Db2 ta... kishpra DB2 5 Mon Mar 27, 2017 9:58 pm
No new posts Export flat file data into excel sheet murali.andaluri DFSORT/ICETOOL 2 Mon Mar 20, 2017 5:39 pm
No new posts Append data from two files into a sin... Praveen04 DFSORT/ICETOOL 5 Thu Mar 16, 2017 7:29 pm
No new posts How to get current date -1 and curren... murali.andaluri DFSORT/ICETOOL 3 Wed Mar 08, 2017 2:09 pm
No new posts SPUFI -- Joining 3 tables – data in... Sysaron DB2 2 Wed Mar 08, 2017 4:18 am


Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us