MX Release 3.2 (H06.25+, J06.14+)

ManualsBrandsHP ManualsServerHP Integrity NonStop J-Series

A: Printable ISO88591

B: Base64 encoded ISO88591

C: Base64 encoded UCS2

D: Date

I: Interval

N: Numeric

K: Base64 encoded Kanji

S: Base64 encoded KSC560

a: Truncated printable ISO88591

b: Truncated Base64 encoded ISO88591

c: Truncated Base64 encoded UCS2

k: Truncated Base64 encoded Kanji

s: Truncated Base64 encoded KSC5601

Sample EMS Log for Select Query

The following is a sample EMS log for SQL SELECT Query:

select * from ALLDataType where c1=?,c2=?,c3=?,c4=?,c5=?,c6=?

,c7=?,c8=?,and c9=?

All "?" values are in the order of C1 through C9.

'abcdefghi’,_ucs2'aß0123456’,a123456',_ucs2'678aß’,interval '01

12:23:34.987654'day to second,date '1988-07-25’,2333

,123456789,987654.12345

Table DDL

You can create a table of 9 columns, with each column representing different data or charset as

follows:

create table ALLDataType(C1 char(10),C2 char(10) character set

ucs2,C3 varchar(10),C4 varchar(50) character set ucs2,C5

interval day to second,C6 date,C7 int,C8 bigint ,C9

numeric(11,5))

11-06-26 05:43:51 \ODBC.$Y2N9 TANDEM.ODBCMX.G06 021035 MXCS

Statistics:

Session ID: \ODBC:9:$Y2N9:201162654347

Message Attribute:

STATEMENT:QueryParamValues

Sequence Number: 0/0

Message Info:

StatementId:SQL_CUR_MFC00000001

QueryId:MXID01223001061212175852220031727

000000000111SUPER.SUPER00_20_SQL_CUR_MFC00

000001 StatementType:SQL_SELECT_NON_UNIQUE

SQLValues:{ZACOAAKabcdefghi

CAcAGEA3wAwADEAMgAzADQANQA2ACA=AAHa123456

CAQADYANwA4AGEA3w==IAT01 12:23:34.987654

DAK1988-07-25NAE2333NAJ123456789NAM987654s,

. 12345}

Limitations of SQLValues

SQLValues have the following limitations:

• Logs parameter value only for select query type.

• Truncates the parameter value on exceeding 800 bytes.

Resource Statistics 39