Re: Sort job to get price variance records

2019-08-04 Thread Andrew Rowley
On 5/08/2019 11:33 am, Paul Gilmartin wrote: +1 I'm probably partisan, but I'd look to Rexx or awk, both of which provide useful associative arrays. Personally on z/OS I would look to Java. I used to use Rexx a lot, but after getting used to Java and similar languages I find Rexx very limiting

Re: Sort job to get price variance records

2019-08-04 Thread Paul Gilmartin
On Mon, 5 Aug 2019 10:55:00 +1000, Andrew Rowley wrote: >On 1/08/2019 8:03 am, Ron Thomas wrote: >> >> We have a FB File LRECL = 80 bytes and here below is the layout. Buy_price >> is at position 65 of length 10 bytes . We need to pull those item nbrs >> which has same UPC,Vendor nbr ,State Code

Re: dfsort: Sort job to get price variance records

2019-08-04 Thread Andrew Rowley
On 1/08/2019 8:03 am, Ron Thomas wrote: Hi. We have a FB File LRECL = 80 bytes and here below is the layout. Buy_price is at position 65 of length 10 bytes . We need to pull those item nbrs which has same UPC,Vendor nbr ,State Code but there is price difference. Could anyone let me know how th

Re: dfsort: Sort job to get price variance records

2019-08-02 Thread John McKown
On Fri, Aug 2, 2019 at 8:17 AM Joe Monk wrote: > Thats not what is being asked ... > > In the sample output... > > 50338 789997580026.00 36052910DF 96.12 > 50338 789997580026.00 36052910DF 96.12 > 50338 789997580026.00 36052910

Re: dfsort: Sort job to get price variance records

2019-08-02 Thread Joe Monk
cords is the same: 95.12. So > there is no variance in the price. There are just duplicate records. > > > > > > > > -Original Message- > > > From: IBM Mainframe Discussion List On > > > Behalf Of Ron Thomas > > > Sent: Thursday, Augus

Re: dfsort: Sort job to get price variance records

2019-08-01 Thread John McKown
; > Sent: Thursday, August 01, 2019 8:03 AM > > To: IBM-MAIN@LISTSERV.UA.EDU > > Subject: Re: dfsort: Sort job to get price variance records > > > > Ok Elardus. > > > > I will paste the requirement and output files generated again > > > > We have a

Re: dfsort: Sort job to get price variance records

2019-08-01 Thread retired mainframer
Why are two records desired for 96.12 but only one for 95.12? > -Original Message- > From: IBM Mainframe Discussion List On > Behalf Of Ron Thomas > Sent: Thursday, August 01, 2019 8:03 AM > To: IBM-MAIN@LISTSERV.UA.EDU > Subject: Re: dfsort: Sort job to get pric

Re: Sort job to get price variance records

2019-08-01 Thread Ron Thomas
Thanks a lot Kolusu.. You are amazing to say the least !!! -- For IBM-MAIN subscribe / signoff / archive access instructions, send email to lists...@listserv.ua.edu with the message: INFO IBM-MAIN

Re: Sort job to get price variance records

2019-08-01 Thread Sri h Kolusu
>>I am getting the o/p as expected , but not sure whether what i have done is completely correct . Could you please check and let me know if the above needs correction ? Ron, You are NOT getting the o/p as expected. You shouldn't be writing the 50318 789997580026.00 36052911 DF record as it

Re: dfsort: Sort job to get price variance records

2019-08-01 Thread Ron Thomas
Ok Elardus. I will paste the requirement and output files generated again We have a FB File LRECL = 80 bytes and here below is the layout. Buy_price is at position 65 of length 10 bytes . We need to pull those item nbrs which has same UPC,Vendor nbr ,State Code but there is price difference.

Re: Sort job to get price variance records

2019-08-01 Thread Ron Thomas
Ok Kolusu, will remove dfsort tag from subject line . Thanks again for providing the steps. Here is what i have done //STEP03 EXEC SORT //SORTIN DD * 50338 789997580026.00 36052910 DF 96.12 50338 789997580026.00 36052910 DF 96.12 50

Re: dfsort: Sort job to get price variance records

2019-07-31 Thread Elardus Engelbrecht
Sri h Kolusu wrote: >Ron, >All of your previous queries showed that you are using the competitive product >to DFSORT. If that is still true, I would really appreciate if you can stop >tagging the questions as DFSORT questions. Good point. I remember your post in Feb 2016: "OP's Shop uses Comp

Re: dfsort: Sort job to get price variance records

2019-07-31 Thread Sri h Kolusu
>>Could anyone let me know how this to be done using dfsort. Ron, All of your previous queries showed that you are using the competitive product to DFSORT. If that is still true, I would really appreciate if you can stop tagging the questions as DFSORT questions. Giving you the benefit of doubt,

dfsort: Sort job to get price variance records

2019-07-31 Thread Ron Thomas
Hi. We have a FB File LRECL = 80 bytes and here below is the layout. Buy_price is at position 65 of length 10 bytes . We need to pull those item nbrs which has same UPC,Vendor nbr ,State Code but there is price difference. Could anyone let me know how this to be done using dfsort. Input file :