Mainframes, MVS, zOS and Related Languages Support Forums Help & Support Forum for and by Mainframe Users 2013-08-20T12:53:47+00:00 http://www.ibm-mainframes.com/feed.php?f=29 2013-08-20T12:53:47+00:00 2013-08-20T12:53:47+00:00 http://www.ibm-mainframes.com/viewtopic.php?t=262&p=897#p897 <![CDATA[SyncSort, SyncTool, SyncGener. • Re: Is there some order of processing SYSIN statements in SO]]>
INREC processing occurs before SORT processing, and then SUM occurs after the SORT.

If you've SyncSort manual, SyncSort for z/OS Programmer's Guide, please refer to Chapter 8 in this Guide for the complete Flow of the Sort.

Statistics: Posted by Anuj Dhawan — Tue Aug 20, 2013 12:53 pm


]]>
2013-08-20T12:35:36+00:00 2013-08-20T12:35:36+00:00 http://www.ibm-mainframes.com/viewtopic.php?t=197&p=895#p895 <![CDATA[SyncSort, SyncTool, SyncGener. • Re: How to count No. of Records in Dataset using Sort?]]>

Statistics: Posted by Anuj Dhawan — Tue Aug 20, 2013 12:35 pm


]]>
2013-08-14T08:49:57+00:00 2013-08-14T08:49:57+00:00 http://www.ibm-mainframes.com/viewtopic.php?t=311&p=858#p858 <![CDATA[SyncSort, SyncTool, SyncGener. • Re: How to use PIPESORT?]]> Statistics: Posted by Anuj Dhawan — Wed Aug 14, 2013 8:49 am


]]>
2013-08-14T04:50:19+00:00 2013-08-14T04:50:19+00:00 http://www.ibm-mainframes.com/viewtopic.php?t=311&p=853#p853 <![CDATA[SyncSort, SyncTool, SyncGener. • Re: How to use PIPESORT?]]>
m4mainframes, just curious - what's your real name? :)

Statistics: Posted by Router — Wed Aug 14, 2013 4:50 am


]]>
2013-08-14T04:34:09+00:00 2013-08-14T04:34:09+00:00 http://www.ibm-mainframes.com/viewtopic.php?t=339&p=852#p852 <![CDATA[SyncSort, SyncTool, SyncGener. • Re: Get only date from SORT and SORTIN as DD Dummy?]]> what to do with this data-set.

For a SORT solution, you can use the below Job to get the System Date:
Code:
//STEP01   EXEC PGM=ICEMAN                       
//SYSOUT   DD   SYSOUT=*                         
//SORTIN   DD   DUMMY,RECFM=FB,LRECL=80,BLKSIZE=0
//SORTOUT  DD   SYSOUT=*                         
//SYSIN    DD    *                               
  OPTION COPY                                   
  OUTFIL REMOVECC,NODETAIL,HEADER1=(DATE)       
/*                                               


Another alternate to get what you're looking forward to is:

Code:
//STEP01   EXEC  PGM=ICEMAN
//SYSOUT   DD  SYSOUT=*     
//SORTIN   DD *             
DUMMY                       
/*                         
//SORTOUT  DD SYSOUT=*     
//SYSIN    DD    *         
  OPTION COPY               
  OUTREC FIELDS=(DATE)     
/*                         


Hope this helps.

Statistics: Posted by Anuj Dhawan — Wed Aug 14, 2013 4:34 am


]]>
2013-08-13T13:08:15+00:00 2013-08-13T13:08:15+00:00 http://www.ibm-mainframes.com/viewtopic.php?t=339&p=847#p847 <![CDATA[SyncSort, SyncTool, SyncGener. • Re: Get only date from SORT and SORTIN as DD Dummy?]]>
If your site runs CA-7 or another job scheduler, they usually have date manipulation processes set up. For CA-7, check the chapter on CADRIVER in the CA-7 Interfaces manual. Also, most sites that have been around awhile have a date program on site; you might want to ask more experienced people at your site about what is available there.

Statistics: Posted by Robert Sample — Tue Aug 13, 2013 1:08 pm


]]>
2013-08-13T13:01:31+00:00 2013-08-13T13:01:31+00:00 http://www.ibm-mainframes.com/viewtopic.php?t=339&p=846#p846 <![CDATA[SyncSort, SyncTool, SyncGener. • Get only date from SORT and SORTIN as DD Dummy?]]>
I need to create one line file with system date and time. I tried using some HEADER1 parameters to get this, but when I execute the JOB, SORT JOB fails saying:
Code:
SORTIN   DCB RECFM REQUIRED
why a DUMMY needs DCB?

The Job I used is:
Code:
//S1       EXEC  PGM=ICEMAN               
//SYSOUT   DD  SYSOUT=*                   
//SORTIN   DD DUMMY                       
//SORTOUT  DD SYSOUT=*                     
//SYSIN    DD    *                         
  OPTION COPY                             
  HEADER1=(DATE)                     
/*                                         


I need to get the system date every day, is there a way out to achieve this without using any real SORTIN file?

Statistics: Posted by RyanFox — Tue Aug 13, 2013 1:01 pm


]]>
2013-08-10T09:27:50+00:00 2013-08-10T09:27:50+00:00 http://www.ibm-mainframes.com/viewtopic.php?t=311&p=795#p795 <![CDATA[SyncSort, SyncTool, SyncGener. • Re: How to use PIPESORT?]]>
http://www.syncsort.com/PDF/sspsts.pdf

Statistics: Posted by m4mainframe — Sat Aug 10, 2013 9:27 am


]]>
2013-08-01T06:17:32+00:00 2013-08-01T06:17:32+00:00 http://www.ibm-mainframes.com/viewtopic.php?t=197&p=675#p675 <![CDATA[SyncSort, SyncTool, SyncGener. • Re: How to count No. of Records in Dataset using Sort?]]>
Thanks again.

Statistics: Posted by harish123 — Thu Aug 01, 2013 6:17 am


]]>
2013-07-29T09:42:28+00:00 2013-07-29T09:42:28+00:00 http://www.ibm-mainframes.com/viewtopic.php?t=308&p=654#p654 <![CDATA[SyncSort, SyncTool, SyncGener. • Re: What is syncsort ?]]> Statistics: Posted by Robert Sample — Mon Jul 29, 2013 9:42 am


]]>
2013-07-29T05:42:33+00:00 2013-07-29T05:42:33+00:00 http://www.ibm-mainframes.com/viewtopic.php?t=311&p=653#p653 <![CDATA[SyncSort, SyncTool, SyncGener. • How to use PIPESORT?]]>
I'm looking forward to implement PIPESORT. How to use PIPESORT? Is there any manual/s or reference/s?

Statistics: Posted by Router — Mon Jul 29, 2013 5:42 am


]]>
2013-07-29T05:19:27+00:00 2013-07-29T05:19:27+00:00 http://www.ibm-mainframes.com/viewtopic.php?t=308&p=650#p650 <![CDATA[SyncSort, SyncTool, SyncGener. • What is syncsort ?]]>
Can someone please tell me what is sync sort ? Why and How do we use it?

Statistics: Posted by Vibha — Mon Jul 29, 2013 5:19 am


]]>
2013-07-26T12:53:02+00:00 2013-07-26T12:53:02+00:00 http://www.ibm-mainframes.com/viewtopic.php?t=256&p=622#p622 <![CDATA[SyncSort, SyncTool, SyncGener. • Re: We made a Century!!]]> Making Century is a history now -- We made Much More than a Double Century!

script
Most users ever online was 250 on 26 Jul 2013
script 01:01


What are you waiting for -- come get along with this busy community to clear, debate and discuss your doubts on IBM Mainframes, MVS, zOS and related Languages.

Statistics: Posted by Anuj Dhawan — Fri Jul 26, 2013 12:53 pm


]]>
2013-07-26T04:48:11+00:00 2013-07-26T04:48:11+00:00 http://www.ibm-mainframes.com/viewtopic.php?t=295&p=619#p619 <![CDATA[SyncSort, SyncTool, SyncGener. • "Report This Post" is activated.]]>
The "Report This Post Button" can be found as the first button with exclamation sign ("!"), at bottom right of any post. The pictorial representation is shown below:

Statistics: Posted by Anuj Dhawan — Fri Jul 26, 2013 4:48 am


]]>
2013-07-24T08:03:19+00:00 2013-07-24T08:03:19+00:00 http://www.ibm-mainframes.com/viewtopic.php?t=262&p=581#p581 <![CDATA[SyncSort, SyncTool, SyncGener. • Re: Is there some order of processing SYSIN statements in SO]]> Statistics: Posted by Manoj — Wed Jul 24, 2013 8:03 am


]]>
2013-07-19T19:11:01+00:00 2013-07-19T19:11:01+00:00 http://www.ibm-mainframes.com/viewtopic.php?t=256&p=532#p532 <![CDATA[SyncSort, SyncTool, SyncGener. • Re: We made a Century!!]]>
Today it is 165!!!

Statistics: Posted by Anuj Dhawan — Fri Jul 19, 2013 7:11 pm


]]>
2013-07-19T11:23:50+00:00 2013-07-19T11:23:50+00:00 http://www.ibm-mainframes.com/viewtopic.php?t=262&p=530#p530 <![CDATA[SyncSort, SyncTool, SyncGener. • Re: Is there some order of processing SYSIN statements in SO]]> Statistics: Posted by Robert Sample — Fri Jul 19, 2013 11:23 am


]]>
2013-07-19T11:07:38+00:00 2013-07-19T11:07:38+00:00 http://www.ibm-mainframes.com/viewtopic.php?t=263&p=529#p529 <![CDATA[SyncSort, SyncTool, SyncGener. • Re: How to count no. of records based on a condition?]]> 2. Use SAS or EASYTRIEVE if installed at your site
3. Write a program in the language of your choice

There are other ways depending upon the specifics of the file and the site, but three should give you a way to proceed.

Statistics: Posted by Robert Sample — Fri Jul 19, 2013 11:07 am


]]>
2013-07-19T06:51:07+00:00 2013-07-19T06:51:07+00:00 http://www.ibm-mainframes.com/viewtopic.php?t=263&p=520#p520 <![CDATA[SyncSort, SyncTool, SyncGener. • How to count no. of records based on a condition?]]>
I want to count number of records from a huge file based on condition. The file has got some records with, say 'AAAAA' at position 10. I want to count only those records. How to do it? LRECL of file is 80 and RECFM is FB.

Statistics: Posted by Sachin Kumar — Fri Jul 19, 2013 6:51 am


]]>
2013-07-19T06:48:28+00:00 2013-07-19T06:48:28+00:00 http://www.ibm-mainframes.com/viewtopic.php?t=262&p=519#p519 <![CDATA[SyncSort, SyncTool, SyncGener. • Is there some order of processing SYSIN statements in SORT?]]>
Please have a look at below code:

Code:
INREC FIELDS=(1,5,81:SEQNUM,3,ZD)
SORT FIELDS=(1,5,CH,A)           
SUM FIELDS=NONE                   
and then I used
Code:
SORT FIELDS=(1,5,CH,A)           
INREC FIELDS=(1,5,81:SEQNUM,3,ZD)
SUM FIELDS=NONE                   
In both the cases I got the same output. With first code I though that it'll first process INREC and later SORT and opposite for the second code but it does not seem to work that way. Is there some specif way of execution of statements?

Statistics: Posted by Sachin Kumar — Fri Jul 19, 2013 6:48 am


]]>