SUM FIELDS=NONE at file level



Support for NetApp SyncSort for z/OS, Visual SyncSort, SYNCINIT, SYNCLIST and SYNCTOOL

Re: SUM FIELDS=NONE at file level !!

Postby dick scherrer » Sun Jul 08, 2012 10:29 am

Hello,

You need to post all of the JCL and sort control statements you submitted along with the complete set of messages (including message ids) generated by the sort step.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: Re: SUM FIELDS=NONE at file level !!

 

Re: SUM FIELDS=NONE at file level !!

Postby ranga_subham » Mon Jul 09, 2012 3:28 pm

I thought SYNCTOOL does this easily........your thoughts please !!

//STEPONE1 EXEC PGM=SYNCTOOL
//SSMSG    DD SYSOUT=*
//TOOLMSG  DD SYSOUT=*
//IN       DD INPUT.DATA,DISP=SHR
//FIRST    DD SYSOUT=*
//SECND    DD SYSOUT=*
//SYSOUT   DD SYSOUT=*
//TOOLIN   DD *
  SELECT FROM(IN) TO(FIRST) ON(1,2,CH) FIRST USING(RAN1)
  SELECT FROM(IN) TO(SECND) ON(4,2,CH) FIRST USING(RAN2)
//RAN1CNTL DD *
  OUTFIL FNAMES=FIRST
//RAN2CNTL DD *
  OUTFIL FNAME=SECND


Thanks.
ranga_subham
 
Posts: 279
Joined: Fri Jul 18, 2008 7:46 pm
Has thanked: 0 time
Been thanked: 1 time

Re: SUM FIELDS=NONE at file level !!

Postby BillyBoyo » Mon Jul 09, 2012 4:04 pm

One mystery cleared up anyway.

Although this is "one step" it is two passes and sorts of the file. And will it work, if you don't sort on the minor key?

Do you need the CNTL files?
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Re: SUM FIELDS=NONE at file level !!

Postby ranga_subham » Tue Jul 10, 2012 3:28 pm

BillyBoyo, Yes, please let me know your solution to this problem.

Thanks.
ranga_subham
 
Posts: 279
Joined: Fri Jul 18, 2008 7:46 pm
Has thanked: 0 time
Been thanked: 1 time

Re: SUM FIELDS=NONE at file level !!

Postby BillyBoyo » Tue Jul 10, 2012 4:15 pm

You haven't answered the questions.

For your question, re-read the whole topic.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Re: SUM FIELDS=NONE at file level !!

Postby Anuj Dhawan » Thu Jul 12, 2012 10:50 am

There are multiple disconnects in this thread. Will try to address as much as I can:

1. This
//SYSIN    DD *
 SORT FIELDS=(4,2,CH,A)
 SUM FIELDS=NONE
/*
with this as input
//SORTIN       DD *
A1 B1             
A2 B2             
A1 B3             
A2 B1             
will give you
A1 B1
A2 B2
A1 B3
as SORTOUT and not what you show, as an example.

2. I, for one, wont' recommend using PipeSort unless you're looking forward to reduce the elapsed time. That's what PipeSort is designed for.
Anuj
Anuj Dhawan
 
Posts: 274
Joined: Mon Feb 25, 2008 3:53 am
Location: Mumbai, India
Has thanked: 6 times
Been thanked: 4 times

Re: SUM FIELDS=NONE at file level !!

Postby Anuj Dhawan » Thu Jul 12, 2012 10:55 am

3. Your SYNCTOOL is correct, as far as I can make out of this thread, what error are you getting? If you wanted to say that, the SYNCTOOL Job ended with RC=16 then I'd say - in OUTFIL statement you're missing "S" in FILENAMES. If that's the problem you get, change this
//RAN2CNTL DD *
  OUTFIL FNAME=SECND
to
//RAN2CNTL DD *
OUTFIL FNAMES=SECND
and all should be well.

If this is not the problem, please explain again and answer the question which have been asked.
Anuj
Anuj Dhawan
 
Posts: 274
Joined: Mon Feb 25, 2008 3:53 am
Location: Mumbai, India
Has thanked: 6 times
Been thanked: 4 times

Re: SUM FIELDS=NONE at file level !!

Postby ranga_subham » Thu Jul 12, 2012 2:45 pm

Hi Anuj, thanks for identifying the mistake....... its working.
ranga_subham
 
Posts: 279
Joined: Fri Jul 18, 2008 7:46 pm
Has thanked: 0 time
Been thanked: 1 time

Re: SUM FIELDS=NONE at file level !!

Postby Anuj Dhawan » Thu Jul 12, 2012 6:11 pm

Glad, it helped.
Anuj
Anuj Dhawan
 
Posts: 274
Joined: Mon Feb 25, 2008 3:53 am
Location: Mumbai, India
Has thanked: 6 times
Been thanked: 4 times

Previous

Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post