Library View Topics Framed Contents Revised Topics Previous Topic Next Topic Search Search ResultsPrevious Topic MatchNext Topic Match Notes List Notes Print Download No PDF Handheld DisconnectedHandheld ConnectedHelp
Title: Data File Utility User's Guide and Reference
Document Number: SC09-1381-00
Build Date: 09/18/92 18:30:32 Build Version: 1.2
Document Path: /home/webapps/epubs/htdocs/book/qbka0500.boo

CONTENTS Table of Contents


Summarize

COVER         Book Cover 

NOTICES       Notices 

EDITION       Edition Notice 

CONTENTS      Table of Contents 

FRONT_1       Notices 

PREFACE       About This Manual 
PREFACE.1     Who Should Use This Manual 

1.0           Chapter 1.  Introducing DFU 
1.1           Creating a Program 
1.2           Running a Program 
1.3           When to Use a Programming Language 
1.4           Describing a File 
  1.4.1         RPG II-Described Files 
  1.4.2         DDS-Described Files 
  1.4.3         IDDU-Described Files 
1.5           DFU Function Keys 
  1.5.1         Definition Function Keys 
  1.5.2         Run-Time Function Keys 
1.6           Starting the Data File Utility 
  1.6.1         DFU Commands 
  1.6.2         Using the STRDFU Command 
    1.6.2.1       AS/400 Data File Utility (DFU) Menu 
  1.6.3         Distributed Data Management Support 

2.0           Chapter 2.  Creating a DFU Program 
2.1           Data Entry Display Example 
2.2           Procedure for Creating a DFU Program 
  2.2.1         Create a DFU Program Display 
  2.2.2         Select File Display 
  2.2.3         Define General Information/Indexed File Display 
  2.2.4         Define Audit Control Display 
  2.2.5         Work with Record Formats Display 
  2.2.6         Select and Sequence Fields Display 
  2.2.7         Work with Fields Display 
  2.2.8         Specify Extended Field Definition Display for Numeric Fields 
  2.2.9         Specify Validity Checks Display for Numeric Fields 
  2.2.10        Specify Extended Field Definition Display for Alphanumeric Fields 
  2.2.11        Specify Validity Checks Display for Alphanumeric Fields 
  2.2.12        Definition Process for Second Record Format 
  2.2.13        Display DFU Program Summary Display 
  2.2.14        Display DFU Program Detail Display 
  2.2.15        Display Data File Detail Display 
  2.2.16        Exit DFU Program Definition Display 
  2.2.17        Change a Data File Display 
2.3           Creating a DFU Program for a Nonindexed File 
  2.3.1         Create a DFU Program Display 
  2.3.2         Define General Information/Nonindexed File Display 
  2.3.3         Define Audit Control Display 
  2.3.4         Select Field for Record Number Display 
  2.3.5         Work with Record Formats Display 
  2.3.6         Select and Sequence Fields Display 
  2.3.7         Exit DFU Program Definition Display 

3.0           Chapter 3.  Changing a DFU Program 
3.1           Procedure for Changing a DFU Program 
  3.1.1         Change a DFU Program Display 
  3.1.2         Select Program Display 
  3.1.3         Work with Record Formats Display 
  3.1.4         Work with Fields Display 
  3.1.5         Exit DFU Program Definition Display 
  3.1.6         Display a Data File Display 

4.0           Chapter 4.  Running a DFU Program 
4.1           Procedure for Running a DFU Program 
  4.1.1         Run a DFU Program Menu 
  4.1.2         Change a Data File Display 
  4.1.3         Select Data File Member Display 
  4.1.4         Select Record Format Display 
  4.1.5         Display Batch Accumulators Display 
  4.1.6         Display Run Status Display 
  4.1.7         End Data Entry Display 
  4.1.8         Display Total Accumulators Display 
  4.1.9         Audit Report 

5.0           Chapter 5.  Updating Data Using a Temporary Program 
5.1           Procedure for Updating Data Using a Temporary Program 
  5.1.1         Update Data Using Temporary Program Display 
  5.1.2         End Data Entry Display 

6.0           Chapter 6.  Tailoring a DFU Display 
6.1           Saving the DDS Source 
6.2           Tailoring a DFU Data Entry Display 
  6.2.1         Design Screens Display 
  6.2.2         Work with Display Records Display 
  6.2.3         Design Image Work Screen 
  6.2.4         Exit SDA Work Screen Display 
  6.2.5         Save DDS - Create Display File Display 
6.3           Creating a DFU Display File 

7.0           Chapter 7.  Deleting a DFU Program 
7.1           Procedure for Deleting a DFU Program 
  7.1.1         Delete a DFU Program Display 
  7.1.2         Select Program Display 
  7.1.3         Confirm Delete of DFU Program Display 

8.0           Chapter 8.  Reference Information for DFU Displays 
  8.1           Change a Data File Display 
  8.2           Change a DFU Program Display 
  8.3           Confirm Delete of DFU Programs Display 
  8.4           Create DFU Display File (CRTDFUDSPF) Display 
  8.5           Create a DFU Program Display 
  8.6           Data Entry Display 
  8.7           Define Audit Control Display 
  8.8           Define General Information/Indexed File Display 
  8.9           Define General Information/Nonindexed File Display 
  8.10          Delete a DFU Program Display 
  8.11          Display a Data File Display 
  8.12          Display Batch Accumulators Display 
  8.13          Display Data File Detail Display 
  8.14          Display DFU Program Detail Display 
  8.15          Display DFU Program Summary Display 
  8.16          Display Run Status Display 
  8.17          Display Total Accumulators Display 
  8.18          End Data Display Display 
  8.19          End Data Entry Display 
  8.20          Exit DFU Program Definition Display 
  8.21          Run a DFU Program Menu 
  8.22          Select and Sequence Fields Display 
  8.23          Select Data File Member Display 
  8.24          Select Field for Record Number Display 
  8.25          Select File Display 
  8.26          Select Program Display 
  8.27          Select Record Format Display 
  8.28          Specify Extended Field Definition Display for Alphanumeric Fields 
  8.29          Specify Extended Field Definition Display for Numeric Fields 
  8.30          Specify Validity Checks Display for Alphanumeric Fields 
  8.31          Specify Validity Checks Display for Numeric Fields 
  8.32          Update Data Using Temporary Program Display 
  8.33          Work with Fields Display 
  8.34          Work with Record Formats Display 

A.0           Appendix A.  Additional Considerations 
A.1           Security 
  A.1.1         Authority 
    A.1.1.1       Object Authority 
    A.1.1.2       Data Authority 
  A.1.2         Command Authorization 
  A.1.3         Database File Authorization 
  A.1.4         Default Security Implications 
A.2           DFU Use of Database Files 
  A.2.1         Level Checking 
  A.2.2         Multiple Record Formats 
    A.2.2.1       Example 1 
    A.2.2.2       Example 2 
A.3           Using the Library List 
A.4           Responding to File Changes 
A.5           Error Suppression 
A.6           Unsupported Data Types 

B.0           Appendix B.  Double-Byte Character Set Considerations for DFU Programs 
B.1           Supported DBCS Characters 
B.2           Software Requirements 
B.3           Programming Considerations 

C.0           Appendix C.  Control Language Commands in the Data File Utility 
C.1           CHGDTA (Change Data) Command 
C.2           CRTDFUDSPF (Create DFU Display File) Command 
C.3           DLTDFUPGM (Delete DFU Program) Command 
C.4           DSPDTA (Display Data) Command 
C.5           STRDFU (Start DFU) Command 
C.6           UPDDTA (Update Data) Command 

D.0           Appendix D.  Using DFU in the System/36 Environment 
D.1           RPG II-Described Files 
D.2           System/36 Style Run-Time Function Keys 
D.3           Creating a DFU Program through the System/36 Environment 
D.4           Example System/36 Data Entry Display 
D.5           Procedure for Creating a DFU Program from the System/36 Environment 
D.6           Creating a DFU Program for an Indexed Data File 
  D.6.1         Create a DFU Program Display 
  D.6.2         Select RPG II Source Member 
  D.6.3         Define General Information/Indexed File Display 
  D.6.4         Define Audit Control Display 
  D.6.5         Select S/36 Style Options Display 
  D.6.6         Work with Record Types Display 
  D.6.7         Display Record Type Display 
  D.6.8         Select and Sequence Fields Display 
  D.6.9         Work with Fields Display 
  D.6.10        Specify Extended Field Definition Display for Alphanumeric Fields 
  D.6.11        Display DFU Program Summary Display 
  D.6.12        Display DFU Program Detail Display 
  D.6.13        Display Data File Detail Display 
  D.6.14        Exit DFU Program Definition Display 
  D.6.15        Display a Data File Display 
D.7           Reference Information for Using DFU in a System/36 Environment 
  D.7.1         Select RPG II Source Member Display 
  D.7.2         RPG II Information on the Create a DFU Program Display 
  D.7.3         Select S/36 Style Options Display 
  D.7.4         Work with Record Types Display 
  D.7.5         Display Record Type Display 
  D.7.6         Select and Sequence Fields Display 
  D.7.7         Work with Fields Display 
  D.7.8         Specify Extended Field Definition Display 
  D.7.9         Specify Validity Checks Display 
  D.7.10        Display DFU Program Summary Display 
  D.7.11        Display DFU Program Detail Display 
  D.7.12        Display Data File Detail Display 
  D.7.13        Display a Data File Display 

E.0           Appendix E.  Calculating Modulus 10 and Modulus 11 Self-Check Digits 
E.1           Modulus 10 Self-Check Digit 
E.2           Modulus 11 Self-Check Digit 

F.0           Appendix F.  Differences Between System/38, System/36, and AS/400 DFU 
F.1           DFU Migration 
F.2           Changing Programs Using OCL Procedures 
F.3           Printing Reports 
F.4           Deleting Records 
F.5           Audit Reports 
F.6           Blank Records 
F.7           Key Fields on the Data Entry Display 
F.8           CHGDTA Command 
F.9           Record Backspace (Cmd 5) 

BIBLIOGRAPHY  Bibliography 

INDEX         Index 


Previous Topic Next Topic Copyright IBM Corp. 1988, 1991

IBM Library Server Copyright 1989, 2005 IBM Corporation. All rights reserved.