Hp Neoview Release 2.5 Software Manual de usuario descargar pdf (Pagina 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

TDM_Default_DataSource

JHANSEN13

127

TDM_Default_DataSource

SCOX1

687

TDM_Default_DataSource

THE0101

TDM_Default_DataSource

THE0102

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 <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';

64 Examples and Guidelines for Creating Repository Queries

1 2 ... 59 60 61 62 63 64 65 66 67 68 69 ... 141 142

Comentarios a estos manuales

Sin comentarios

Hp Neoview Release 2.5 Software Manual de usuario Pagina 64

Comentarios a estos manuales

Relacionado con productos y manuales para Software Hp Neoview Release 2.5 Software