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
 

 

1 input 2 output with sum SYNCSORT

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

New User


Joined: 13 Mar 2006
Posts: 63
Location: italy

PostPosted: Tue Oct 30, 2007 9:22 pm    Post subject:
Reply with quote

instead this is my problem

Code:

SYNCSORT FOR Z/OS  1.1DRI  TPF3A 

CTL1CNTL :                                                                     
 SORT  FIELDS=(1,17,A,120,2,A,432,1,A,27,8,A),FORMAT=BI                       
 INCLUDE COND=(1,2,BI,NE,X'0000',AND,266,1,CH,NE,C'S',AND,                     
              75,1,CH,NE,C'S',AND,120,2,CH,LE,C'02')                           
 SUM FIELDS=(285,7,PD,292,7,PD,299,7,PD,                                       
             306,5,PD,311,5,PD,421,7,PD,                                       
             444,7,PD,451,7,PD,458,7,PD,                                       
             465,7,PD,472,7,PD,479,7,PD,                                       
             486,7,PD,493,7,PD,                                               
             500,7,PD,507,7,PD)                                               
 OUTFIL FNAMES=OUT1         
                                                   
PARMLIST :                                                                     
  OPTION RESINV=0,ARESINV=0,MSGDDN=SSMSG,SORTIN=IN,SORTOUT=OUT1,SORTDD=CTL1,COPY

WER428I  CALLER-PROVIDED IDENTIFIER IS "0001"                                 
WER164B  8,884K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX REQUESTED,             
WER164B     0 BYTES RESERVE REQUESTED, 1,252,408 BYTES USED                   
WER146B  12K BYTES OF EMERGENCY SPACE ALLOCATED                               
WER050I  SUM CONTROL STATEMENT IGNORED                                         
WER108I  IN       :  RECFM=F    ; LRECL=   550; CISIZE =  4096                 
WER110I  OUT1     :  RECFM=FB   ; LRECL=   550; BLKSIZE= 27500                 


why????
Back to top
View user's profile Send private message

guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Wed Oct 31, 2007 10:15 am    Post subject:
Reply with quote

Hi there,

Would u please post the whole jcl & please use code tab.
Back to top
View user's profile Send private message
krisprems

Active Member


Joined: 27 Nov 2006
Posts: 649
Location: India

PostPosted: Wed Oct 31, 2007 10:29 am    Post subject:
Reply with quote

miosne
you have posted private information like PATENT/LICENSED-SERIAL number for the product you are using, which you are not supposed to.
I request any moderator to remove it from the above post. Thanks.

Miosine, since you are using SYNCSORT 1.1 have got no idea about what features available in that, and am away from mainframe to help you too.
I would prefer you to get the SYNCSORT manual, for details look here
http://ibmmainframes.com/viewtopic.php?t=24768&highlight=margulies or try to catch with Alissa offline icon_wink.gif
Back to top
View user's profile Send private message
krisprems

Active Member


Joined: 27 Nov 2006
Posts: 649
Location: India

PostPosted: Wed Oct 31, 2007 6:11 pm    Post subject:
Reply with quote

Quote:
WER050I SUM CONTROL STATEMENT IGNORED

EXPLANATION: A SUM control statement was specified in a SORT
FIELDS=COPY application. Since a COPY operation does not use
SORT/MERGE key fields, the specification of SUM, which operates
on equally keyed records, is illogical.


ACTION: The SUM statement will be ignored, but the application should be
checked for correct specification of control statements.


This is the description of the error message WER050I.
Looking at the error message feel that you had mentioned SORT FIELDS=COPY, is it so?
Back to top
View user's profile Send private message
miosne
Warnings : 1

New User


Joined: 13 Mar 2006
Posts: 63
Location: italy

PostPosted: Wed Oct 31, 2007 7:39 pm    Post subject: Reply to: 1 input 2 output with sum SYNCSORT
Reply with quote

Thanks a lot krisprems.

Thanck you very much for your patience :oops:

Yes it is.
Back to top
View user's profile Send private message
krisprems

Active Member


Joined: 27 Nov 2006
Posts: 649
Location: India

PostPosted: Wed Oct 31, 2007 11:39 pm    Post subject:
Reply with quote

miosne
Try giving this command in the command line,
Code:
QW WER050I

icon_arrow.gif This should route you to the description of that message
Back to top
View user's profile Send private message
Aaru

Senior Member


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

PostPosted: Thu Nov 01, 2007 11:22 am    Post subject: Reply to: 1 input 2 output with sum SYNCSORT
Reply with quote

krisprems,

Quote:
Try giving this command in the command line, Code:
QW WER050I


Is this command site-specific? am using SYNCSORT and still this command is not working icon_sad.gif

Quote:
This is the description of the error message WER050I.


Please let me know the link to the error message description manual.
Back to top
View user's profile Send private message
krisprems

Active Member


Joined: 27 Nov 2006
Posts: 649
Location: India

PostPosted: Thu Nov 01, 2007 11:31 am    Post subject:
Reply with quote

Quote:
Is this command site-specific?

Yes it is!
Back to top
View user's profile Send private message
krisprems

Active Member


Joined: 27 Nov 2006
Posts: 649
Location: India

PostPosted: Thu Nov 01, 2007 11:46 am    Post subject:
Reply with quote

Quote:
Please let me know the link to the error message description manual.

Aaru, there is no specific link for error codes description(as per knowledge).
You should get it from QW, as i have shown before.
If there is any alternative for QW that's used in your site, then it would help you, check with your seniors icon_rolleyes.gif
Back to top
View user's profile Send private message
dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Thu Nov 01, 2007 8:34 pm    Post subject:
Reply with quote

Hello,

Not everywhere has all of the possible QW info installed.

If your organization is licensed to use Syncsort, all of the info is available from Syncsort (which i would recommend every site to have downloaded and available to anyone who uses the sort).
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


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

PostPosted: Tue Nov 06, 2007 5:51 pm    Post subject: Re: Reply to: 1 input 2 output with sum SYNCSORT
Reply with quote

Aaru wrote:
Is this command site-specific? am using SYNCSORT and still this command is not working icon_sad.gif


QW stands for "Quick Reference", I doubt it that it's not installed on your site. On command prompt when you enter "QW" & press enter, "*MVS/QuickRef *.* - Main Menu *" should be invoked. However, Dick's point cn not be ignored.
Quote:
Not everywhere has all of the possible QW info installed.


But if you are SyncSort user, you can get all the material from them. I tried it once & now I've those documents with me. icon_smile.gif


The description of the error message WER050I is:

Code:
WER050I     SUM CONTROL STATEMENT IGNORED

EXPLANATION: A SUM control statement was speci-fied in a SORT FIELDS=COPY application. Since a COPY  operation  does  not  use SORT/MERGE key fields, the specification of SUM,  which  oper-            ates on equally keyed records, is illogical.

ACTION:  The SUM statement will be ignored, but the application should be checked  for  correct specification of control statements.


By the way "Quick Reference" is like a third-party tool from Chicago-Soft. Here is a bit more info on this:

Quote:
Chicago-Soft acknowledges that portions of MVS/QuickRef's data base content are based on copyrighted work or works owned by IBM Corporation, from whom Chicago-Soft has obtained a limited license. Chicago-Soft alone is responsible for any inaccuracies that may appear within the MVS/QuickRef data base. Customer support for MVS/QuickRef is supplied solely by Chicago-Soft. All questions concerning MVS/QuickRef should be referred directly to Chicago-Soft, Ltd., NOT to IBM.
Back to top
View user's profile Send private message
Aaru

Senior Member


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

PostPosted: Tue Nov 06, 2007 11:19 pm    Post subject: Reply to: 1 input 2 output with sum SYNCSORT
Reply with quote

Anuj,

Thanks a lot for the details.
Back to top
View user's profile Send private message
Anuj Dhawan

Senior Member


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

PostPosted: Wed Nov 07, 2007 1:36 pm    Post subject:
Reply with quote

You are welcome Aaru icon_smile.gif .
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 SYNCSORT SEQNUM and FI fields. nartcr SYNCSORT 5 Sat Jan 21, 2017 4:02 am
No new posts Incorrect output when trying to add n... monica1 PL/I & Assembler 10 Fri Jan 13, 2017 5:02 pm
No new posts Syncsort Help to group fields sudhakarraju SYNCSORT 6 Thu Dec 29, 2016 1:38 am
No new posts Performing arithmetic on input field zh_lad DFSORT/ICETOOL 31 Tue Dec 06, 2016 8:04 pm
No new posts syncsort: copy lines after the keyword shreya19 SYNCSORT 7 Fri Dec 02, 2016 9:47 am


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