DB2 graphic  QMF Version 8

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:

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 ends with 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.


Go to the previous page Go to the next page

Downloads | Library | Support | Support Policy | Terms of use | Feedback
Copyright IBM Corporation 1982,2004 Copyright IBM Corporation 1982, 2004
timestamp Last updated: March, 2004