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

SYNCSORT Syntax Error


IBM Mainframe Forums -> JCL & VSAM
Post new topic   This topic is locked: you cannot edit posts or make replies.
View previous topic :: View next topic  
Author Message
ashok_srivatsav
Currently Banned

New User


Joined: 29 Jun 2007
Posts: 15
Location: India, Bangalore

PostPosted: Thu Aug 07, 2008 2:38 pm
Reply with quote

I am getting this error.

OUTREC STATEMENT : SYNTAX ERROR


heres the step.


//STEP01 EXEC PGM=ICEMAN
//SORTIN DD *
>.<
><
/*
//SORTOUT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSIN DD *
OPTION COPY
OUTREC FINDREP=(IN=C'>.<',OUT=C'><')
/*
//*


Can someone pls help?


Regards/Ashok
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10886
Location: italy

PostPosted: Thu Aug 07, 2008 2:46 pm
Reply with quote

did You search the forums for findrep,
if You had You would have found that... the correct syntax as in Frank Yaeger example/suggestion is :
Code:

   OPTION COPY
   INREC FINDREP=(IN=C'>.<',OUT=C'><')


when You post jcl an control cards, remember to use the code tag,
it will preserve formatting and ( especially for sort ) the leading blanks
Back to top
View user's profile Send private message
ashok_srivatsav
Currently Banned

New User


Joined: 29 Jun 2007
Posts: 15
Location: India, Bangalore

PostPosted: Thu Aug 07, 2008 2:51 pm
Reply with quote

now its giving me INREC STATEMENT : SYNTAX ERROR.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8796
Location: Welsh Wales

PostPosted: Thu Aug 07, 2008 2:54 pm
Reply with quote

Have you ever considered posting the messages and codes displayed by the failure to help others help you ?
Back to top
View user's profile Send private message
ashok_srivatsav
Currently Banned

New User


Joined: 29 Jun 2007
Posts: 15
Location: India, Bangalore

PostPosted: Thu Aug 07, 2008 2:57 pm
Reply with quote

SYSIN :
OPTION COPY
INREC FINDREP=(IN=C'>.<',OUT=C'><')
*
WER268A INREC 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
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10886
Location: italy

PostPosted: Thu Aug 07, 2008 2:58 pm
Reply with quote

do You have the proper level of dfsort ptfs
as per Frank Yaeger explanation on new dfsort/icetool features
http://www.ibmmainframes.com/viewtopic.php?t=32376&highlight=findrep

or are You running SYNCSORT ?

when posting error messages, please post the full message, complete with the message identifier and number (WER..... or ICE.....) it will save people time
Back to top
View user's profile Send private message
Aaru

Senior Member


Joined: 03 Jul 2007
Posts: 1287
Location: Chennai, India

PostPosted: Thu Aug 07, 2008 2:59 pm
Reply with quote

Ashok,

WER messages indicates that you are using SYNCSORT and not DFSORT. FINDREP is a new feature added in DFSORT.
Back to top
View user's profile Send private message
ashok_srivatsav
Currently Banned

New User


Joined: 29 Jun 2007
Posts: 15
Location: India, Bangalore

PostPosted: Thu Aug 07, 2008 3:07 pm
Reply with quote

Can anyone pls give me the JCL as to how it shud be for using FINDREP?



Thanks
Back to top
View user's profile Send private message
gcicchet

Senior Member


Joined: 28 Jul 2006
Posts: 1702
Location: Australia

PostPosted: Thu Aug 07, 2008 3:09 pm
Reply with quote

Hi,

which part of Aaru's reply did not make sense ?

Gerry
Back to top
View user's profile Send private message
ashok_srivatsav
Currently Banned

New User


Joined: 29 Jun 2007
Posts: 15
Location: India, Bangalore

PostPosted: Thu Aug 07, 2008 3:11 pm
Reply with quote

Does it mean the same jcl will run fine if DFSORT is installed.


//STEP01 EXEC PGM=ICEMAN
//SORTIN DD *
>.<
><
/*
//SORTOUT DD SYSOUT=*
//SYSOUT DD SYSOUT=*
//SYSUDUMP DD SYSOUT=*
//SYSIN DD *
OPTION COPY
INREC FINDREP=(IN=C'>.<',OUT=C'><')
/*
//*
Back to top
View user's profile Send private message
Aaru

Senior Member


Joined: 03 Jul 2007
Posts: 1287
Location: Chennai, India

PostPosted: Thu Aug 07, 2008 3:18 pm
Reply with quote

Ashok,

Quote:
Does it mean the same jcl will run fine if DFSORT is installed.


Yes, Please be aware that SYNCSORT and DFSORT are two different and competitive sort products.
Back to top
View user's profile Send private message
ashok_srivatsav
Currently Banned

New User


Joined: 29 Jun 2007
Posts: 15
Location: India, Bangalore

PostPosted: Thu Aug 07, 2008 3:26 pm
Reply with quote

Aaru

Does coding PGM=ICETOOL mean that its syncsort or DFsort?



Ashok
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6248
Location: Mumbai, India

PostPosted: Thu Aug 07, 2008 3:28 pm
Reply with quote

Hi,
ashok_srivatsav wrote:
Does it mean the same jcl will run fine if DFSORT is installed.

That's correct.

DFSORT introduced FIND and REPlace function in July, 2008. You'll need z/OS DFSORT V1R5 PTF UK90013 to use it.

Further, DFSORT and SyncSort are competitive products, some funtion introduced in one doesn't mean that it's also been introduced in other as well, however, it may be at times..
Back to top
View user's profile Send private message
Aaru

Senior Member


Joined: 03 Jul 2007
Posts: 1287
Location: Chennai, India

PostPosted: Thu Aug 07, 2008 3:29 pm
Reply with quote

Ashok,

Quote:
Does coding PGM=ICETOOL mean that its syncsort or DFsort?


From manuals:

ICETOOL is a multipurpose DFSORT utility that uses the capabilities of DFSORT to perform multiple operations on one or more data sets in a single step.

SYNCTOOL is the equivalent of ICETOOL for SYNCSORT.

Btw what exactly is your requirement?
Back to top
View user's profile Send private message
ashok_srivatsav
Currently Banned

New User


Joined: 29 Jun 2007
Posts: 15
Location: India, Bangalore

PostPosted: Thu Aug 07, 2008 3:39 pm
Reply with quote

I want to sort FB input records with variable position/length fields, such as comma separated values.


I/P

Marketing,96218,+27365
Development,3807,+1275
Research,7283,+5001
Development,1700,-5316
Research,978,+13562
Development,3807,-158
Research,7283,+5002
Marketing,52,-8736
Development,5781,+2736
Marketing,52,+1603
Research,16072,-2022

O/P shud be like this.
11 bytes of dept name, next 5 bytes of number and next 6 bytes of number including the sign.

Marketing 96218+27365
Development3807 +1275
Research 7283 +5001
Development1700 -5316
Research 978 +13562
Development3807 -158
Research 7283 +5002
Marketing 52 -8736
Development5781 +2736
Marketing 52 +1603
Research 16072-2022


Following is the control card.

INREC PARSE=(%00=(ENDBEFR=Cā€™,ā€™,FIXLEN=11),
%01=(ENDBEFR=Cā€™,ā€™,FIXLEN=5),
%02=(FIXLEN=6)),
OVERLAY=(31:%00,42:%01,47:%02)
SORT FIELDS=(31,11,CH,A,42,5,UFF,A,47,6,SFF,D)
OUTREC BUILD=(1,30)



Should i use PGM=SORT or PGM=ICEMAN or PGM=ICETOOL for this?



Ashok
Back to top
View user's profile Send private message
enrico-sorichetti

Superior Member


Joined: 14 Mar 2007
Posts: 10886
Location: italy

PostPosted: Thu Aug 07, 2008 3:48 pm
Reply with quote

it all depends icon_biggrin.gif

Just to clarify a few points in program naming....

DFSORT ( by IBM ) installs as:
ICEMAN ( with aliases SORT AND DFSORT )
ICETOOL
its messages are prefixed by ICE

SYNCSORT ( by ..... )
SYNCSORT
SYNTOOL
its messages are prefixed by WER

many shops create aliases
SORT and ICEMAN for SYNCSORT
ICETOOL for SYNTOOL
in order not to have to change jcl streams

about the naming in Your organization ask Your support
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6248
Location: Mumbai, India

PostPosted: Thu Aug 07, 2008 3:50 pm
Reply with quote

Hi,

Aarrgghh..what connection does your last post has with the start of this thread.. icon_confused.gif

Check this thread ibmmainframes.com/viewtopic.php?t=1184&highlight=difference+dfsort
and underfstand this:
Quote:

DFSORT is a sort product sold by IBM.
SYNCSORT is a competing product sold by Syncsort, Inc.
And there is one more - CA-SORT, sold by Computer Associates.

Obviously, most shops only buy one of these products.

ICEMAN is just another name (entry point) used for the sort program. It's common practice in shops for the system programmers to set up all the common names as entry points to their purchased SORT product. You will often find that PGM=SYNCSORT and PGM=DFSORT will both work in your shop, and both execute the same sort program (whichever one your shop purchased).

ICETOOL is an expansion to the basic SORT program, that allows you to use alternate (simpler) commands to do multiple sort operations in a single sort step. I think that ICETOOL doesn't do anything that you couldn't do via coding multiple DFSORT steps -- it just makes coding them a bit easier.

ICETOOL is supplied as part of the basic SORT package -- if you have DFSORT, you also have ICETOOL. Many people don't seem to realize this. And some troglydite managements don't understand this, and forbid use of ICETOOL in production, restricting programmers to only SORT steps. Such managements are fools (but, alas, not uncommon).

SYNCTOOL is Syncsort, Inc.'s version of the ICETOOL package.

All these are very similar products -- they all do basic sorting. And they use similar commands. For most basic sort operations, the same commands will work in all the products. When you get into more advanced functions, there are some differences between them -- some functions are only offered in one or the other product, and sometimes different syntax is used for the same operations.


It might need modifiaction, but would provide you a start..

PS.: Sorry Aaru, I was too tempted..

(Post edited by request)
Back to top
View user's profile Send private message
Arun Raj

Moderator


Joined: 17 Oct 2006
Posts: 2481
Location: @my desk

PostPosted: Thu Aug 07, 2008 3:55 pm
Reply with quote

Ashok,

Which version of Syncsort are you using.
PARSE is supported only by Syncsort 1.3

Thanks,
Arun
Back to top
View user's profile Send private message
Anuj Dhawan

Superior Member


Joined: 22 Apr 2006
Posts: 6248
Location: Mumbai, India

PostPosted: Thu Aug 07, 2008 3:57 pm
Reply with quote

Hi Enrico,

Just in case, this
Quote:
Aarrgghh..what connection does your last post has with the start of this thread..
creates any confusion, this was meant for the TS..

I should get my keyboard changed.. icon_redface.gif .. Actually I was taking time in positioning my glasses..36_2_51.gif and you typed by the time..
Back to top
View user's profile Send private message
ashok_srivatsav
Currently Banned

New User


Joined: 29 Jun 2007
Posts: 15
Location: India, Bangalore

PostPosted: Thu Aug 07, 2008 3:58 pm
Reply with quote

mine is 1.2.3
Back to top
View user's profile Send private message
Aaru

Senior Member


Joined: 03 Jul 2007
Posts: 1287
Location: Chennai, India

PostPosted: Thu Aug 07, 2008 4:02 pm
Reply with quote

Ashok,

PARSE is included in SyncSort for z/OS 1.3,

use the below JCL, If that is installed at your site

Code:
//STEPS2   EXEC PGM=ICEMAN                                   
//SYSOUT   DD SYSOUT=*                                       
//SORTIN   DD *                                             
MARKETING,96218,+27365                                       
DEVELOPMENT,3807,+1275                                       
RESEARCH,7283,+5001                                         
/*                                                           
//SYSIN    DD *                                             
  OPTION COPY                                               
  INREC PARSE=(%00=(ENDBEFR=C',',FIXLEN=11),                 
               %01=(ENDBEFR=C',',FIXLEN=5),                 
               %02=(FIXLEN=6)),                             
        BUILD=(%00,%01,%02)                                 
/*                                                           
//SORTOUT  DD SYSOUT=*                                       


Output:

Code:
MARKETING  96218+27365
DEVELOPMENT3807 +1275
RESEARCH   7283 +5001
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 Aug 08, 2008 1:11 am
Reply with quote

Corrections to some of the statements made in this thread:

It was implied that FINDREP can be used with INREC, but not with OUTREC. Actually, DFSORT's new FINDREP function can be used with the INREC, OUTREC and OUTFIL statements. IFTHEN FINDREP is also supported on all three statements.

Quote:
SYNCTOOL is the equivalent of ICETOOL for SYNCSORT
.

ICETOOL is a fully documented feature of DFSORT. SYNCTOOL is not documented. Syncsort's SYNCTOOL is NOT equivalent to DFSORT's ICETOOL. DFSORT's ICETOOL has functions that are NOT available with Syncsort's SYNCTOOL.

Quote:
DFSORT ( by IBM ) installs as:
ICEMAN ( with aliases SORT AND DFSORT )
ICETOOL


DFSORT does not ship "DFSORT" as an alias. It does ship "SORT" as an alias.

Quote:
many shops create aliases
SORT and ICEMAN for SYNCSORT
ICETOOL for SYNTOOL


AFAIK, Syncsort ships these aliases itself. Some shops that migrate from Syncsort to DFSORT do create "SYNCSORT" as an alias for "ICEMAN" since DFSORT does not ship "SYNCSORT" as an alias.

Quote:
I think that ICETOOL doesn't do anything that you couldn't do via coding multiple DFSORT steps -- it just makes coding them a bit easier.


This is a ridiculous statement. "A bit easier"? Try a whole lot easier. Even if you could do "anything" ICETOOL does with just sort steps (unlikely unless you're talking about writing your own E15 or E35 exit with the required logic), you would have to spend a great deal of time figuring out how to do it and it would take several passes in many cases and be less efficient. DFSORT's ICETOOL performs a whole host of functions that are significantly easier to do with ICETOOL then with just sort steps. Why not just say that DFSORT's ICETOOL can't do anything a COBOL program can't do (that at least would be true although it would ignore the fact that people would rather NOT write their own code to do things that they can do with a utility).

I don't understand why anyone would "belittle" the usefulness of DFSORT's ICETOOL or say that it just makes things "a bit easier". There's no question that DFSORT's ICETOOL has become a very important tool for many, many customers and made their jobs easier. I've added new functions to it frequently to allow it to do more and more since I first introduced it in 1991. Just look at the z/OS DFSORT V1R5 PTF UK90013 material to see the significant new functions I just added to DFSORT's ICETOOL including DATASORT, SUBSET, WITHANY, BCOUNT, FIRST(n), FIRSTDUP(n), WRITE(countdd), and so on.
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   This topic is locked: you cannot edit posts or make replies. View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts Syncsort help SYNCSORT 3
No new posts Help on IMS -API URL migrating from P... IMS DB/DC 1
No new posts SYNCSORT-DB2 interface SYNCSORT 0
No new posts JES datasets IO Error ABENDS & Debugging 3
No new posts Error to invoke MPP program through B... IMS DB/DC 3
Search our Forums:

Back to Top