Embedded Files
Subscribe to keep this site alive! Under new management but as always, still 100% FREE. Anyone with the IBM i is a friend of ours.
The Challenge: How could we insert an optional Tare or Pack to an S-O-I logical file. Retrofitting this to an existing logical will save backend processing.
Examples:
H-S-O-I-I-I-I
H-S-O-T-I-T-I-O-T-I
H-S-O-P-I-P-I-O-P-I
The Solution: Create a new file (VASNTOP) for the new level to be inserted. Since it will be one or the other, both TARE and PACK will share the same key (field) - MAN (Marks and Numbers). A Level Flag will indicate what level it is for. The new file should have fields of the keys of the level above it - Order (VASNORD). The lower levels should also have the new key of the level being added.
Modify the multi record format logical:
a. Add 2 new record formats; the VASNTARE and VASNPACK against the VASNTOP physical file.
b. Assign keys for both which will have the same key as the Order Level + the common key for this level - MAN (Marks and Numbers).
c. Add Select/Omit setup for the Level Flag (LEVEL) to differentiate the Tare vs the Pack.
d. Insert the new key of the level being added to the lower level hierarchies after the key of the Order Level.
Work File Preparation: For the existing "single pack shipment" (SOI), the VASNTOP record can still be added but with the Level Flag of *blank. If it identified to be a Tare Shipment, it will be populated with a "T" and for the Pack "P".
WARNING: Implication of mixing Tare/Pack types or even a mixture of all three should be reviewed: Is it to be allowed, stopped or contravened?
NOTE: Bad News! You can not to retrofit the new hierarchy on the SOI map, or else the map will unpredictable. A new map should be created with a SOPTI or SOTPI hierarchy using the Modified UFD.
The map structure is established in the on-set of the map creation for any hierarchical document.
But there will still be no change to the post Add-to-TC process due to the partial processing of the logical (because there is only one UFD).
Do you have a new CHALLENGE? Let us know HERE.
Page updated
Google Sites
Report abuse