Re: DFHSORT - Date Display of Previous Month
George, William wrote: >I'm having a heck of a time attempting to create a sort header to display the >previous month in MM format. There is probably a good solution for your SyncSort problem, but you can have a look at thread 'DFSORT - ICETOOL - Search for text and replace with date' which I started last year. Perhaps SyncSort can do what DFSORT and ICETOOL can do as shown in above thread. Just check the above thread and look if you can conjure up a solution. Groete / Greetings Elardus Engelbrecht -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: DFHSORT - Date Display of Previous Month
Kolusu works for IBM's DFSORT. He is not going to comment on the particular competing product that you use. What does it say in the manual? Can you show what you tried, how it failed, and more exactly what you want to do, with some sample input, expected output., amd output you receive? -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: DFHSORT - Date Display of Previous Month
Thanks Kolusu So the DATE2 cannot be used in a HEADER1 definition? -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Sri h Kolusu Sent: Thursday, March 02, 2017 1:57 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: DFHSORT - Date Display of Previous Month Couple of clarifications 1. It is DFSORT and not DFHSORT(There is no H) 2. Your error messages start with WER which indicates you are using Syncsort and not DFSORT 3. You don't need to use INCLUDE=ALL as it is the default to include all records for DFSORT 4. The same is the case for specifying Files=OUT as SORTOUT is the default. Either way if you need last month date, you need to use date2 parm but you need to use on inrec/outrec . I assumed that your input has an lrecl of 80 bytes and we put the previous month date at position 81 and remove it using BUILD on outfil This is a working syntax for DFSORT, but i cannot comment on the other product //SYSINDD * SORT FIELDS=(1,2,CH,A) OUTREC OVERLAY=(81:DATE2-1) OUTFIL BUILD=(1,80), HEADER1=('DATE',15:81,6) //* Thanks, Kolusu DFSORT Development IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> wrote on 03/02/2017 02:44:39 PM: > From: "George, William@FTB" <bill.geo...@ftb.ca.gov> > To: IBM-MAIN@LISTSERV.UA.EDU > Date: 03/02/2017 02:45 PM > Subject: DFHSORT - Date Display of Previous Month Sent by: IBM > Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> > > I'm having a heck of a time attempting to create a sort header to > display the previous month in MM format. > No matter what I do I get a syntax error and I've attempted many > different ways. > > Here is the most recent attempt. I do not see why there is a syntax > error where indicated. > > SYSIN statements > > SORT FIELDS=(1,2,CH,A) > OUTFIL FILES=OUT, > INCLUDE=ALL, > HEADER1=(1:C'DATE', > 15:) > > And the error > SYSIN : > SORT FIELDS=(1,2,CH,A) > OUTFIL FILES=OUT, > INCLUDE=ALL, >HEADER1=(1:C'DATE', > * >15:) > WER268A OUTFIL STATEMENT : SYNTAX ERROR > > > Any insights are appreciated > > Bill > > __ > CONFIDENTIALITY NOTICE: This email from the State of California is for > the sole use of the intended recipient and may contain confidential > and privileged information. Any unauthorized review or use, including > disclosure or distribution, is prohibited. If you are not the intended > recipient, please contact the sender and destroy all copies of this > email. > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, send > email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: DFHSORT - Date Display of Previous Month
Kolusu OK, I see what you did below to get the date in the HEADER. Thanks I believe I can make this work. Bill -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Sri h Kolusu Sent: Thursday, March 02, 2017 1:57 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: DFHSORT - Date Display of Previous Month Couple of clarifications 1. It is DFSORT and not DFHSORT(There is no H) 2. Your error messages start with WER which indicates you are using Syncsort and not DFSORT 3. You don't need to use INCLUDE=ALL as it is the default to include all records for DFSORT 4. The same is the case for specifying Files=OUT as SORTOUT is the default. Either way if you need last month date, you need to use date2 parm but you need to use on inrec/outrec . I assumed that your input has an lrecl of 80 bytes and we put the previous month date at position 81 and remove it using BUILD on outfil This is a working syntax for DFSORT, but i cannot comment on the other product //SYSINDD * SORT FIELDS=(1,2,CH,A) OUTREC OVERLAY=(81:DATE2-1) OUTFIL BUILD=(1,80), HEADER1=('DATE',15:81,6) //* Thanks, Kolusu DFSORT Development IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> wrote on 03/02/2017 02:44:39 PM: > From: "George, William@FTB" <bill.geo...@ftb.ca.gov> > To: IBM-MAIN@LISTSERV.UA.EDU > Date: 03/02/2017 02:45 PM > Subject: DFHSORT - Date Display of Previous Month Sent by: IBM > Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> > > I'm having a heck of a time attempting to create a sort header to > display the previous month in MM format. > No matter what I do I get a syntax error and I've attempted many > different ways. > > Here is the most recent attempt. I do not see why there is a syntax > error where indicated. > > SYSIN statements > > SORT FIELDS=(1,2,CH,A) > OUTFIL FILES=OUT, > INCLUDE=ALL, > HEADER1=(1:C'DATE', > 15:) > > And the error > SYSIN : > SORT FIELDS=(1,2,CH,A) > OUTFIL FILES=OUT, > INCLUDE=ALL, >HEADER1=(1:C'DATE', > * >15:) > WER268A OUTFIL STATEMENT : SYNTAX ERROR > > > Any insights are appreciated > > Bill > > __ > CONFIDENTIALITY NOTICE: This email from the State of California is for > the sole use of the intended recipient and may contain confidential > and privileged information. Any unauthorized review or use, including > disclosure or distribution, is prohibited. If you are not the intended > recipient, please contact the sender and destroy all copies of this > email. > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, send > email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: DFHSORT - Date Display of Previous Month
Couple of clarifications 1. It is DFSORT and not DFHSORT(There is no H) 2. Your error messages start with WER which indicates you are using Syncsort and not DFSORT 3. You don't need to use INCLUDE=ALL as it is the default to include all records for DFSORT 4. The same is the case for specifying Files=OUT as SORTOUT is the default. Either way if you need last month date, you need to use date2 parm but you need to use on inrec/outrec . I assumed that your input has an lrecl of 80 bytes and we put the previous month date at position 81 and remove it using BUILD on outfil This is a working syntax for DFSORT, but i cannot comment on the other product //SYSINDD * SORT FIELDS=(1,2,CH,A) OUTREC OVERLAY=(81:DATE2-1) OUTFIL BUILD=(1,80), HEADER1=('DATE',15:81,6) //* Thanks, Kolusu DFSORT Development IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> wrote on 03/02/2017 02:44:39 PM: > From: "George, William@FTB" <bill.geo...@ftb.ca.gov> > To: IBM-MAIN@LISTSERV.UA.EDU > Date: 03/02/2017 02:45 PM > Subject: DFHSORT - Date Display of Previous Month > Sent by: IBM Mainframe Discussion List <IBM-MAIN@LISTSERV.UA.EDU> > > I'm having a heck of a time attempting to create a sort header to > display the previous month in MM format. > No matter what I do I get a syntax error and I've attempted many > different ways. > > Here is the most recent attempt. I do not see why there is a syntax > error where indicated. > > SYSIN statements > > SORT FIELDS=(1,2,CH,A) > OUTFIL FILES=OUT, > INCLUDE=ALL, > HEADER1=(1:C'DATE', > 15:) > > And the error > SYSIN : > SORT FIELDS=(1,2,CH,A) > OUTFIL FILES=OUT, > INCLUDE=ALL, >HEADER1=(1:C'DATE', > * >15:) > WER268A OUTFIL STATEMENT : SYNTAX ERROR > > > Any insights are appreciated > > Bill > > __ > CONFIDENTIALITY NOTICE: This email from the State of California is > for the sole use of the intended recipient and may contain > confidential and privileged information. Any unauthorized review or > use, including disclosure or distribution, is prohibited. If you are > not the intended recipient, please contact the sender and destroy > all copies of this email. > > -- > For IBM-MAIN subscribe / signoff / archive access instructions, > send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN > -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: DFHSORT - Date Display of Previous Month
My apologizes... Syncsort -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of Blaicher, Christopher Y. Sent: Thursday, March 02, 2017 1:50 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: Re: DFHSORT - Date Display of Previous Month Please call 201-930-8260. A support person will be happy to assist you. If you are wondering why I don't answer the question it is because it has been several years since I worked on MFX. I currently work on our Ironstream product. Chris Blaicher Technical Architect Mainframe Development Syncsort Incorporated 2 Blue Hill Plaza #1563, Pearl River, NY 10965 P: 201-930-8234 | M: 512-627-3803 E: cblaic...@syncsort.com www.syncsort.com CONNECTING BIG IRON TO BIG DATA -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of George, William@FTB Sent: Thursday, March 2, 2017 4:45 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: DFHSORT - Date Display of Previous Month I'm having a heck of a time attempting to create a sort header to display the previous month in MM format. No matter what I do I get a syntax error and I've attempted many different ways. Here is the most recent attempt. I do not see why there is a syntax error where indicated. SYSIN statements SORT FIELDS=(1,2,CH,A) OUTFIL FILES=OUT, INCLUDE=ALL, HEADER1=(1:C'DATE', 15:) And the error SYSIN : SORT FIELDS=(1,2,CH,A) OUTFIL FILES=OUT, INCLUDE=ALL, HEADER1=(1:C'DATE', * 15:) WER268A OUTFIL STATEMENT : SYNTAX ERROR Any insights are appreciated Bill __ CONFIDENTIALITY NOTICE: This email from the State of California is for the sole use of the intended recipient and may contain confidential and privileged information. Any unauthorized review or use, including disclosure or distribution, is prohibited. If you are not the intended recipient, please contact the sender and destroy all copies of this email. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN ATTENTION: - The information contained in this message (including any files transmitted with this message) may contain proprietary, trade secret or other confidential and/or legally privileged information. Any pricing information contained in this message or in any files transmitted with this message is always confidential and cannot be shared with any third parties without prior written approval from Syncsort. This message is intended to be read only by the individual or entity to whom it is addressed or by their designee. If the reader of this message is not the intended recipient, you are on notice that any use, disclosure, copying or distribution of this message, in any form, is strictly prohibited. If you have received this message in error, please immediately notify the sender and/or Syncsort and destroy all copies of this message in your possession, custody or control. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
Re: DFHSORT - Date Display of Previous Month
Please call 201-930-8260. A support person will be happy to assist you. If you are wondering why I don't answer the question it is because it has been several years since I worked on MFX. I currently work on our Ironstream product. Chris Blaicher Technical Architect Mainframe Development Syncsort Incorporated 2 Blue Hill Plaza #1563, Pearl River, NY 10965 P: 201-930-8234 | M: 512-627-3803 E: cblaic...@syncsort.com www.syncsort.com CONNECTING BIG IRON TO BIG DATA -Original Message- From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] On Behalf Of George, William@FTB Sent: Thursday, March 2, 2017 4:45 PM To: IBM-MAIN@LISTSERV.UA.EDU Subject: DFHSORT - Date Display of Previous Month I'm having a heck of a time attempting to create a sort header to display the previous month in MM format. No matter what I do I get a syntax error and I've attempted many different ways. Here is the most recent attempt. I do not see why there is a syntax error where indicated. SYSIN statements SORT FIELDS=(1,2,CH,A) OUTFIL FILES=OUT, INCLUDE=ALL, HEADER1=(1:C'DATE', 15:) And the error SYSIN : SORT FIELDS=(1,2,CH,A) OUTFIL FILES=OUT, INCLUDE=ALL, HEADER1=(1:C'DATE', * 15:) WER268A OUTFIL STATEMENT : SYNTAX ERROR Any insights are appreciated Bill __ CONFIDENTIALITY NOTICE: This email from the State of California is for the sole use of the intended recipient and may contain confidential and privileged information. Any unauthorized review or use, including disclosure or distribution, is prohibited. If you are not the intended recipient, please contact the sender and destroy all copies of this email. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN ATTENTION: - The information contained in this message (including any files transmitted with this message) may contain proprietary, trade secret or other confidential and/or legally privileged information. Any pricing information contained in this message or in any files transmitted with this message is always confidential and cannot be shared with any third parties without prior written approval from Syncsort. This message is intended to be read only by the individual or entity to whom it is addressed or by their designee. If the reader of this message is not the intended recipient, you are on notice that any use, disclosure, copying or distribution of this message, in any form, is strictly prohibited. If you have received this message in error, please immediately notify the sender and/or Syncsort and destroy all copies of this message in your possession, custody or control. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN
DFHSORT - Date Display of Previous Month
I'm having a heck of a time attempting to create a sort header to display the previous month in MM format. No matter what I do I get a syntax error and I've attempted many different ways. Here is the most recent attempt. I do not see why there is a syntax error where indicated. SYSIN statements SORT FIELDS=(1,2,CH,A) OUTFIL FILES=OUT, INCLUDE=ALL, HEADER1=(1:C'DATE', 15:) And the error SYSIN : SORT FIELDS=(1,2,CH,A) OUTFIL FILES=OUT, INCLUDE=ALL, HEADER1=(1:C'DATE', * 15:) WER268A OUTFIL STATEMENT : SYNTAX ERROR Any insights are appreciated Bill __ CONFIDENTIALITY NOTICE: This email from the State of California is for the sole use of the intended recipient and may contain confidential and privileged information. Any unauthorized review or use, including disclosure or distribution, is prohibited. If you are not the intended recipient, please contact the sender and destroy all copies of this email. -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN