HP Neoview Release 2.5 Software User Manual

Page 64

count(*) as query_count
from NEO.HP_METRICS.QUERY_STATS_VW2
where query_status = 'COMPLETED'
group by datasource, client_name
order by datasource, client_name;

DATASOURCE
CLIENT_NAME

QUERY_COUNT
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
--------------------
TDM_Default_DataSource
FMASTROPOL
3
TDM_Default_DataSource
JHANSEN13
127
TDM_Default_DataSource
SCOX1
687
TDM_Default_DataSource
THE0101
79
TDM_Default_DataSource
THE0102
2
TDM_Default_DataSource
THE0103

Minor formatting of the columns can yield a more readable result:

select [first 10]
left (datasource, 25) as datasource1,
client_name,
count(*) as query_count
from NEO.HP_METRICS.QUERY_STATS_VW2
where query_status = 'COMPLETED'
group by 1, client_name
order by 1, client_name;

DATASOURCE1 CLIENT_NAME QUERY_COUNT
------------------------- ------------ ------------
TDM_Default_DataSource FMASTROPOL 3
TDM_Default_DataSource JHANSEN13 127
TDM_Default_DataSource SCOX1 688
TDM_Default_DataSource THE0101 79
TDM_Default_DataSource THE0102 2
TDM_Default_DataSource THE0103 2

Retrieving UCS2 Columns From a Workstation Configured for ISO8859-1

As indicated in

Chapter 2: “Getting Started with Repository” (page 17)

, 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 where = '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 where = _UCS2'abc';

The _UCS2 introducer also works with hexadecimal character strings, as in the following example:

Select * from where = _UCS2 X'0041 004E 0053 0049 0020 0054 0041 0042 004C 0045 005F
0030';

Examples and Guidelines for Creating Repository Queries