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

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
mas > > 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: 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: dfsort: Sort job to get price variance records

2019-08-01 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

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