SQL/MX Connectivity Service Manual for SQL/MX Release 3.1 (H06.23+, J06.12+)

Starting, Configuring, and Managing MXCS
HP NonStop SQL/MX Connectivity Service Manual for SQL/MX Release 3.1—663856-001
3-18
Param Caching
F: Data value for the second parameter value
The list of available data tags are:
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