Intro to the as 400
Download
1 / 18

Intro to the AS/400 - PowerPoint PPT Presentation


  • 230 Views
  • Updated On :

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'Intro to the AS/400' - fern


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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
Intro to the as 400 l.jpg

Intro to the AS/400

Chapter 8 - Data File Utility

Copyright 1999 by Janson Industries


Objectives l.jpg
Objectives

  • Explain the capabilities of a DML

  • Explain how DFU performs typical DML functions

  • Demonstrate the advantages and disadvantages of DFU


Data manipulation language l.jpg

Allows you to add, delete and modify data

On the AS/400 you can use

Application programs

SQL/400

DFU

Data Manipulation Language


Slide4 l.jpg
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


Dfu generated programs l.jpg
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


Using dfu l.jpg
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




Using dfu9 l.jpg
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


Dfu update screen l.jpg

Mode

DFU update screen

File

Switch Modes


Defining permanent programs l.jpg
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.


Defining permanent dfu programs l.jpg
Defining Permanent DFU Programs

Format Control

Function Control




Defining permanent programs15 l.jpg
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


Dfu generated update programs l.jpg
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


Managing permanent dfu pgms l.jpg
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


Points to remember l.jpg
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.


ad