Keyword considerations for database files that use DBCS

Do not specify DDS keywords intended for use with numeric data for fields containing DBCS data. The system treats DBCS data the same as character data, and, therefore, cannot perform arithmetic operations on it.

Do not use the following DDS keywords with DBCS data fields (the data type specified in position 35 is O, J, E, or G):

ABSVAL
ALTSEQ
CHECK(M10)
CHECK(M10F)
CHECK(M11)
CHECK(M11F)
CHECK(VN)

CHECK(VNE)
DATFMT
DATSEP
DIGIT
EDTCDE
EDTWRD
FLTPCN

REFSHIFT
SIGNED
SST
TIMFMT
TIMSEP
TRNTBL
ZONE

Notes:

The SST keyword is allowed on fields with a data type of G.
The REFSHIFT keyword is allowed on fields with a data type of O, J, or E.

CONCAT (Concatenate) keyword
Use this field-level keyword when you want to combine two or more fields from the physical file record format into one field in the logical file record format you are describing.

Parent topic: DBCS considerations for database files

Related reference

Keyword entries for physical and logical files (positions 45 through 80)