DDS for physical and logical files


Contents

About DDS for physical and logical files

  • Who should read the DDS for physical and logical files book
  • Conventions and terminology used in the DDS information
  • Print this topic
  • What's New for V5R3 in the DDS for physical and logical files information
  • Defining physical and logical files using DDS

  • Defining a physical file using DDS
  • Defining a logical file using DDS
  • Simple and multiple format logical files in DDS
  • Join logical files in DDS
  • Specifying record formats in a logical file in DDS
  • Positional entries for physical and logical files (positions 1 through 44)
  • Sequence number for physical and logical files (positions 1 through 5)
  • Form type for physical and logical files (position 6)
  • Comment for physical and logical files (position 7)
  • Conditioning for physical and logical files (positions 8 through 16)
  • Type of name or specification for physical and logical files (position 17)
  • Reserved for physical and logical files (position 18)
  • Name for physical and logical files (positions 19 through 28)
  • Reference for physical and logical files (position 29)
  • Length for physical and logical files (positions 30 through 34)
  • Data type for physical and logical files (position 35)
  • Decimal positions for physical and logical files (positions 36 and 37)
  • Usage for physical and logical files (position 38)
  • Location for physical and logical files (positions 39 through 44)
  • Keyword entries for physical and logical files (positions 45 through 80)

  • ABSVAL (Absolute Value) keyword for physical and logical files
  • ALIAS (Alternative Name) keyword for physical and logical files
  • ALL (All) keyword--logical files only
  • ALTSEQ (Alternative Collating Sequence) keyword for physical and logical files
  • ALWNULL (Allow Null Value) keyword--physical files only
  • CCSID (Coded Character Set Identifier) keyword for physical and logical files
  • CHECK (Check) keyword for physical and logical files
  • CHKMSGID (Check Message Identifier) keyword for physical and logical files
  • CMP (Comparison) keyword for physical and logical files
  • COLHDG (Column Heading) keyword for physical and logical files
  • COMP (Comparison) keyword for physical and logical files
  • Specifying COMP at the field level
  • Specifying COMP at the select or omit-field level
  • CONCAT (Concatenate) keyword--logical files only
  • DATFMT (Date Format) keyword for physical and logical files
  • DATSEP (Date Separator) keyword for physical and logical files
  • DESCEND (Descend) keyword for physical and logical files
  • DFT (Default) keyword--physical files only
  • DIGIT (Digit) keyword for physical and logical files
  • DYNSLT (Dynamic Select) keyword--logical files only
  • EDTCDE (Edit Code) and EDTWRD (Edit Word) keywords for physical and logical files
  • FCFO (First-Changed First-Out) keyword for physical and logical files
  • FIFO (First-In First-Out) keyword for physical and logical files
  • FLTPCN (Floating-Point Precision) keyword for physical and logical files
  • FORMAT (Format) keyword for physical and logical files
  • JDFTVAL (Join Default Values) keyword--join logical files only
  • JDUPSEQ (Join Duplicate Sequence) keyword--join logical files only
  • JFILE (Joined Files) keyword--join logical files only
  • JFLD (Joined Fields) keyword--join logical files only
  • JOIN (Join) keyword--join logical files only
  • JREF (Join Reference) keyword--join logical files only
  • LIFO (Last-In First-Out) keyword for physical and logical files
  • NOALTSEQ (No Alternative Collating Sequence) keyword for physical and logical files
  • PFILE (Physical File) keyword--logical files only
  • RANGE (Range) keyword for physical and logical files
  • Specifying RANGE at the field level
  • Specifying RANGE at the select or omit-field level
  • REF (Reference) keyword--physical files only
  • REFACCPTH (Reference Access Path Definition) keyword--logical files only
  • REFFLD (Referenced Field) keyword--physical files only
  • REFSHIFT (Reference Shift) keyword for physical and logical files
  • RENAME (Rename) keyword--logical files only
  • SIGNED (Signed) keyword for physical and logical files
  • SST (Substring) keyword--logical files only
  • TEXT (Text) keyword for physical and logical files
  • TIMFMT (Time Format) keyword for physical and logical files
  • TIMSEP (Time Separator) keyword for physical and logical files
  • TRNTBL (Translation Table) keyword--logical files only
  • UNIQUE (Unique) keyword for physical and logical files
  • UNSIGNED (Unsigned) keyword for physical and logical files
  • VALUES (Values) keyword for physical and logical files
  • Specifying VALUES at the field level
  • Specifying VALUES at the select or omit-field level
  • VARLEN (Variable-Length Field) keyword for physical and logical files
  • ZONE (Zone) keyword for physical and logical files
  • Appendix A. Unicode considerations for database files

  • Length (positions 30 through 34)
  • Data type (position 35)
  • Decimal positions (positions 36 and 37)
  • Keyword considerations (positions 45 through 80)
  • Appendix B. DBCS considerations for database files

  • Positional entry considerations for database files that use DBCS
  • Length (positions 30 through 34)
  • Data type (position 35)
  • Decimal (positions 36 and 37)
  • Keyword considerations for database files that use DBCS
  • CONCAT (Concatenate) keyword
  • Additional considerations for describing database files that contain DBCS data
  • Index


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