Information Systems:DFU
DFU is a tool to do uncontrolled updates to (almost) any file! So proceed with extreme caution whenever you use it.
DFU cannot be used on a file that has fields so long that they cannot fit on the display. An example of this is the cart file in Web Orders (XL_WEBSPT/PW_TRNF); it has a field that is 32,672 characters long. You must use EasyView (EZ) to manually edit it.
Some item files have ‘trigger programs’ attached. This is so that changes to them will also change the consolidated item master file. When you use DFU to change any of these, you must have the correct library list, either production or test, to match the file you are using. See Programming / Trigger Programs for a list of these files. Note that even though only the physical files are listed here, logical files are also affected.
These examples use the production inventory transaction file. Replace the library and file name with whatever you want.
You can start DFU directly by keying in the command STRDFU and pressing F4.
Start DFU (STRDFU) Type choices, press Enter. Option: DFU option . . . . . . . . . . 5 1-5, *SELECT Run option . . . . . . . . . . *NONE 1-2, *NONE DFU program . . . . . . . . . . *PRV Name, *PRV Library . . . . . . . . . . . *PRV Name, *PRV, *LIBL, *CURLIB Data base file . . . . . . . . . SRBITR Name, *PRV, *SAME Library . . . . . . . . . . . UP1480BFVA Name, *PRV, *LIBL, *CURLIB Member . . . . . . . . . . . . . *PRV Name, *PRV, *FIRST F3=Exit F4=Prompt F5=Refresh F12=Cancel F13=How to use this display F24=More keys
DFU option – 5 to update data using temporary program
Data Base File and Library – the file you wish to either view or change.
Press Enter.
Or you can navigate through PDM (Programming Development Manager).
On the command line, key in WRKOBJPDM UP1480BFVA and press enter.
Work with Objects Using PDM BART Library . . . . . UP1480BFVA Position to . . . . . . . . srbitr Position to type . . . . . *file Type options, press Enter. 2=Change 3=Copy 4=Delete 5=Display 7=Rename 8=Display description 9=Save 10=Restore 11=Move ... Opt Object Type Attribute Text __ FMR017 *PGM RPGLE G/L transactions enquiry and reconcil __ AMTADM *DTAQ AMT administration data queue __ AMTALR *DTAQ AMT alert data queue __ ASWDTAQOFL *DTAQ DPR-Order flow __ ASWDTAQ1 *DTAQ DPR-Sales __ ASWDTAQ2 *DTAQ DPR-Purchase __ ASWDTAQ3 *DTAQ DPR-Other __ AABABA *FILE LF Asset balance - Int seq/Asset no/Seq More... Parameters or command ===> _______________________________________________ F3=Exit F4=Prompt F5=Refresh F6=Create F9=Retrieve F10=Command entry F23=More options F24=More keys (C) COPYRIGHT IBM CORP. 1981, 2007.
For ‘position to’ key in SRBITR and for ‘position to type’ key in *FILE, then press enter.
Work with Objects Using PDM BART Library . . . . . UP1480BFVA Position to . . . . . . . . Position to type . . . . . Type options, press Enter. 2=Change 3=Copy 4=Delete 5=Display 7=Rename 8=Display description 9=Save 10=Restore 11=Move ... Opt Object Type Attribute Text 18 SRBITR *FILE LF Inventory transactions __ SRBITS *FILE LF Incident Time Stamps __ SRBIVC *FILE LF Invoice credit card payments __ SRBIVS *FILE LF Invoice settlements __ SRBIXI *FILE LF Inventory management info defaults & __ SRBJBN *FILE LF Job lock - control submitted job __ SRBJFPRT *FILE LF ASW JetForm valid printers table __ SRBJLC *FILE LF Job name (50 char) More... Parameters or command ===> _____________________________________________ F3=Exit F4=Prompt F5=Refresh F6=Create F9=Retrieve F10=Command entry F23=More options F24=More keys
Key ’18’ in front of file SRBITR and press enter.
WORK WITH DATA IN A FILE Mode . . . . : CHANGE Format . . . . : ITR File . . . . : SRBITR Inventory event code: SOC Ord no: 9000000 Ord line: _____ Non-Conf. Cert. No.: _______ Batch: ____________ F3=Exit F5=Refresh F6=Select format F9=Insert F10=Entry F11=Change
What you see on this screen will depend on the file. This is prompting you for the record you want. For example, key SOC for ‘Inventory event code’ and 9000000 for ‘Ord no’, then press enter. This will position to that place in the index, but in this case, there is not a record with that exact key, so a record is not displayed. Press page down to read the record with the next highest key. Or page down to read the record with the next lowest key.
WORK WITH DATA IN A FILE Mode . . . . : CHANGE Format . . . . : ITR File . . . . : SRBITR Inventory event code: SOC Ord no: 9981273 Ord line: 10 Non-Conf. Cert. No.: _______ Batch: _____________ Stat: _ Inv tran type: 800 Item: 02094803 Whse: RET Qty: 1000 Description: Sales order, credit Date: 20140604 Subm time: 152115 Sum trns: _ Transit deliv. Y/N: N P l no: _______ P L line no: _____ Pick cons. no: _______ Shipm. no: _______ F3=Exit F5=Refresh F6=Select format F9=Insert F10=Entry F11=Change
There may be too many fields on the record to fit on the display. If so, pressing enter will show more. When all fields have been show, the screen prompting for the key will be shown again.
If you are making a change to a record that takes more than one screen to show all its fields, you must either keep pressing enter until you see the screen prompting for the key, or press page up. If you don’t do this, the change will
If you are making a change to a record that takes more than one screen to show all its fields, you must either keep pressing enter until you see the screen prompting for the key, or press page up. If you don’t do this, the change will not update the record.
You can add a record by pressing F10. To make sure you get everything, copy from an existing record. When you are done, you can press F11 to get back to change mode.
You can delete the record shown by pressing F23 twice. Be careful.
When you are done, press F3 to exit. You will see a count of how many records you have added, changed, or deleted. Press enter.