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: 7315

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: 2433
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 Replace values in the input data Vikas Maharnawar DFSORT/ICETOOL 10 Thu May 11, 2017 2:18 pm
No new posts SMTP the current generation number of... Jyothi Kulunde JCL & VSAM 4 Thu May 04, 2017 4:08 pm
No new posts Issue with NDM process to transmit ES... chetanambi All Other Mainframe Topics 6 Wed May 03, 2017 10:52 am
No new posts Group Data based on a key Arun Raj DFSORT/ICETOOL 7 Thu Apr 27, 2017 11:29 pm
No new posts unload data from table with lob columns farhad_evan DB2 0 Sat Apr 22, 2017 1:32 pm


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