DP DDS Physical
- ABSVAL (Absolute Value) keyword for physical and logical files
- Additional considerations for describing database files that contain DBCS data
- 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
- Comment for physical and logical files (position 7)
- CONCAT (Concatenate) keyword
- CONCAT (Concatenate) keyword—logical files only
- Condition for physical and logical files (positions 8 through 16)
- Conversion between zoned decimal and character or hexadecimal in a DDS file
- Conversion of a field from floating point to packed decimal, zoned decimal, or binary in DDS
- Conversion of data types when concatenating fields in DDS
- Conversion of data types when substringing fields in DDS
- Conversion of one numeric data type to another in a DDS file
- Data type (position 35)
- DATFMT (Date Format) keyword for physical and logical files
- DATSEP (Date Separator) keyword for physical and logical files
- DDS access path keywords
- DDS logical files with more than one record format
- Decimal (positions 36 and 37)
- Decimal positions for physical and logical files (positions 36 and 37)
- Defining a physical file using DDS
- 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
- Example 1: Specifying the key field
- Example 2: Specifying the key field
- Example 3: Specifying the key field
- Example 4: Specifying the key field
- FCFO (First-Changed First-Out) keyword for physical and logical files
- Field name
- FIFO (First-In First-Out) keyword for physical and logical files
- FLTPCN (Floating-Point Precision) keyword for physical and logical files
- Form type for physical and logical files (position 6)
- 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
- Join logical files in DDS
- JREF (Join Reference) keyword—join logical files only
- Length (positions 30 through 34)
- Length for physical and logical files (positions 30 through 34)
- LIFO (Last-In First-Out) keyword for physical and logical files
- Location for physical and logical files (positions 39 through 44)
- NOALTSEQ (No Alternative Collating Sequence) keyword for physical and logical files
- PDF file for DDS for Physical and Logical files
- PFILE (Physical File) keyword—logical files only
- REFACCPTH (Reference Access Path Definition) keyword—logical files only
- Record format
- REF (Reference) keyword—physical files only
- Reference for physical and logical files (position 29)
- REFFLD (Referenced Field) keyword—physical files only
- REFSHIFT (Reference Shift) keyword for physical and logical files
- RENAME (Rename) keyword—logical files only
- Reserved for physical and logical files (position 18)
- Select/omit field name
- Sequence number for physical and logical files (positions 1 through 5)
- SIGNED (Signed) keyword for physical and logical files
- Simple- and multiple-format logical files in DDS
- Specifying COMP at the field level
- Specifying COMP at the select/omit-field level
- Specifying RANGE at the field level
- Specifying RANGE at the select/omit-field level
- Specifying record formats in a logical file in DDS
- Specifying VALUES at the field level
- Specifying VALUES at the select/omit-field level
- 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
- Type of name or specification for physical and logical files (position 17)
- Unicode considerations for database files: Data type (position 35)
- Unicode considerations for database files: Decimal positions (positions 36 and 37)
- Unicode considerations for database files: Keyword considerations (positions 45 through 80)
- Unicode considerations for database files: Length (positions 30 through 34)
- UNIQUE (Unique) keyword for physical and logical files
- UNSIGNED (Unsigned) keyword for physical and logical files
- Usage for physical and logical files (position 38)
- Using *NONE in the key field when creating a DDS file
- VARLEN (Variable-Length Field) keyword for physical and logical files
- ZONE (Zone) keyword for physical and logical files