Retrieving ucs2 columns – HP Neoview Release 2.3 Software User Manual
Page 69
This next query assumes that you know the specific QUERY_ID of interest:
SELECT [first 10]
left(query_id,95) as query_id1,
query_start_date,
query_start_time,
sequence_num as seq_num,
sequence_size as seq_size,
statement_state,
query_text_is_multirow as multi_row,
left(sql_text,50) as sql_text1
FROM NEO.HP_METRICS.ODBC_QUERY_STATS_V2
WHERE QUERY_ID = 'MXID01001000969212041869954468496000000000214SUPER.SERVICES00_638_SQL_CUR_3053'
ORDER BY QUERY_START_DATE DESC, QUERY_END_DATE DESC, SEQUENCE_NUM ASC;
Retrieving UCS2 Columns
As indicated in
, if the Neoview platform is configured for Japan Shift-JIS or
Unicode, certain Repository views contain UCS2–encoded dated. To retrieve such data—for
example, to SELECT by making a character comparison—from an ISO88591 workstation, you
must translate the character literals in your SQL statement to UCS2.
For example, if you issued the following statement from an ISO88591 workstation to retrieve
rows in which a specified column had the value 'abc'
Select * from
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
The _UCS2 introducer also works with hexadecimal character strings, as in the following example:
Select * from
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
The next example translates a hexadecimal literal to UCS2:
Select * from
For a much more extensive discussion of character sets on the Neoview platform, see the Neoview
Character Sets Administrator's Guide.
Retrieving UCS2 Columns
69