Table of Contents

About Distributed Data Management

  • Who should read the Distributed Data Management book

    • Introduction to OS/400 DDM

  • System Compatibility
  • Overview of DDM Functions
  • Basic OS/400 DDM Concepts
  • Parts of DDM
  • Parts of DDM: Source DDM (SDDM)
  • Parts of DDM: Target DDM (TDDM)
  • Parts of DDM: DDM File
  • Additional OS/400 DDM Concepts
  • AS/400 System as the Source System for DDM
  • AS/400 System as the Target System for DDM
  • DDM-Related Jobs and DDM Conversations
  • Examples of Accessing Multiple Remote Files with DDM
  • Example of Accessing Files on Multiple Systems with DDM
  • Example of Processing Multiple Requests for Remote Files with DDM

    • Language, Utility, and Application Considerations for DDM

  • Programming Language Considerations for DDM
  • DDM Considerations for All Languages
  • Commitment Control Support for DDM
  • ILE RPG Considerations for DDM
  • ILE COBOL Considerations for DDM
  • BASIC Considerations for DDM
  • PL/I Considerations for DDM
  • CL Command Considerations for DDM
  • ILE C Considerations for DDM
  • Utility Considerations for DDM
  • System/38-Compatible Database Tools
  • Data File Utility for AS/400 System
  • OS/400 Database Query
  • Sort Utility
  • Application Programs Considerations for DDM
  • OfficeVision
  • Client Access
  • Hierarchical File System API Support for DDM

    • Preparing to Use DDM

  • Communications Requirements for DDM
  • Security Requirements for DDM
  • DDM File Requirements
  • Program Modification Requirements for DDM
  • DDM Architecture-Related Restrictions
  • AS/400 Source and Target Restrictions and Considerations for DDM
  • Non-AS/400 Target Restrictions and Considerations for DDM

    • Security Considerations for DDM

  • Elements of DDM Security
  • DDM Source System Security
  • DDM Target System Security
  • User-Related Elements of Target Security for DDM
  • Object-Related Levels of Target Security for DDM
  • User Exit Program for Additional Security for DDM

    • CL Command Descriptions and DDS Considerations for DDM

  • DDM-Specific CL Commands
  • CHGDDMF (Change DDM File) Command
  • CRTDDMF (Create DDM File) Command
  • DSPDDMF (Display DDM Files) Command
  • RCLDDMCNV (Reclaim DDM Conversations) Command
  • SBMRMTCMD (Submit Remote Command) Command
  • WRKDDMF (Work with DDM Files) Command
  • DDM-Related CL Command Considerations
  • File Management Handling of DDM Files
  • ALCOBJ (Allocate Object) Command
  • CHGJOB (Change Job) Command
  • CHGLF (Change Logical File) Command
  • CHGPF (Change Physical File) Command
  • CHGSRCPF (Change Source Physical File) Command
  • CLRPFM (Clear Physical File Member) Command
  • Copy Commands with DDM
  • CRTDTAARA (Create Data Area) Command
  • CRTDTAQ (Create Data Queue) Command
  • CRTLF (Create Logical File) Command
  • CRTPF (Create Physical File) Command
  • CRTSRCPF (Create Source Physical File) Command
  • DLCOBJ (Deallocate Object) Command
  • DLTF (Delete File) Command
  • DSPFD (Display File Description) Command
  • DSPFFD (Display File Field Description) Command
  • OPNQRYF (Open Query File) Command
  • OVRDBF (Override with Database File) Command
  • RCLRSC (Reclaim Resources) Command
  • RNMOBJ (Rename Object) Command
  • WRKJOB (Work with Job) Command
  • WRKOBJLCK (Work with Object Lock) Command
  • DDM-Related CL Parameter Considerations
  • DDMACC Parameter Considerations
  • DDMCNV Parameter Considerations
  • OUTFILE Parameter Considerations for DDM
  • DDM-Related CL Command Lists
  • Object-Oriented Commands with DDM
  • Target AS/400-Required File Management Commands
  • Member-Related Commands with DDM
  • Commands Not Supporting DDM
  • Source File Commands
  • Data Description Specifications (DDS) Considerations for DDM
  • AS/400 Target Considerations for DDM
  • Non-AS/400 Target Considerations for DDM
  • DDM-Related DDS Keywords and Information
  • DDM User Profile Authority

    • Using DDM Over TCP/IP

  • Using DDM Over TCP/IP: Configuring a Communications Network for TCP/IP
  • DDM Security using TCP/IP
  • Using DDM Over TCP/IP: Setting Up the TCP/IP Server
  • Using DDM Over TCP/IP: Setting Up DDM Files
  • Using DDM Over TCP/IP: Managing the TCP/IP Server
  • Using DDM Over TCP/IP: Terminology
  • Using DDM Over TCP/IP: TCP/IP Communication Support Concepts
  • Using DDM Over TCP/IP: QSYSWRK Subsystem
  • Using DDM Over TCP/IP: Identifying Server Jobs
  • Using DDM Over TCP/IP: Handling Connection Request Failures for TCP/IP
  • DDM Server Is Not Started or the Port ID Is Not Valid
  • DDM Connection Authorization Failure
  • DDM Server Not Available
  • Not Enough Prestart Jobs at Server

    • Operating Considerations for DDM

  • File Access Considerations for DDM
  • Types of Files Supported by OS/400 DDM
  • Existence of DDM File and Remote File
  • Specifying Target System File Names for DDM
  • Examples of Accessing AS/400 DDM Remote Files (AS/400-to-AS/400)
  • Example of Accessing System/36 DDM Remote Files (AS/400-to-System/36)
  • Member Access Considerations for DDM
  • Examples of Accessing DDM Remote Members (AS/400 System Only)
  • Example of a DDM File That Opens a Specific Member
  • Access Method Considerations for DDM
  • Access Intents
  • Key Field Updates
  • Deleted Records
  • Blocked Record Processing
  • Variable-Length Records
  • Other DDM-Related Functions Involving Remote Files
  • Performing File Management Functions on Remote Systems
  • Locking Files and Members for DDM
  • Controlling DDM Conversations
  • Displaying DDM Remote File Information
  • Displaying DDM Remote File Records
  • Coded Character Set Identifier (CCSID) with DDM
  • Using Object Distribution
  • Using Object Distribution with DDM
  • Performance Considerations for DDM
  • Batch File Processing with DDM
  • Interactive File Processing with DDM
  • DDM Conversation Length Considerations
  • DDM Problem Analysis on the Remote System
  • System/36 Source and Target Considerations for DDM
  • DDM-Related Differences between AS/400 and System/36 Files
  • System/36 Source to AS/400 Target Considerations for DDM
  • AS/400 Source to System/36 Target Considerations for DDM
  • Override Considerations to System/36 for DDM
  • Personal Computer Source to AS/400 Target Considerations for DDM

    • Appendix A. Examples of Coding DDM-Related Tasks

  • Communications Setup for DDM Examples and Tasks
  • DDM Example 1: Simple Inquiry Application
  • DDM Example 2: ORDERENT Application
  • DDM Example 2: Central System ORDERENT Files
  • DDM Example 2: Description of ORDERENT Program
  • DDM Example 2: Remote Systems ORDERENT Files
  • DDM Example 2: Transferring a Program to a Target System
  • DDM Example 2: Copying a File
  • DDM Example 3: Accessing Multiple AS/400 Files
  • DDM Example 4: Accessing a File on System/36

    • Appendix B. DDM-Related CL Command Summary Charts

    Appendix C. DDM Architecture Code Point Attributes

    Appendix D. DDM Commands and Parameters

  • Subsets of DDM Architecture Supported by OS/400. DDM
  • Supported DDM File Models
  • Supported DDM Access Methods
  • DDM Commands and Objects
  • DDM Command Parameters
  • CHGCD (Change Current Directory) Level 2.0
  • CHGEOF (Change End of File) Level 2.0 and Level 3.0
  • CHGFAT (Change File Attribute) Level 2.0
  • CLOSE (Close File) Level 1.0 and Level 2.0
  • CLRFIL (Clear File) Level 1.0 and Level 2.0
  • CLSDRC (Close Directory) Level 2.0
  • CPYFIL (Copy File) Level 2.0
  • CRTAIF (Create Alternate Index File) Level 1.0 and Level 2.0
  • CRTDIRF (Create Direct File) Level 1.0 and Level 2.0
  • CRTDRC (Create Directory) Level 2.0
  • CRTKEYF (Create Keyed File) Level 1.0 and Level 2.0
  • CRTSEQF (Create Sequential File) Level 1.0 and Level 2.0
  • CRTSTRF (Create Stream File) Level 2.0
  • DCLFIL (Declare File) Level 1.0 and Level 2.0
  • DELDCL (Delete Declared Name) Level 1.0
  • DELDRC (Delete Directory) Level 2.0
  • DELFIL (Delete File) Level 1.0 and Level 2.0
  • DELREC (Delete Record) Level 1.0
  • EXCSAT (Exchange Server Attributes) Level 1.0 and Level 2.0
  • FILAL and FILATTRL (File Attribute List) Level 1.0, Level 2.0, and Level 3.0
  • FRCBFF (Force Buffer) Level 2.0
  • GETDRCEN (Get Directory Entries) Level 2.0
  • GETREC (Get Record at Cursor) Level 1.0
  • GETSTR (Get Substream) Level 2.0 and Level 3.0
  • INSRECEF (Insert at EOF) Level 1.0
  • INSRECKY (Insert Record by Key Value) Level 1.0
  • INSRECNB (Insert Record at Number) Level 1.0
  • LCKFIL (Lock File) Level 1.0 and Level 2.0
  • LCKSTR (Lock Substream) Level 2.0 and Level 3.0
  • LODRECF (Load Record File) Level 1.0 and Level 2.0
  • LODSTRF (Load Stream File) Level 2.0
  • LSTFAT (List File Attributes) Level 1.0, Level 2.0, and Level 3.0
  • MODREC (Modify Record with Update Intent) Level 1.0
  • OPEN (Open File) Level 1.0 and Level 2.0
  • OPNDRC (Open Directory) Level 2.0
  • PUTSTR (Put Substream) Level 2.0 and Level 3.0
  • QRYCD (Query Current Directory) Level 2.0
  • QRYSPC (Query Space) Level 2.0
  • RNMDRC (Rename Directory) Level 2.0
  • RNMFIL (Rename File) Level 1.0 and Level 2.0
  • SBMSYSCMD (Submit System Command) Level 4.0
  • SETBOF (Set Cursor to Beginning of File) Level 1.0
  • SETEOF (Set Cursor to End of File) Level 1.0
  • SETFRS (Set Cursor to First Record) Level 1.0
  • SETKEY (Set Cursor by Key) Level 1.0
  • SETKEYFR (Set Cursor to First Record in Key Sequence) Level 1.0
  • SETKEYLM (Set Key Limits) Level 1.0
  • SETKEYLS (Set Cursor to Last Record in Key Sequence) Level 1.0
  • SETKEYNX (Set Cursor to Next Record in Key Sequence) Level 1.0
  • SETKEYPR (Set Cursor to Previous Record in Key Sequence) Level 1.0
  • SETLST (Set Cursor to Last Record) Level 1.0
  • SETMNS (Set Cursor Minus) Level 1.0
  • SETNBR (Set Cursor to Record Number) Level 1.0
  • SETNXT (Set Cursor to Next Number) Level 1.0
  • SETNXTKE (Set Cursor to Next Record in Key Sequence with a Key Equal to Value Specified) Level 1.0
  • SETPLS (Set Cursor Plus) Level 1.0
  • SETPRV (Set Cursor to Previous Record) Level 1.0
  • SETUPDKY (Set Update Intent by Key Value) Level 1.0
  • SETUPDNB (Set Update Intent by Record Number) Level 1.0
  • ULDRECF (Unload Record File) Level 1.0
  • ULDSTRF (Unload Stream File) Level 2.0
  • UNLFIL (Unlock File) Level 1.0 and Level 2.0
  • UNLIMPLK (Unlock Implicit Record Lock) Level 1.0
  • UNLSTR (Unlock Substreams) Level 2.0 and Level 3.0
  • User Profile Authority

    • Appendix E. AS/400 System-to-CICS Considerations with DDM

  • AS/400 Languages, Utilities, and Licensed Programs
  • CRTDDMF (Create DDM File) Considerations
  • AS/400 CL Considerations
  • Language Considerations for AS/400 System and CICS
  • PL/I Considerations
  • ILE COBOL Considerations
  • ILE C Considerations
  • ILE RPG Considerations

    • Appendix F. DDM Differences

  • AS/400 System and System/36 DDM Differences
  • AS/400 System and System/38 DDM Differences

    • Bibliography

    Index

    [ Top of Page | Previous Page | Next Page | Table of Contents | Index ]