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

Syncsort Process data prior to current day
IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic Quick References
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
 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: 1702
Location: Australia
PostPosted: Fri Jun 03, 2011 2:58 pm
 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
 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

Moderator Emeritus


Joined: 09 Mar 2011
Posts: 7309
Location: Inside the Matrix
PostPosted: Fri Jun 03, 2011 3:12 pm
 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: 2481
Location: Netherlands, Amstelveen
PostPosted: Fri Jun 03, 2011 3:42 pm
 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: 577
Location: USA
PostPosted: Fri Jun 03, 2011 7:48 pm
 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.

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 :- ibmmainframes.com/viewtopic.php?t=51870

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

DFSORT Developer


Joined: 15 Feb 2005
Posts: 7129
Location: San Jose, CA
PostPosted: Fri Jun 03, 2011 10:57 pm
 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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 

Similar Topics
Topic Forum Replies
No new posts Store the data for fixed length COBOL Programming 1
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Data set Rec-Cnt and Byte-Cnt Testing & Performance 2
No new posts SCOPE PENDING option -check data DB2 2
No new posts To get the the current time DFSORT/ICETOOL 13
Search our Forums:

Back to Top
IBMMainframes.com is not an official and/or affiliated with IBM® in anyway
Board Rules | FAQ | Downloads | Wiki | SiteMap | Contact Us