1 / 18

Intro to the AS/400

Intro to the AS/400. Chapter 8 - Data File Utility. Copyright 1999 by Janson Industries. Objectives. Explain the capabilities of a DML Explain how DFU performs typical DML functions Demonstrate the advantages and disadvantages of DFU. Allows you to add, delete and modify data

fern
Download Presentation

Intro to the AS/400

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Intro to the AS/400 Chapter 8 - Data File Utility Copyright 1999 by Janson Industries

  2. Objectives • Explain the capabilities of a DML • Explain how DFU performs typical DML functions • Demonstrate the advantages and disadvantages of DFU

  3. Allows you to add, delete and modify data On the AS/400 you can use Application programs SQL/400 DFU Data Manipulation Language

  4. DFU • Allows you to create temporary or permanent update programs • Permanent update programs are stored as program objects with an attribute equal to DFU. Library DFU User Type = *PGM Att = DFU

  5. DFU generated programs • Allow you to display, modify or delete a single record (from one file) at a time • Generate an audit report and a screen • When creating permanent programs you can control: • Which fields can be accessed • The format of the displayed data • Audit report content • The update screen appearance

  6. Using DFU • To Create and Run a Temporary Program: • STRDFU - Option 5 • Option 18 from the “Work with Objects using PDM” screen • You are prompted for a library and file name

  7. STRDFU

  8. Using DFU

  9. Using DFU • If file is empty, default is entry mode • If file has data, default is change mode • To switch between modes: • F9 - Entry Mode • F11 - Change Mode • F23 - Deletes current record

  10. Mode DFU update screen File Switch Modes

  11. Defining Permanent Programs • Option 2: Create a Program • Prompts for file and program names • A series of screens will be displayed which allow you to: • Control program functions - update on scroll, generate an audit report, etc. • Define the screen layout and save the DDS definition • Control data fields - select and sequence, format, etc.

  12. Defining Permanent DFU Programs Format Control Function Control

  13. Defining Permanent DFU Programs

  14. Defining Permanent DFU Programs

  15. Defining permanent programs • DFU creates: • The permanent program • A display file (a screen) • Optionally, the DDS screen definition Library *FILE DSPF *PGM DFU Source Physical File DFU User Type = DSPF

  16. DFU generated update programs • Allow you to update data • Generate an audit report Library Audit Report Data Physical File Update Program Member User data data

  17. Managing Permanent DFU Pgms • Option 1: Run a Program • Activates previously defined update programs • Option 3: Change a Program • The create screens are redisplayed with the originally specified values • You can change any value • Option 4: Delete a Program • Deletes any previously defined update program

  18. Points to Remember • DFU is a quick way to generate update programs • Update programs allow you to easily add, delete and update data, one record at a time. • Any significant amount of data is burdensome to manipulate with DFU generated programs. • Permanent programs can be tailored re: function and format.

More Related