Using QMF

Using DBCS data in queries

In queries, the following items can be represented in either double-byte characters or mixed single-byte and double-byte characters:

• Column, table, and query names

  Unless your database specifically supports double-byte characters in table names, column names cannot contain any double-byte characters that are internally represented with single-byte double quotation marks.

• Substitution names and values
• Quoted strings in character data type fields
• Comments
• QBE example elements. The first character must be a single-byte underscore character. Length limits are the same for SBCS or DBCS data, even though a double-byte character is two times the length of a single-byte character.

In queries, graphic strings that you want to enter or compare to graphic data type fields must be in double-byte characters only. A graphic string consists of either a G or N literal, a single quotation mark, followed by the double-byte character string, and ended by a single quotation mark.

If you are writing a prompted query with a LIKE operator and enter a left-side value with an N literal, when you issue a CONVERT TO SQL command, the query shows a G instead of the N that you entered.