DB2 Keywords
1. Keyword entries for physical and
logical files (positions 45 through 80)
Keyword entries are
typed in positions 45 through 80 (functions).
Most of the keywords are
valid for both physical and logical files. Some, however, are valid only for
physical files, and some are valid only for logical files. When this is the
case, the restriction is noted both in the keyword title and the text.
2. Specific restrictions
The following keywords
are valid only for simple and multiple format logical files:
·
PFILE
·
REFACCPTH
The following keywords
are valid only for join logical files:
·
JDFTVAL
·
JDUPSEQ
·
JFILE
·
JFLD
·
JOIN
·
JREF
When you use DDS to
describe a source file (typically created without DDS, using the CRTSRCPF
command) or when a logical file is based on a physical file to be used as a
source file, you cannot use the following keywords:
ABSVAL
ALTSEQ DESCEND FCFO FIFO LIFO |
NOALTSEQ
SIGNED UNIQUE VARLEN ZONE |
ABSVAL (Absolute Value) keyword for physical and logical
files
You can use this key-field level keyword to direct the operating system to ignore the sign of the field when the system sequences the values associated with this numeric field.
You can use this key-field level keyword to direct the operating system to ignore the sign of the field when the system sequences the values associated with this numeric field.
ALIAS (Alternative Name) keyword for physical and logical
files
You can use this field-level keyword to specify an alternative name for a field. When the program is compiled, the alternative name is brought into the program instead of the DDS field name.
You can use this field-level keyword to specify an alternative name for a field. When the program is compiled, the alternative name is brought into the program instead of the DDS field name.
ALL (All) keyword—logical files only
You can use this select/omit field-level keyword to specify the action to be taken after all other select/omit specifications have been processed for this logical file.
You can use this select/omit field-level keyword to specify the action to be taken after all other select/omit specifications have been processed for this logical file.
ALTSEQ (Alternative Collating Sequence) keyword for physical
and logical files
You can use this file-level keyword to direct the operating system to use an alternative collating sequence table when the system sequences the records of a file member for retrieval, if you specified a key for this file.
You can use this file-level keyword to direct the operating system to use an alternative collating sequence table when the system sequences the records of a file member for retrieval, if you specified a key for this file.
ALWNULL (Allow Null Value) keyword—physical files only
You can use this field-level keyword to define this field to allow the null value.
You can use this field-level keyword to define this field to allow the null value.
CCSID (Coded Character Set Identifier) keyword for physical
and logical files
You can use this keyword to specify a coded character set identifier (CCSID) for character fields. The CCSID keyword is a file- or field-level keyword on physical files, and a field-level keyword on logical files.
You can use this keyword to specify a coded character set identifier (CCSID) for character fields. The CCSID keyword is a file- or field-level keyword on physical files, and a field-level keyword on logical files.
CHECK (Check) keyword for physical and logical files
You can use this field-level keyword to specify validity checking in display files.
You can use this field-level keyword to specify validity checking in display files.
CHKMSGID (Check Message Identifier) keyword for physical and
logical files
You can use this field-level keyword to identify an error message that is associated with validity checking keywords.
You can use this field-level keyword to identify an error message that is associated with validity checking keywords.
CMP (Comparison) keyword for physical and logical files
This keyword is equivalent to the COMP keyword.
This keyword is equivalent to the COMP keyword.
COLHDG (Column Heading) keyword for physical and logical
files
You can use this field-level keyword to specify column headings used as a label for this field by text management, the query utility, the data file utility (DFU), and the screen design aid (SDA).
You can use this field-level keyword to specify column headings used as a label for this field by text management, the query utility, the data file utility (DFU), and the screen design aid (SDA).
COMP (Comparison) keyword for physical and logical files
You can use this field-level keyword to specify validity checking for the field you are defining when the field is referred to later during display file creation. The COMP keyword is equivalent to the CMP keyword.
You can use this field-level keyword to specify validity checking for the field you are defining when the field is referred to later during display file creation. The COMP keyword is equivalent to the CMP keyword.
CONCAT (Concatenate) keyword—logical files only
You can use this field-level keyword to combine two or more fields from the physical-file record format into one field in the logical-file record format you are defining. The name of this concatenated field must appear in positions 19 through 28.
You can use this field-level keyword to combine two or more fields from the physical-file record format into one field in the logical-file record format you are defining. The name of this concatenated field must appear in positions 19 through 28.
DATFMT (Date Format) keyword for physical and logical files
You can use this field-level keyword to specify the format of a date field. This keyword is valid only for date fields (data type L) or for logical-file zoned fields (data type S), packed fields (data type P), or character fields (data type A) whose corresponding physical file fields are date fields (data type L).
You can use this field-level keyword to specify the format of a date field. This keyword is valid only for date fields (data type L) or for logical-file zoned fields (data type S), packed fields (data type P), or character fields (data type A) whose corresponding physical file fields are date fields (data type L).
DATSEP (Date Separator) keyword for physical and logical
files
You can use this field-level keyword to specify the separator character for a date field. This keyword is valid only for date fields (data type L).
You can use this field-level keyword to specify the separator character for a date field. This keyword is valid only for date fields (data type L).
DESCEND (Descend) keyword for physical and logical files
You can use this key field-level keyword to specify that the values of this character, hexadecimal, or numeric key field are retrieved in descending sequence.
You can use this key field-level keyword to specify that the values of this character, hexadecimal, or numeric key field are retrieved in descending sequence.
DFT (Default) keyword—physical files only
You can use this field-level keyword to specify a default value for a field.
You can use this field-level keyword to specify a default value for a field.
DIGIT (Digit) keyword for physical and logical files
If this key field-level keyword is in effect, only the digit portion (farthest right 4 bits) of each byte of the key field is used when the system constructs a value associated with this key field. The zone portion is zero-filled.
If this key field-level keyword is in effect, only the digit portion (farthest right 4 bits) of each byte of the key field is used when the system constructs a value associated with this key field. The zone portion is zero-filled.
DYNSLT (Dynamic Select) keyword—logical files only
You can use this file-level keyword to indicate that the selection and omission tests specified in the file (using select/omit specifications) are done at processing time.
You can use this file-level keyword to indicate that the selection and omission tests specified in the file (using select/omit specifications) are done at processing time.
EDTCDE (Edit Code) and EDTWRD (Edit Word) keywords for
physical and logical files
You can use these field-level keywords to specify editing for the field you are defining when the field is referenced later during display or printer file creation. The EDTCDE and EDTWRD keywords do not affect the physical or logical file.
You can use these field-level keywords to specify editing for the field you are defining when the field is referenced later during display or printer file creation. The EDTCDE and EDTWRD keywords do not affect the physical or logical file.
FCFO (First-Changed First-Out) keyword for physical and
logical files
You can use this file-level keyword to specify that if records with duplicate key values are retrieved from the same physical or logical file member, the record with the key value that was changed first is the first record retrieved. This is in a first-changed first-out (FCFO) order.
You can use this file-level keyword to specify that if records with duplicate key values are retrieved from the same physical or logical file member, the record with the key value that was changed first is the first record retrieved. This is in a first-changed first-out (FCFO) order.
FIFO (First-In First-Out) keyword for physical and logical
files
You can use this file-level keyword to specify that if records with duplicate key values are retrieved from the same physical or logical file member, they are to be retrieved in a first-in first-out (FIFO) order.
You can use this file-level keyword to specify that if records with duplicate key values are retrieved from the same physical or logical file member, they are to be retrieved in a first-in first-out (FIFO) order.
FLTPCN (Floating-Point Precision) keyword for physical and
logical files
You can use this field-level keyword to specify the precision of a floating-point field.
You can use this field-level keyword to specify the precision of a floating-point field.
FORMAT (Format) keyword for physical and logical files
You can use this record-level keyword to specify that this record format is to share the field specifications for a previously defined record format. The name of the record format you are defining must be the name of the previously defined record format.
You can use this record-level keyword to specify that this record format is to share the field specifications for a previously defined record format. The name of the record format you are defining must be the name of the previously defined record format.
JDFTVAL (Join Default Values) keyword—join logical files
only
The JDFTVAL keyword is valid only for join logical files. If this keyword is in effect, the system provides default values for fields when a join to a secondary file does not produce any records.
The JDFTVAL keyword is valid only for join logical files. If this keyword is in effect, the system provides default values for fields when a join to a secondary file does not produce any records.
JDUPSEQ (Join Duplicate Sequence) keyword—join logical files
only
You can use this join-level keyword to specify the order in which records with duplicate join fields are presented when your program reads a join logical file.
You can use this join-level keyword to specify the order in which records with duplicate join fields are presented when your program reads a join logical file.
JFILE (Joined Files) keyword—join logical files only
You can use this record-level keyword to identify the physical files that contain the data to be accessed through the join logical file you are defining.
You can use this record-level keyword to identify the physical files that contain the data to be accessed through the join logical file you are defining.
JFLD (Joined Fields) keyword—join logical files only
You can use this join-level keyword to identify the from and to fields whose values are used to join physical files in a join logical file. These fields are both referred to as join fields.
You can use this join-level keyword to identify the from and to fields whose values are used to join physical files in a join logical file. These fields are both referred to as join fields.
JOIN (Join) keyword—join logical files only
You can use this join-level keyword to identify which pair of files are joined by the join specification in which you specify this keyword.
You can use this join-level keyword to identify which pair of files are joined by the join specification in which you specify this keyword.
JREF (Join Reference) keyword—join logical files only
You can use this field-level keyword in join logical files for fields whose names are specified in more than one physical file. This keyword identifies which physical file contains the field.
You can use this field-level keyword in join logical files for fields whose names are specified in more than one physical file. This keyword identifies which physical file contains the field.
LIFO (Last-In First-Out) keyword for physical and logical
files
You can use this file-level keyword to specify that records with duplicate key values from the same physical file member are retrieved in a last-in first-out (LIFO) order.
You can use this file-level keyword to specify that records with duplicate key values from the same physical file member are retrieved in a last-in first-out (LIFO) order.
NOALTSEQ (No Alternative Collating Sequence) keyword for
physical and logical files
You can use this key field-level keyword to specify that the ALTSEQ keyword specified at the file level does not apply to this key field.
You can use this key field-level keyword to specify that the ALTSEQ keyword specified at the file level does not apply to this key field.
PFILE (Physical File) keyword—logical files only
You can use this record-level keyword to identify the physical files that contain the data to be accessed through the record format that you are defining.
You can use this record-level keyword to identify the physical files that contain the data to be accessed through the record format that you are defining.
RANGE (Range) keyword for physical and logical files
You can specify this keyword at the field level, the select- or omit-field level, or both.
You can specify this keyword at the field level, the select- or omit-field level, or both.
REF (Reference) keyword—physical files only
You can use this file-level keyword to specify the name of the file from which field descriptions are retrieved.
You can use this file-level keyword to specify the name of the file from which field descriptions are retrieved.
REFACCPTH (Reference Access Path Definition) keyword—logical
files only
You can use this file-level keyword to specify that the access path information for this logical file is to be copied from another physical or logical file.
You can use this file-level keyword to specify that the access path information for this logical file is to be copied from another physical or logical file.
REFFLD (Referenced Field) keyword—physical files only
You can use this field-level keyword to refer to a field under any of these conditions.
You can use this field-level keyword to refer to a field under any of these conditions.
REFSHIFT (Reference Shift) keyword for physical and logical
files
You can use this field-level keyword to specify a keyboard shift for a field when the field is referred to in a display file or data file utility (DFU) operation.
You can use this field-level keyword to specify a keyboard shift for a field when the field is referred to in a display file or data file utility (DFU) operation.
RENAME (Rename) keyword—logical files only
You can use this field-level keyword to specify that a field name in the logical record format that you are defining is different from its corresponding physical-file field name.
You can use this field-level keyword to specify that a field name in the logical record format that you are defining is different from its corresponding physical-file field name.
SIGNED (Signed) keyword for physical and logical files
If this key field-level keyword is in effect, when sequencing the values associated with this numeric key field, the operating system considers the signs of the values
(negative versus positive values).
If this key field-level keyword is in effect, when sequencing the values associated with this numeric key field, the operating system considers the signs of the values
(negative versus positive values).
SST (Substring) keyword—logical files only
You can use this field-level keyword to specify a character string that is a subset of an existing character, hexadecimal, zoned field, or graphic.
You can use this field-level keyword to specify a character string that is a subset of an existing character, hexadecimal, zoned field, or graphic.
TEXT (Text) keyword for physical and logical files
You can use this record- or field-level keyword to supply a text description (or comment) for the record format or field used for program documentation.
You can use this record- or field-level keyword to supply a text description (or comment) for the record format or field used for program documentation.
TIMFMT (Time Format) keyword for physical and logical files
You can use this field-level keyword to specify the format of a time field.
You can use this field-level keyword to specify the format of a time field.
TIMSEP (Time Separator) keyword for physical and logical
files
You can use this field-level keyword to specify the separator character used for a time field. This keyword is valid only for time fields (data type T).
You can use this field-level keyword to specify the separator character used for a time field. This keyword is valid only for time fields (data type T).
TRNTBL (Translation Table) keyword—logical files only
You can use this field-level keyword to specify the name of a translation table to be used when the system passes this field between the physical file on the PFILE or JFILE keyword and your program.
You can use this field-level keyword to specify the name of a translation table to be used when the system passes this field between the physical file on the PFILE or JFILE keyword and your program.
UNIQUE (Unique) keyword for physical and logical files
You can use this file-level keyword to specify that records with duplicate key values are not allowed within a member of this physical or logical file.
You can use this file-level keyword to specify that records with duplicate key values are not allowed within a member of this physical or logical file.
UNSIGNED (Unsigned) keyword for physical and logical files
You can use this key field-level keyword to specify that numeric fields are sequenced as a string of unsigned binary data. The default values of character, date, time, timestamp, and hexadecimal fields are set to unsigned values.
You can use this key field-level keyword to specify that numeric fields are sequenced as a string of unsigned binary data. The default values of character, date, time, timestamp, and hexadecimal fields are set to unsigned values.
VALUES (Values) keyword for physical and logical files
You can specify this keyword at the field level, the select/omit-field level, or both.
You can specify this keyword at the field level, the select/omit-field level, or both.
VARLEN (Variable-Length Field) keyword for physical and
logical files
You can use this field-level keyword to define this field as a variable-length field.
You can use this field-level keyword to define this field as a variable-length field.
ZONE (Zone) keyword for physical and logical files
You can use this key field-level keyword to specify that only the zone portion (farthest left 4 bits) of each byte of the key field is used when the operating system is constructing a value associated with this key field. The digit portion is filled with zeros.
You can use this key field-level keyword to specify that only the zone portion (farthest left 4 bits) of each byte of the key field is used when the operating system is constructing a value associated with this key field. The digit portion is filled with zeros.
No comments