Using DBCS fields in the Open Query File (OPNQRYF) command

 

Double-byte character set (DBCS) fields can be used for the wildcard, concatenation, and sort sequence functions of the Open Query File (OPNQRYF) command.

• Using the wildcard function with DBCS fields
  The wildcard (%WLDCRD) function with a double-byte character set (DBCS) field differs depending on whether the function is used with a bracketed-DBCS field or a DBCS-graphic field.

• Comparing DBCS fields through the Open Query File (OPNQRYF) command
  When you compare two fields or constants, fixed-length fields can be compared to variable-length fields if the types are compatible. The table shows the valid comparisons for double-byte character set (DBCS) fields through the Open Query File (OPNQRYF) command.

• Using concatenation with DBCS fields
  When double-byte character set (DBCS) fields are included in a concatenation through the Open Query File (OPNQRYF) command, the resulting data type is the same as the data type of the concatenated field in a logical file, with some slight variations.

• Using sort sequence with DBCS fields
  When a sort sequence is specified on the Open Query File (OPNQRYF) command, the double-byte character set (DBCS) data is not translated.

 

Parent topic:

Double-byte character set considerations