Neoview Repository User Guide (R2.4 SP1)

TDM_Default_DataSource watanabe.fargo. 9994
TDM_Default_DataSource rstein-xp 31
TDM_Default_DataSource saxonyw-dc76c 102
TDM_Default_DataSource tanakas.fargo.c 825
TDM_Default_DataSource darius-d530 22
smart_msaccess REVSTADTBR 98
Retrieving UCS2 Columns From a Workstation Configured for ISO8859-1
As indicated in Chapter 2 (page 19), if the Neoview platform is configured for the SJIS or Unicode
configuration, certain Repository views contain UCS2–encoded data. To retrieve such data (for
example, to SELECT by making a character comparison) from an ISO8859-1 workstation, you
must translate the character literals in your SQL statement to UCS2.
For example, if you issued the following statement from an ISO8859-1 workstation to retrieve
rows in which a specified column had the value 'abc'
Select * from <ucs2-view> where <column-name> = 'abc';
the query would fail with the following errors:
***ERROR[4041] Type CHAR(16) CHARACTER SET UCS2 cannot be compared with type CHAR(3) CHARACTER SET ISO88591.
***ERROR[8822] The statement was not prepared.
To perform the comparison and select the data successfully, you could use the _UCS2 character
set introducer, as in the following example:
Select * from <ucs2-view> where <column-name> = _UCS2'abc';
The _UCS2 introducer also works with hexadecimal character strings, as in the following example:
Select * from <ucs2-view> where <column-name> = _UCS2 X'0041 004E 0053 0049 0020 0054 0041 0042 004C 0045 005F
0030';
The TRANSLATE function is another option for specifying a UCS2 literal. For example, the
following query uses the TRANSLATE function to translate an ISO88591 character string to
UCS2:
Select * from <ucs2-view> where <column-name> = TRANSLATE('ISO_abc' USING ISO88592ToUCS2);
The next example translates a hexadecimal literal to UCS2:
Select * from <ucs2-view> where <column-name> = TRANSLATE(X'48 45 58 5F 61 62 63' USING ISO88592ToUCS2);
For a much more extensive discussion of character sets on the Neoview platform, see the Neoview
Character Sets Administrator's Guide.
86 Examples and Guidelines for Creating Repository Queries