DDS for physical and logical files
Consider the following when describing a database file that contains DBCS
fields:
- If you describe DBCS fields in the DDS, the system treats the file as a
DBCS file. You do not have to specify IGCDTA(*YES) on the file creation
command to identify the file as DBCS.
- The data type of a field in a physical file may be changed as follows when
you refer to that field in a logical file:
Physical File Data Type
| Logical File Data Type
|
J
| J, O, E, H, G
|
O
| O, H
|
E
| O, E, H
|
A
| A, O, E, H
|
H
| J, O, E, A, H
|
G
| G, O, J, E
|
- Note:
- When the physical file data type is character (A) or hexadecimal (H), and the
logical file data type is DBCS-only (J) or DBCS-either (E), the physical file
field length (columns 30 through 34) must be an even number greater than or
equal to 4.
- DDS treats DBCS key fields as character fields (the data type specified in
position 35 is O).
- DDS uses the EBCDIC collating sequence to sort DBCS data.
- Any key field sequencing keywords that can be used with character fields
can be used with DBCS fields, except the following keywords:
ALTSEQ
DIGIT
ZONE
- Use bracketed-DBCS data anywhere that comments and character strings are
allowed. See the DBCS character strings topic in
the DDS Reference: Concepts for instructions.
- Any bracketed-DBCS field except a field with data type J can be compared
with a character field (data type A).
- A DBCS-graphic field can be compared only with another graphic
field.
- The following validity checking keywords may be specified on DBCS
fields:
COMP
RANGE
VALUES
- When specifying the VARLEN keyword in a physical file, the minimum allowed
length for the allocated length is 4 for a bracketed-DBCS field. The
minimum allowed length for the allocated length is 1 for a DBCS-graphic
field.
[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]
(C) Copyright IBM Corporation 1992, 2005. All Rights Reserved.