Billy,
even simpler:
//SORT01 EXEC PGM=SORT
//SYSOUTDD SYSOUT=*
//SORTIN DD *
FRUIT ORANGES FLORIDA SKU#1
FRUIT ORANGES ARIZONA SKU#1
FRUIT ORANGES ARIZONA SKU#2
FRUIT GRAPESWISCONSIN SKU#3
FRUIT GRAPESIDAHO SKU#4
FRUIT GRAPESOREGON
Billy,
it was a bit challenging and I'm not 100% sure it's so generalized .
you've real file, try and let us know.
Here a stream who (in theory) does the needed, I've left different useless
output but understanding the flow:
//*
OK, now for another twist on a request from the same department. I have a
flat file that was dumped from a VSAM file, and it contains records with
major, medium and minor breaks. I know there is a way in SORT to suppress
printing the duplicate header values, but I spent an hour in the manual and
ca
Thank you for this, Max; with a couple tweaks on the key length, it works
just as I need it!
Have a great day!
Billy
On Wed, Sep 25, 2019 at 4:42 AM Massimo Biancucci wrote:
> Hi,
>
> I get a bit confused from the records you wrote and about joinkey.
>
> Anyway, assuming all keys are 20 bytes l
Hi,
I get a bit confused from the records you wrote and about joinkey.
Anyway, assuming all keys are 20 bytes long and havingthis input:
+1+2+3+4+5+6+7+8
DIV ORGANIC1 LOC NJ-HUNTERDON 1
DIV ORGANIC1
I would assume the DEPARTMENT and LOCATION tables are fairly static.
How about creating a table of each for your use? Have a run to insert
/ update the records from the appropriate source. Then you are left
with one job to parse the employees with these tables. I think they
can even do this with
