SYNCSORT Report for Dummies



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

SYNCSORT Report for Dummies

Postby JohnH » Thu Oct 11, 2012 4:44 pm

I've been using SYNCSORT for years, but only for simplistic sorting. Now, I'd like to take better advantage of the product by using it for reporting, but I'm finding the book hard to understand. Basically, I need to select SMF70 subtype 1 records, sort them by date/time, and print a report. The report would have one row for each record and includes, at a minimum, the date, time, and field SMF70LAC printed in the form mm/dd/yyyy, hh:mm:ss, and ###,###,##0.00. I would like the input to be from SORTIN, the sorted output (if required) to go to SORTOUT, and the report to go to SORTRPT. My requirement is much more complex than this, but if you can get me "kick started" with the above, I can do the rest.

Question: Is there a book somewhere like "Smart DFSORT Tricks", only for SYNCSORT?

Thanks in advance.
JohnH
 
Posts: 8
Joined: Wed May 27, 2009 7:22 pm
Has thanked: 0 time
Been thanked: 0 time

Re: SYNCSORT Report for Dummies

 

Re: SYNCSORT Report for Dummies

Postby BillyBoyo » Thu Oct 11, 2012 6:56 pm

Unfortunately I've never heard of such a publication. SyncSort don't even provide documentation for SyncTool, as far as I know.

You could contact SyncSort to check anyway.

Which leaves you google, searching here, searching the sister-forum (for non-students and beginners) www.ibmmainframes.com. And doing the "obvious" with what you have located already.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Re: SYNCSORT Report for Dummies

Postby dick scherrer » Thu Oct 11, 2012 9:41 pm

Hello,

Question: Is there a book somewhere like "Smart DFSORT Tricks", only for SYNCSORT?
No, but many of the DFSORT Smart Tricks work with the more current release of Syncsort. They will probably never be exactly the same.

We have several people with considerable experience using Syncsort, but Syncsort Support has exponentially more depth.

I believe when one starts working with SMF data, the work has moved beyond "dummies" :)
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: SYNCSORT Report for Dummies

Postby c62ap90 » Fri Oct 12, 2012 5:32 am

I have a handful of pdf's I use for SyncSort. Great Report examples too. Can I download somehow?

SyncSort for zOS 1[1].3.2 PG.pdf size 4553k
Exploiting Join in SyncSort for zOS.pdf size 252k
Exploiting Sortwriter Book I.pdf size 1117k
Exploiting Sortwriter Book II.pdf size 153k
Maxsort Exploitation Guide.pdf size 239k
SYMNAMES-zOS13Addendum.pdf size 176k
c62ap90
 
Posts: 125
Joined: Thu Oct 11, 2012 10:24 pm
Has thanked: 1 time
Been thanked: 6 times

Re: SYNCSORT Report for Dummies

Postby BillyBoyo » Fri Oct 12, 2012 5:43 am

If they are Copyright, then I'm afraid you can't. A pity, as I'd like to see them :-)
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Re: SYNCSORT Report for Dummies

Postby dick scherrer » Fri Oct 12, 2012 6:50 am

Hello,

Syncsort does not permit general distribution of their documentation. If it is found anywhere other than Syncsort, it is stolen. All licensed users may download all of the material from Syncsort Support for free.

We are neither permitted to provide them on our forum nor link to them elsewhere.

If any proprietary material is posted here or link(s) provided, we must delete it.
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: SYNCSORT Report for Dummies

Postby BillyBoyo » Fri Oct 12, 2012 4:35 pm

SyncSort support would be the only place if they are SyncSort-produced.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Re: SYNCSORT Report for Dummies

Postby c62ap90 » Fri Oct 12, 2012 8:05 pm

I posted this earlier today (I think) but I do not see it anymore. I'll try again.

I called Syncsort a few years ago and said I am an application developer and could they point me to sysnsort manual and how-to examples. They setup an account for me that I still use and now I have access to hundreds of pdf sysnsort documents.

https://www.syncsort.com/support/login.pl
c62ap90
 
Posts: 125
Joined: Thu Oct 11, 2012 10:24 pm
Has thanked: 1 time
Been thanked: 6 times

Re: SYNCSORT Report for Dummies

Postby NicC » Sat Oct 13, 2012 12:28 am

But that is a totally useless link unless one has a userid and password issued by syncsort and if someone did have these and shared them then they would be open to prosecution (and probably dismissal)
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2690
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 105 times

Re: SYNCSORT Report for Dummies

Postby dick scherrer » Sat Oct 13, 2012 1:30 am

Hi Nic,

I didn''t delete this again as i thought it might encourage someone to get their login from Syncsort . . .

@c62ap90
I posted this earlier today (I think) but I do not see it anymore. I'll try again.
Yup, i deleted the first one because of the unacceptable link to the doc. As i mentioned earlier:
If any proprietary material is posted here or link(s) provided, we must delete it.
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

Next

Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post