Re: DFSORT - How to select last 8 bytes in variable length records

2015-06-11 Thread Minoru Massaki
y to come up with a > solution and both of us are trying to help. > > > IBM Mainframe Discussion List wrote on > 06/10/2015 05:06:50 PM: > > > From: Norbert Friemel > > To: IBM-MAIN@LISTSERV.UA.EDU > > Date: 06/10/2015 05:07 PM > > Subject: Re: DFSORT - How

Re: DFSORT - How to select last 8 bytes in variable length records

2015-06-11 Thread Sri h Kolusu
and both of us are trying to help. IBM Mainframe Discussion List wrote on 06/10/2015 05:06:50 PM: > From: Norbert Friemel > To: IBM-MAIN@LISTSERV.UA.EDU > Date: 06/10/2015 05:07 PM > Subject: Re: DFSORT - How to select last 8 bytes in variable length records > Sent by:

Re: DFSORT - How to select last 8 bytes in variable length records

2015-06-10 Thread Norbert Friemel
On Wed, 10 Jun 2015 14:57:33 -0700, Sri h Kolusu wrote: >Norbert, > >As I mentioned earlier it can be done in single pass as shown earlier, I >was just trying to optimize your Joinkeys job. With your new job there a >couple of issues > >1. I am not sure as to why you need to append C'40' (may be

Re: DFSORT - How to select last 8 bytes in variable length records

2015-06-10 Thread Sri h Kolusu
: 06/10/2015 11:09 AM > Subject: Re: DFSORT - How to select last 8 bytes in variable length records > Sent by: IBM Mainframe Discussion List > > On Wed, 10 Jun 2015 09:32:38 -0700, Sri h Kolusu wrote: > > >Minoru Massaki, > > > >Norbert had an excellent idea to ov

Re: DFSORT - How to select last 8 bytes in variable length records

2015-06-10 Thread Norbert Friemel
On Wed, 10 Jun 2015 09:32:38 -0700, Sri h Kolusu wrote: >Minoru Massaki, > >Norbert had an excellent idea to overcome the issue of having spaces at >the beginning or at the end. Converting to hex would overcome the issue of >truncation with JFY. > >However you do NOT require 2 passes of data to in

Re: DFSORT - How to select last 8 bytes in variable length records

2015-06-10 Thread Sri h Kolusu
e know Thanks, Sri Hari Kolusu DFSORT Development IBM Corporation IBM Mainframe Discussion List wrote on 06/09/2015 10:49:39 PM: > From: Minoru Massaki > To: IBM-MAIN@LISTSERV.UA.EDU > Date: 06/09/2015 10:50 PM > Subject: Re: DFSORT - How to select last 8 bytes in variable length reco

Re: DFSORT - How to select last 8 bytes in variable length records

2015-06-09 Thread Minoru Massaki
Hello Gilmartin-san, Thank you for your suggestion. I didn't know a such kind of technique. Minoru Massaki - (M*M) 2015-06-10 5:41 GMT+09:00 Paul Gilmartin < 000433f07816-dmarc-requ...@listserv.ua.edu>: > On 2015-06-09 13:19, Tony Harminc wrote: > > > > Please do not forget that, if you ac

Re: DFSORT - How to select last 8 bytes in variable length records

2015-06-09 Thread Minoru Massaki
Hello Harminc-san, Thank you for your attention. I'll care about hex field sorting hereafter. Minoru Massaki - (M*M) 2015-06-10 4:19 GMT+09:00 Tony Harminc : > On 9 June 2015 at 13:50, Minoru Massaki wrote: > > > > Allowing all data (x'00' thru X'FF') for input record, > > converting input d

Re: DFSORT - How to select last 8 bytes in variable length records

2015-06-09 Thread Minoru Massaki
Hi Friemel-san, I have tested you new DFSORT JCL in our z/OS V2.1 system. It has worked fine. Thank you!! Minoru Massaki - (M*M) 2015-06-10 4:00 GMT+09:00 Norbert Friemel : > On Wed, 10 Jun 2015 02:37:49 +0900, Minoru Massaki wrote: > > >Hello Friemel-san, > > > >Thank you for your DFSORT J

Re: DFSORT - How to select last 8 bytes in variable length records

2015-06-09 Thread Minoru Massaki
on > > IBM Mainframe Discussion List wrote on > 06/09/2015 10:37:49 AM: > > > From: Minoru Massaki > > To: IBM-MAIN@LISTSERV.UA.EDU > > Date: 06/09/2015 10:38 AM > > Subject: Re: DFSORT - How to select last 8 bytes in variable length > records > > Sent by

Re: DFSORT - How to select last 8 bytes in variable length records

2015-06-09 Thread Paul Gilmartin
On 2015-06-09 13:19, Tony Harminc wrote: > > Please do not forget that, if you actually perform byte-value sorting on > such hexified records, the hex values do not sort in the same order as the > raw data. (I realize your initial problem does not include sorting the > data, but sometimes requirem

Re: DFSORT - How to select last 8 bytes in variable length records

2015-06-09 Thread Tony Harminc
On 9 June 2015 at 13:50, Minoru Massaki wrote: > Allowing all data (x'00' thru X'FF') for input record, > converting input data to HEX (data become only A thru Z and 0 thru 9) > during DFSORT process might be a solution. ;-) > Please do not forget that, if you actually perform byte-value sort

Re: DFSORT - How to select last 8 bytes in variable length records

2015-06-09 Thread Norbert Friemel
On Wed, 10 Jun 2015 02:37:49 +0900, Minoru Massaki wrote: >Hello Friemel-san, > >Thank you for your DFSORT JCL. > >In our z/OS V2.1 system, your JCL didn't work correctly. >(output looked like all blank) > >After changing VLTRAIL parameter from two characters '<|' to >three characters such as C'<|

Re: DFSORT - How to select last 8 bytes in variable length records

2015-06-09 Thread Minoru Massaki
tput from position 5. Remember you can mention the special character in > HEX format too. > > Further if you have any questions please let me know > > Thanks, > Sri Hari Kolusu > DFSORT Development > IBM Corporation > > > > From: Minoru Massaki > To: IBM-M

Re: DFSORT - How to select last 8 bytes in variable length records

2015-06-09 Thread Sri h Kolusu
input file to our hotline ? Thanks, Sri Hari Kolusu DFSORT Development IBM Corporation IBM Mainframe Discussion List wrote on 06/09/2015 10:37:49 AM: > From: Minoru Massaki > To: IBM-MAIN@LISTSERV.UA.EDU > Date: 06/09/2015 10:38 AM > Subject: Re: DFSORT - How to select las

Re: DFSORT - How to select last 8 bytes in variable length records

2015-06-09 Thread Minoru Massaki
Hello Friemel-san, Thank you for your DFSORT JCL. In our z/OS V2.1 system, your JCL didn't work correctly. (output looked like all blank) After changing VLTRAIL parameter from two characters '<|' to three characters such as C'<|>', it does work fine. Thank you! Minoru Massaki - (M*M) 2015-06

Re: DFSORT - How to select last 8 bytes in variable length records

2015-06-09 Thread Sri h Kolusu
emember you can mention the special character in HEX format too. Further if you have any questions please let me know Thanks, Sri Hari Kolusu DFSORT Development IBM Corporation From: Minoru Massaki To: IBM-MAIN@LISTSERV.UA.EDU Date: 06/09/2015 08:57 AM Subject: Re: DFSORT - Ho

Re: DFSORT - How to select last 8 bytes in variable length records

2015-06-09 Thread Minoru Massaki
HEN=(WHEN=INIT, > FINDREP=(IN=(C' ',C'$'),OUT=C'')), $ REMOVE SPACES AND SPL CHAR > > IFTHEN=(WHEN=INIT, > FINDREP=(INOUT=(C'@',X'40'))) $ CHANGE '@' BACK TO SPACE > //* > > > Hope this helps... &

Re: DFSORT - How to select last 8 bytes in variable length records

2015-06-08 Thread Sri h Kolusu
T=(C'@',X'40'))) $ CHANGE '@' BACK TO SPACE //* Hope this helps... Thanks, Sri Hari Kolusu DFSORT Development IBM Corporation IBM Mainframe Discussion List wrote on 06/08/2015 01:14:33 AM: > From: Minoru Massaki > To: IBM-MAIN@LISTSERV.UA.EDU &

Re: DFSORT - How to select last 8 bytes in variable length records

2015-06-08 Thread Sri h Kolusu
BM-MAIN@LISTSERV.UA.EDU > Date: 06/08/2015 01:14 AM > Subject: Re: DFSORT - How to select last 8 bytes in variable length records > Sent by: IBM Mainframe Discussion List > > Hello Kolusu-san, > > Thank you very much for giving the answer by using DFSORT. > That is what the c

Re: DFSORT - How to select last 8 bytes in variable length records

2015-06-08 Thread Robert A. Rosenberg
At 22:28 +0900 on 06/07/2015, Minoru Massaki wrote about DFSORT - How to select last 8 bytes in variable length reco: Hello There is a input file of variable length records. I want to insert the last 8 bytes of a record to front of the record as following sample. Input file: RECORD01X11AA

Re: DFSORT - How to select last 8 bytes in variable length records

2015-06-08 Thread Norbert Friemel
On Mon, 8 Jun 2015 17:14:33 +0900, Minoru Massaki wrote: >Hello Kolusu-san, > >Thank you very much for giving the answer by using DFSORT. >That is what the customer wants to. > >I have additional questions. >If the 8 bytes key is binary data and some records include x'40' of the >last byte of the

Re: DFSORT - How to select last 8 bytes in variable length records

2015-06-08 Thread Paul Gilmartin
On Mon, 8 Jun 2015 05:48:13 -0500, Bill Godfrey wrote: > >>How does ocopy deal with this ? - I'm unable to test on z at present. >> >I haven't tried ocopy, but I inserted hex 15 into some records in a data set, >used oput (as text), and the resulting file had new lines wherever I had >inserted he

Re: DFSORT - How to select last 8 bytes in variable length records

2015-06-08 Thread Bill Godfrey
On Mon, 8 Jun 2015 00:12:18 -0500, Shane Ginnane wrote: >On Sun, 7 Jun 2015 14:11:30 -0500, Bill Godfrey wrote: > >>That would mean there could be end-of-line characters and hex 00 characters >>in a record, which would mean "sed" would not work. > >sed won't (shouldn't) care about the nulls, but

Re: DFSORT - How to select last 8 bytes in variable length records

2015-06-08 Thread Martin Packer
IDs: MartinPacker Blog: https://www.ibm.com/developerworks/mydeveloperworks/blogs/MartinPacker From: Sri h Kolusu To: IBM-MAIN@LISTSERV.UA.EDU Date: 08/06/2015 06:48 Subject:Re: DFSORT - How to select last 8 bytes in variable length records Sent by:IBM Mainframe

Re: DFSORT - How to select last 8 bytes in variable length records

2015-06-08 Thread Minoru Massaki
lopment > IBM Corporation > > IBM Mainframe Discussion List wrote on > 06/07/2015 06:28:01 AM: > > > From: Minoru Massaki > > To: IBM-MAIN@LISTSERV.UA.EDU > > Date: 06/07/2015 06:28 AM > > Subject: DFSORT - How to select last 8 bytes in variable length reco

Re: DFSORT - How to select last 8 bytes in variable length records

2015-06-07 Thread Steve Coalbran
E TRAIL SPACES // /Steve From: Sri h Kolusu To: IBM-MAIN@LISTSERV.UA.EDU Date: 2015-06-08 07:44 Subject: Re: DFSORT - How to select last 8 bytes in variable length records Sent by:IBM Mainframe Discussion List Minoru Massaki, It is quite simple to get the last

Re: DFSORT - How to select last 8 bytes in variable length records

2015-06-07 Thread Sri h Kolusu
AM: > From: Martin Packer > To: IBM-MAIN@LISTSERV.UA.EDU > Date: 06/07/2015 07:34 AM > Subject: Re: DFSORT - How to select last 8 bytes in variable length records > Sent by: IBM Mainframe Discussion List > > How many different record lengths do you expect to see? If it's

Re: DFSORT - How to select last 8 bytes in variable length records

2015-06-07 Thread Sri h Kolusu
06/07/2015 06:28 AM > Subject: DFSORT - How to select last 8 bytes in variable length records > Sent by: IBM Mainframe Discussion List > > Hello > > There is a input file of variable length records. > I want to insert the last 8 bytes of a record to front of the recor

Re: DFSORT - How to select last 8 bytes in variable length records

2015-06-07 Thread Shane Ginnane
On Sun, 7 Jun 2015 14:11:30 -0500, Bill Godfrey wrote: >That would mean there could be end-of-line characters and hex 00 characters in >a record, which would mean "sed" would not work. sed won't (shouldn't) care about the nulls, but won't like newlines (yes, I noted your careful language given

Re: DFSORT - How to select last 8 bytes in variable length records

2015-06-07 Thread Bill Godfrey
On Sun, 7 Jun 2015 13:36:53 -0400, Robert A. Rosenberg wrote: >At 09:46 -0500 on 06/07/2015, Paul Gilmartin wrote about Re: DFSORT - >How to select last 8 bytes in variable length : > >>On Sun, 7 Jun 2015 22:28:01 +0900, Minoru Massaki wrote: >> >>>Hello >>> >>>There is a input file of variable le

Re: DFSORT - How to select last 8 bytes in variable length records

2015-06-07 Thread Tony's Outlook via Mozilla
Subject: Re: DFSORT - How to select last 8 bytes in variable length records Hello Gilmartin-san, Thank you for your idea. At this point, they (the customer) want to use only DFSORT without E15/E35. I'll tell them your ideas. Minoru Massaki - (M*M) 2015-06-07 23:46 GMT+09:00 Paul Gilmartin

Re: DFSORT - How to select last 8 bytes in variable length records

2015-06-07 Thread Robert A. Rosenberg
At 09:46 -0500 on 06/07/2015, Paul Gilmartin wrote about Re: DFSORT - How to select last 8 bytes in variable length : On Sun, 7 Jun 2015 22:28:01 +0900, Minoru Massaki wrote: Hello There is a input file of variable length records. I want to insert the last 8 bytes of a record to front of the

Re: DFSORT - How to select last 8 bytes in variable length records

2015-06-07 Thread Minoru Massaki
BM-MAIN@LISTSERV.UA.EDU] >>> On Behalf Of Minoru Massaki >>> Sent: Sunday, June 07, 2015 8:57 AM >>> To: IBM-MAIN@LISTSERV.UA.EDU >>> Subject: Re: DFSORT - How to select last 8 bytes in variable length >>> records >>> >>> Hello Gilmartin-

Re: DFSORT - How to select last 8 bytes in variable length records

2015-06-07 Thread Minoru Massaki
n. > > > Lizette > > > > -Original Message- > > From: IBM Mainframe Discussion List [mailto:IBM-MAIN@LISTSERV.UA.EDU] > > On Behalf Of Minoru Massaki > > Sent: Sunday, June 07, 2015 8:57 AM > > To: IBM-MAIN@LISTSERV.UA.EDU > > Subject: Re: DFSORT -

Re: DFSORT - How to select last 8 bytes in variable length records

2015-06-07 Thread Paul Gilmartin
On Sun, 7 Jun 2015 09:21:08 -0700, Lizette Koehler wrote: > >Also, you could probably do this in REXX. There are many ways to do this >function. > Can one code a DFSORT exit in Rexx? Without a whole lot of interface code? >> -Original Message- >> From: Minoru Massaki >> Sent: Sunday, J

Re: DFSORT - How to select last 8 bytes in variable length records

2015-06-07 Thread Tony's Outlook via Mozilla
: DFSORT - How to select last 8 bytes in variable length records Hello Gilmartin-san, Thank you for your idea. At this point, they (the customer) want to use only DFSORT without E15/E35. I'll tell them your ideas. Minoru Massaki - (M*M) 2015-06-07 23:46 GMT+09:00 Paul Gilmartin < 0004

Re: DFSORT - How to select last 8 bytes in variable length records

2015-06-07 Thread Lizette Koehler
U > Subject: Re: DFSORT - How to select last 8 bytes in variable length records > > Hello Gilmartin-san, > > Thank you for your idea. > > At this point, they (the customer) want to use only DFSORT without E15/E35. > I'll tell them your ideas. > > Minoru Massak

Re: DFSORT - How to select last 8 bytes in variable length records

2015-06-07 Thread Minoru Massaki
Hello Gilmartin-san, Thank you for your idea. At this point, they (the customer) want to use only DFSORT without E15/E35. I'll tell them your ideas. Minoru Massaki - (M*M) 2015-06-07 23:46 GMT+09:00 Paul Gilmartin < 000433f07816-dmarc-requ...@listserv.ua.edu>: > On Sun, 7 Jun 2015 22:2

Re: DFSORT - How to select last 8 bytes in variable length records

2015-06-07 Thread Minoru Massaki
de Banking Center of Excellence, IBM > > +44-7802-245-584 > > email: martin_pac...@uk.ibm.com > > Twitter / Facebook IDs: MartinPacker > Blog: > https://www.ibm.com/developerworks/mydeveloperworks/blogs/MartinPacker > > > > From: Minoru Massaki > To: IBM-MAIN@LI

Re: DFSORT - How to select last 8 bytes in variable length records

2015-06-07 Thread Paul Gilmartin
On Sun, 7 Jun 2015 22:28:01 +0900, Minoru Massaki wrote: >Hello > >There is a input file of variable length records. >I want to insert the last 8 bytes of a record to front of the record as >following sample. ... > Must it be DFSORT? For example: 508 $ cat last8; sh last8 #! /bin/sh -x echo "\

Re: DFSORT - How to select last 8 bytes in variable length records

2015-06-07 Thread Martin Packer
logs/MartinPacker From: Minoru Massaki To: IBM-MAIN@LISTSERV.UA.EDU Date: 07/06/2015 14:28 Subject: DFSORT - How to select last 8 bytes in variable length records Sent by:IBM Mainframe Discussion List Hello There is a input file of variable length records. I want to ins

DFSORT - How to select last 8 bytes in variable length records

2015-06-07 Thread Minoru Massaki
Hello There is a input file of variable length records. I want to insert the last 8 bytes of a record to front of the record as following sample. Input file: RECORD01X11 RECORD02Y2 RECORD03ZCCC RECORD044A444 RECORD0555B Output File I want to have: