Page 2 of 2

Re: sorting in reverse and keep header and trail record

PostPosted: Sat Aug 08, 2009 10:01 am
by dick scherrer
Hello,

Good to hear you are feeling better. Sorry you were ill.

Which release of Syncsort is used on your system?

Re: sorting in reverse and keep header and trail record

PostPosted: Sat Aug 08, 2009 10:25 am
by leon
Hi Dick,
Which release of Syncsort

I don't understand how to get the release of Syncsort.
maybe Z/os is what you want to know? thx.

Re: sorting in reverse and keep header and trail record

PostPosted: Sat Aug 08, 2009 3:11 pm
by arcvns
leon wrote:I don't understand how to get the release of Syncsort.
leon,

To find the SyncSort release information,run the below SyncSort job. On the top of the SYSOUT from the job run, you'll find the SyncSort version info like 'SYNCSORT FOR Z/OS.....'
//STEP1   EXEC PGM=SORT
//SYSOUT    DD SYSOUT=*
//SORTIN    DD *
//SORTOUT   DD SYSOUT=*
//SYSIN     DD *
  OPTION COPY
/*
BTW, DFSORT and SyncSort are competitive products and most of the syntax is similar in both the products, not forgetting the exclusive features in these products.

Re: sorting in reverse and keep header and trail record

PostPosted: Sat Aug 08, 2009 9:15 pm
by leon
thank you, Mr. Arcvns and Dick,
I'll run your jcl to look for the SyncSort version info.
and then i'll further run my jcl from Mr.Frank , let you know
if I got any output.

//TOOLIN DD *
DATASORT FROM(IN) TO(OUT) HEADER TRAILER USING(CTL1)
/*
//CTL1CNTL DD *
  INREC OVERLAY=(2005:SEQNUM,8,ZD)
  SORT FIELDS=(2005,8,ZD,D)
  OUTFIL FNAMES=OUT,IFTHEN=(WHEN=INIT,BUILD=(1,2004)),
    VLTRIM=C' '
/*


Re: sorting in reverse and keep header and trail record

PostPosted: Sat Aug 08, 2009 9:51 pm
by arcvns
leon,

Frank is a DFSORT Developer and the job provided would work in shops having DFSORT; but the same may or may not work for you since your shop has a different product called SyncSort. But the same could be achieved thru alternative methods in SyncSort. Please post here the SyncSort release info. here

Re: sorting in reverse and keep header and trail record

PostPosted: Sat Aug 08, 2009 10:04 pm
by leon
thanks for your important message. Mr.Arcvns.
I have to post the info you need on Monday because I don't
have permission to use mainframe on weekend. talk to you
on Monday. have a good weekend.

leon

Re: sorting in reverse and keep header and trail record

PostPosted: Mon Aug 10, 2009 9:12 pm
by Frank Yaeger
Leon,

I hope you're feeling better.

I'm a DFSORT developer. DFSORT and Syncsort are competitive products. I'm happy to answer questions on DFSORT and DFSORT's ICETOOL, but I don't answer questions on Syncsort.

Re: sorting in reverse and keep header and trail record

PostPosted: Fri Aug 14, 2009 6:37 pm
by leon
Hi, Frank and All

I'm very happy I can run ICEtool today. everything is ok when I use the above jcl code.
thanks, Frank and all friends. but I still confuse why we can use ICETOOL in syncsort? as you
tell me. the ICETOOL is under dfsort. why? thx.

Re: sorting in reverse and keep header and trail record

PostPosted: Fri Aug 14, 2009 8:58 pm
by Frank Yaeger
You are NOT using DFSORT's ICETOOL. You are using Syncsort's SYNCTOOL. Syncsort ships ICETOOL as an alias for SYNCTOOL so when you have Syncsort and use PGM=ICETOOL you get SYNCTOOL, not ICETOOL.

Note that DFSORT's ICETOOL is fully documented whereas AFAIK there is no documentation available for Syncsort's SYNCTOOL.

DATASORT has been available with DFSORT's ICETOOL since July, 2008. Syncsort copied the function later on.