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

1 input 2 output with sum SYNCSORT


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
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
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: 1208
Location: Bangalore,India

PostPosted: Wed Oct 31, 2007 10:15 am
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
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
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
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
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: 1287
Location: Chennai, India

PostPosted: Thu Nov 01, 2007 11:22 am
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
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
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

Moderator Emeritus


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

PostPosted: Thu Nov 01, 2007 8:34 pm
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

Superior Member


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

PostPosted: Tue Nov 06, 2007 5:51 pm
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: 1287
Location: Chennai, India

PostPosted: Tue Nov 06, 2007 11:19 pm
Reply with quote

Anuj,

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

Superior Member


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

PostPosted: Wed Nov 07, 2007 1:36 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts TRIM everything from input, output co... DFSORT/ICETOOL 1
No new posts Extracting Variable decimal numbers f... DFSORT/ICETOOL 17
No new posts Sortjoin and Search for a String and ... DFSORT/ICETOOL 1
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Joinkeys - 5 output files DFSORT/ICETOOL 7
Search our Forums:

Back to Top