sorting in reverse and keep header and trail record



JES, JES2, JCL utilities, IDCAMS, Compile & Run JCLs, PROCs etc...

Re: sorting in reverse and keep header and trail record

Postby dick scherrer » Sat Aug 08, 2009 10:01 am

Hello,

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

Which release of Syncsort is used on your system?
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times

Re: sorting in reverse and keep header and trail record

Postby leon » Sat Aug 08, 2009 10:25 am

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.
leon
 
Posts: 40
Joined: Tue Nov 25, 2008 7:39 pm
Has thanked: 0 time
Been thanked: 0 time

Re: sorting in reverse and keep header and trail record

Postby arcvns » Sat Aug 08, 2009 3:11 pm

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.
Arun
User avatar
arcvns
 
Posts: 55
Joined: Sat Feb 28, 2009 12:36 am
Location: India
Has thanked: 0 time
Been thanked: 0 time

Re: sorting in reverse and keep header and trail record

Postby leon » Sat Aug 08, 2009 9:15 pm

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' '
/*

leon
 
Posts: 40
Joined: Tue Nov 25, 2008 7:39 pm
Has thanked: 0 time
Been thanked: 0 time

Re: sorting in reverse and keep header and trail record

Postby arcvns » Sat Aug 08, 2009 9:51 pm

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
Arun
User avatar
arcvns
 
Posts: 55
Joined: Sat Feb 28, 2009 12:36 am
Location: India
Has thanked: 0 time
Been thanked: 0 time

Re: sorting in reverse and keep header and trail record

Postby leon » Sat Aug 08, 2009 10:04 pm

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
leon
 
Posts: 40
Joined: Tue Nov 25, 2008 7:39 pm
Has thanked: 0 time
Been thanked: 0 time

Re: sorting in reverse and keep header and trail record

Postby Frank Yaeger » Mon Aug 10, 2009 9:12 pm

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.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 15 times

Re: sorting in reverse and keep header and trail record

Postby leon » Fri Aug 14, 2009 6:37 pm

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.
leon
 
Posts: 40
Joined: Tue Nov 25, 2008 7:39 pm
Has thanked: 0 time
Been thanked: 0 time

Re: sorting in reverse and keep header and trail record

Postby Frank Yaeger » Fri Aug 14, 2009 8:58 pm

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.
Frank Yaeger - DFSORT Development Team (IBM) - yaeger@us.ibm.com
Specialties: JOINKEYS, FINDREP, WHEN=GROUP, ICETOOL, Symbols, Migration
=> DFSORT/MVS is on the Web at http://www.ibm.com/storage/dfsort
User avatar
Frank Yaeger
Global moderator
 
Posts: 1079
Joined: Sat Jun 09, 2007 8:44 pm
Has thanked: 0 time
Been thanked: 15 times

Previous

Return to JCL

 


  • Related topics
    Replies
    Views
    Last post