Information Systems:DFU

From uniWIKI
Jump to navigation Jump to search

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.