DDS Keyword Considerations

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.

For additional information on the keywords for database files, refer to the keyword descriptions in Keywords for Physical and Logical Files to Create DDS Files.

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:

  1. The SST keyword is allowed on fields with a data type of G.

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

The CONCAT keyword can be used as described below.

DDS CONCAT (Concatenate)

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. The name of this concatenated field must appear in positions 19 through 28. Specify the physical file field names in the order in which you want them to be concatenated, and separate them by blanks.

The following rules and restrictions apply:

Figure 449. Specifying the CONCAT Keyword for Database Files

|...+....1....+....2....+....3....+....4....+....5....+....6....+....7....+....8
A          R RECORD 1                  PFILE(PF1)
A            FLD1               I      CONCAT(PFLD1 PFLD2)
A            FLD2               I      CONCAT(PFLD1 PFLD2 PFLD3)
A            FLD3               I      CONCAT(PFLD4 PFLD5)
A

In Figure 449, if the fields from PF1 are:

Then the resulting fields are: