skip to main |
skip to sidebar
DB2/400 Keywords
- 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.
- 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.
- 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.
- 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.
- ALWNULL (Allow Null Value) keyword—physical files only
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.
- CHECK (Check) keyword for physical and logical 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.
- CMP (Comparison) keyword for physical and logical files
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).
- 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.
- 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.
- 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).
- 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).
- 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.
- DFT (Default) keyword—physical files only
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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- REFFLD (Referenced Field) keyword—physical files only
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.
- 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.
- 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).
- 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.
- 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.
- TIMFMT (Time Format) keyword for physical and logical
files
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).
- 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.
- 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.
- 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.
- VALUES (Values) keyword for physical and logical files
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.
- 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.
Source from IBM portal
No comments