Forums | Admin

Discussion Forums: help

Start New Thread Start New Thread

 

By: Praveen Devarao
RE: Invalid conversion error for UTF-8 data [ reply ]  
2013-04-14 06:49
Forgot to mention self.ibm_db_connection is a method in the ibm_db Rails adapter.

Thanks

Praveen

By: Praveen Devarao
RE: Invalid conversion error for UTF-8 data [ reply ]  
2013-04-14 06:47
Hi Samer,

Looks like the Literal Replacement Feature of CLI is causing the issue of invalid conversion.


With this feature ON CLI replaces literals with '?' and then internally preapre and bind the parameters for execution. When this is happening looks like this is doublw conversion happening resulting in invalidity.

We will need to turn off the feature with driver connection API call as below

While connecting to database can you turn off the feature as below

conn = IBM_DB.connect 'database','user','password',{}, IBM_DB::QUOTED_LITERAL_REPLACEMENT_OFF

In method self.ibm_db_connection can you turn OFF set_quoted_literal_replacement by setting the variable as below

set_quoted_literal_replacement = IBM_DB::QUOTED_LITERAL_REPLACEMENT_OFF

Could you try the above and let me know how it goes. If still the same issue is seen I will diagnose further.

P.S: What version of Rails, ibm_db adapter and DB2 are you using?

Thanks

Praveen

By: Samer Buna
Invalid conversion error for UTF-8 data [ reply ]  
2013-04-09 23:06
I am trying to insert data through Rails using connection.execute("INSERT INTO..."), I get:

Invalid conversion. SQLSTATE=07006 SQLCODE=-99999: INSERT INTO onsite.audit_details (id,audit_id,name,from_value,to_value) VALUES (2424479,553897,'specials','$500 off the first month''s rent with a 12 month lease on selected units! ',' ')

from_value and to_value are both CLOBs. The above happens just for that row, other rows work fine. Is this an encoding issue?

I created the db "USING CODESET UTF-8 TERRITORY US"

I am using ibm_db (v 2.5.11) and trying to write to db2 10.1 Express-C

Please advice.

--------------------------------------------------------------------
Here's the cli trace:

<db2trc_header>
Marker : @TRACE@
Trace version : 7.0
Platform : Linux/X
Build level : s121127
maxBufferSize : 33554432 bytes (32 MB)
auxBufferSize : 0 bytes (0 MB)
allocationCount : 2
DB2TRCD pid : 1
Trace destination : <shared memory buffer>
numSuspended : 0
Trace starting time : 2013-04-09-15.54.28.993363-420
Buffer size : 33554432 bytes (32 MB)
Allow buffer to wrap : yes
Mask : *.3.191.*.*
Timestamps : disabled
PID.TID mask : all
Fixed data mask #1 : all
Fixed data mask #2 : all
Max system errors : infinite
Treat this rc as sys err: none
Member mask : none
Application handle mask : none
Application ID mask : none

</db2trc_header>

SQLAllocHandle( fHandleType=SQL_HANDLE_ENV, hInput=0:0, phOutput=&000000000434fc10 )
---> Time elapsed - 0 seconds

SQLAllocHandle( phOutput=0:1 )
<--- SQL_SUCCESS Time elapsed - +2.600000E-005 seconds

SQLSetEnvAttr( hEnv=0:1, fAttribute=SQL_ATTR_ODBC_VERSION, vParam=3, cbParam=0 )
---> Time elapsed - +1.900000E-005 seconds

SQLSetEnvAttr( )
<--- SQL_SUCCESS Time elapsed - +4.500000E-005 seconds

SQLAllocHandle( fHandleType=SQL_HANDLE_DBC, hInput=0:1, phOutput=&000000000434fc14 )
---> Time elapsed - +3.000000E-006 seconds

SQLAllocHandle( phOutput=0:1 )
<--- SQL_SUCCESS Time elapsed - +5.000000E-006 seconds

SQLSetConnectAttrW( hDbc=0:1, fOption=SQL_ATTR_AUTOCOMMIT, pvParam=&0000000000000001, iStrLen=-3 )
---> Time elapsed - +5.000000E-006 seconds

SQLSetConnectAttrW( )
<--- SQL_SUCCESS Time elapsed - +7.000000E-006 seconds

SQLDriverConnectW( hDbc=0:1, hwnd=0:0, szConnStrIn="DRIVER={IBM DB2 ODBC DRIVER}; DATABASE=ra_main; HOSTNAME=localhost; PORT=50000; PROTOCOL=TCPIP; UID=db2inst1; P", cbConnStrIn=270, szConnStrOut=<NULL pointer>, cbConnStrOutMax=0, pcbConnStrOut=<NULL pointer>, fDriverCompletion=SQL_DRIVER_NOPROMPT )
---> Time elapsed - +6.000000E-006 seconds
( DBMS NAME="DB2/LINUXX8664", Version="10.01.0002", Fixpack="0x22030108" )
( Application Codepage=1208, Database Codepage=1208, Database XML Codepage=1208, Char Send/Recv Codepage=1208, Graphic Send/Recv Codepage=1200, XML Send/Recv Codepage=1208 )

SQLDriverConnectW( )
<--- SQL_SUCCESS Time elapsed - +7.800000E-005 seconds
( DRIVER="{IBM DB2 ODBC DRIVER}" )
( UID="db2inst1" )
( PWD="" )
( DATABASE="ra_main" )
( HOSTNAME="localhost" )
( PORT="50000" )
( PROTOCOL="TCPIP" )

SQLGetConnectAttrW( hDbc=0:1, fOption=SQL_ATTR_AUTOCOMMIT, pvParam=&000000000434fc18, cbParamMax=0, pcbParam=<NULL pointer> )
---> Time elapsed - +2.300000E-005 seconds

SQLGetConnectAttrW( pvParam=1 )
<--- SQL_SUCCESS Time elapsed - +6.000000E-006 seconds

SQLGetInfoW( hDbc=0:1, fInfoType=SQL_DBMS_NAME, rgbInfoValue=&0000000003ea1f30, cbInfoValueMax=4096, pcbInfoValue=&00007fffec1344c0 )
---> Time elapsed - +4.000000E-006 seconds

SQLGetInfoW( rgbInfoValue="DB2/LINUXX8664", pcbInfoValue=28 )
<--- Unknown rc 1085 Time elapsed - +2.300000E-005 seconds

SQLSetConnectAttrW( hDbc=0:1, fOption=SQL_ATTR_REPLACE_QUOTED_LITERALS, pvParam=&0000000000000001, iStrLen=-6 )
---> Time elapsed - +4.000000E-006 seconds

SQLSetConnectAttrW( )
<--- SQL_SUCCESS Time elapsed - +7.000000E-006 seconds

SQLGetInfoW( hDbc=0:1, fInfoType=SQL_DBMS_NAME, rgbInfoValue=&00007fffec1327e0, cbInfoValueMax=510, pcbInfoValue=&00007fffec132780 )
---> Time elapsed - +3.000000E-006 seconds

SQLGetInfoW( rgbInfoValue="DB2/LINUXX8664", pcbInfoValue=28 )
<--- Unknown rc 1091 Time elapsed - +8.000000E-006 seconds

SQLGetInfoW( hDbc=0:1, fInfoType=SQL_DBMS_VER, rgbInfoValue=&00007fffec1327c0, cbInfoValueMax=22, pcbInfoValue=&00007fffec132780 )
---> Time elapsed - +3.000000E-006 seconds

SQLGetInfoW( rgbInfoValue="10.01.0002", pcbInfoValue=20 )
<--- Unknown rc 1091 Time elapsed - +7.000000E-006 seconds

SQLGetInfoW( hDbc=0:1, fInfoType=SQL_DATABASE_CODEPAGE, rgbInfoValue=&00007fffec1327a0, cbInfoValueMax=4, pcbInfoValue=&00007fffec132780 )
---> Time elapsed - +4.000000E-006 seconds

SQLGetInfoW( rgbInfoValue=1208, pcbInfoValue=4 )
<--- Unknown rc 1091 Time elapsed - +8.000000E-006 seconds

SQLGetInfoW( hDbc=0:1, fInfoType=SQL_DATABASE_NAME, rgbInfoValue=&00007fffec1327e0, cbInfoValueMax=510, pcbInfoValue=&00007fffec132780 )
---> Time elapsed - +3.000000E-006 seconds

SQLGetInfoW( rgbInfoValue="RA_MAIN", pcbInfoValue=14 )
<--- Unknown rc 1091 Time elapsed - +7.000000E-006 seconds

SQLGetInfoW( hDbc=0:1, fInfoType=SQL_SERVER_NAME, rgbInfoValue=&00007fffec1327e0, cbInfoValueMax=510, pcbInfoValue=&00007fffec132780 )
---> Time elapsed - +4.000000E-006 seconds

SQLGetInfoW( rgbInfoValue="db2inst1", pcbInfoValue=16 )
<--- Unknown rc 1091 Time elapsed - +2.400000E-005 seconds

SQLGetInfoW( hDbc=0:1, fInfoType=SQL_SPECIAL_CHARACTERS, rgbInfoValue=&00007fffec1327e0, cbInfoValueMax=510, pcbInfoValue=&00007fffec132780 )
---> Time elapsed - +4.000000E-006 seconds

SQLGetInfoW( rgbInfoValue="@#", pcbInfoValue=4 )
<--- Unknown rc 1091 Time elapsed - +8.000000E-006 seconds

SQLGetInfoW( hDbc=0:1, fInfoType=SQL_KEYWORDS, rgbInfoValue=&00007fffec1329e0, cbInfoValueMax=6144, pcbInfoValue=&00007fffec132780 )
---> Time elapsed - +3.000000E-006 seconds

SQLGetInfoW( rgbInfoValue="AFTER,ALIAS,ALLOW,APPLICATION,ASSOCIATE,ASUTIME,AUDIT,AUX,AUXILIARY,BEFORE,BINARY,BUFFERPOOL,CACHE,CALL,CALLED,CAPTURE,CARDINAL", pcbInfoValue=2832 )
<--- Unknown rc 1091 Time elapsed - +9.000000E-006 seconds

SQLGetInfoW( hDbc=0:1, fInfoType=SQL_DEFAULT_TXN_ISOLATION, rgbInfoValue=&00007fffec1327b0, cbInfoValueMax=4, pcbInfoValue=&00007fffec132780 )
---> Time elapsed - +3.000000E-006 seconds

SQLGetInfoW( rgbInfoValue=2, pcbInfoValue=4 )
<--- Unknown rc 1091 Time elapsed - +6.000000E-006 seconds

SQLGetInfoW( hDbc=0:1, fInfoType=SQL_TXN_ISOLATION_OPTION, rgbInfoValue=&00007fffec1327b0, cbInfoValueMax=4, pcbInfoValue=&00007fffec132780 )
---> Time elapsed - +4.000000E-006 seconds

SQLGetInfoW( rgbInfoValue=15, pcbInfoValue=4 )
<--- Unknown rc 1091 Time elapsed - +6.000000E-006 seconds

SQLGetInfoW( hDbc=0:1, fInfoType=SQL_ODBC_SQL_CONFORMANCE, rgbInfoValue=&00007fffec1327a0, cbInfoValueMax=4, pcbInfoValue=&00007fffec132780 )
---> Time elapsed - +3.000000E-006 seconds

SQLGetInfoW( rgbInfoValue=2, pcbInfoValue=2 )
<--- Unknown rc 1091 Time elapsed - +6.000000E-006 seconds

SQLGetInfoW( hDbc=0:1, fInfoType=SQL_PROCEDURES, rgbInfoValue=&00007fffec1327c0, cbInfoValueMax=22, pcbInfoValue=&00007fffec132780 )
---> Time elapsed - +3.000000E-006 seconds

SQLGetInfoW( rgbInfoValue="Y", pcbInfoValue=2 )
<--- Unknown rc 1091 Time elapsed - +7.000000E-006 seconds

SQLGetInfoW( hDbc=0:1, fInfoType=SQL_IDENTIFIER_QUOTE_CHAR, rgbInfoValue=&00007fffec1327c0, cbInfoValueMax=22, pcbInfoValue=&00007fffec132780 )
---> Time elapsed - +4.000000E-006 seconds

SQLGetInfoW( rgbInfoValue=""", pcbInfoValue=2 )
<--- Unknown rc 1091 Time elapsed - +7.000000E-006 seconds

SQLGetInfoW( hDbc=0:1, fInfoType=SQL_LIKE_ESCAPE_CLAUSE, rgbInfoValue=&00007fffec1327c0, cbInfoValueMax=22, pcbInfoValue=&00007fffec132780 )
---> Time elapsed - +3.000000E-006 seconds

SQLGetInfoW( rgbInfoValue="Y", pcbInfoValue=2 )
<--- Unknown rc 1091 Time elapsed - +7.000000E-006 seconds

SQLGetInfoW( hDbc=0:1, fInfoType=SQL_MAX_COLUMN_NAME_LEN, rgbInfoValue=&00007fffec132790, cbInfoValueMax=2, pcbInfoValue=&00007fffec132780 )
---> Time elapsed - +3.000000E-006 seconds

SQLGetInfoW( rgbInfoValue=71499904, pcbInfoValue=2 )
<--- Unknown rc 1091 Time elapsed - +7.000000E-006 seconds

SQLGetInfoW( hDbc=0:1, fInfoType=SQL_MAX_ROW_SIZE, rgbInfoValue=&00007fffec1327a0, cbInfoValueMax=4, pcbInfoValue=&00007fffec132780 )
---> Time elapsed - +3.000000E-006 seconds

SQLGetInfoW( rgbInfoValue=32677, pcbInfoValue=4 )
<--- Unknown rc 1091 Time elapsed - +6.000000E-006 seconds

SQLGetInfoW( hDbc=0:1, fInfoType=SQL_MAX_IDENTIFIER_LEN, rgbInfoValue=&00007fffec132790, cbInfoValueMax=2, pcbInfoValue=&00007fffec132780 )
---> Time elapsed - +3.000000E-006 seconds

SQLGetInfoW( rgbInfoValue=71499904, pcbInfoValue=2 )
<--- Unknown rc 1091 Time elapsed - +7.000000E-006 seconds

SQLGetInfoW( hDbc=0:1, fInfoType=SQL_MAX_INDEX_SIZE, rgbInfoValue=&00007fffec1327a0, cbInfoValueMax=4, pcbInfoValue=&00007fffec132780 )
---> Time elapsed - +3.000000E-006 seconds

SQLGetInfoW( rgbInfoValue=1024, pcbInfoValue=4 )
<--- Unknown rc 1091 Time elapsed - +6.000000E-006 seconds

SQLGetInfoW( hDbc=0:1, fInfoType=SQL_MAX_PROCEDURE_NAME_LEN, rgbInfoValue=&00007fffec132790, cbInfoValueMax=2, pcbInfoValue=&00007fffec132780 )
---> Time elapsed - +3.000000E-006 seconds

SQLGetInfoW( rgbInfoValue=71499904, pcbInfoValue=2 )
<--- Unknown rc 1091 Time elapsed - +1.100000E-005 seconds

SQLGetInfoW( hDbc=0:1, fInfoType=SQL_MAX_SCHEMA_NAME_LEN, rgbInfoValue=&00007fffec132790, cbInfoValueMax=2, pcbInfoValue=&00007fffec132780 )
---> Time elapsed - +4.000000E-006 seconds

SQLGetInfoW( rgbInfoValue=71499904, pcbInfoValue=2 )
<--- Unknown rc 1091 Time elapsed - +6.000000E-006 seconds

SQLGetInfoW( hDbc=0:1, fInfoType=SQL_MAX_STATEMENT_LEN, rgbInfoValue=&00007fffec1327a0, cbInfoValueMax=4, pcbInfoValue=&00007fffec132780 )
---> Time elapsed - +3.000000E-006 seconds

SQLGetInfoW( rgbInfoValue=2097152, pcbInfoValue=4 )
<--- Unknown rc 1091 Time elapsed - +7.000000E-006 seconds

SQLGetInfoW( hDbc=0:1, fInfoType=SQL_MAX_TABLE_NAME_LEN, rgbInfoValue=&00007fffec132790, cbInfoValueMax=2, pcbInfoValue=&00007fffec132780 )
---> Time elapsed - +3.000000E-006 seconds

SQLGetInfoW( rgbInfoValue=71499904, pcbInfoValue=2 )
<--- Unknown rc 1091 Time elapsed - +6.000000E-006 seconds

SQLGetInfoW( hDbc=0:1, fInfoType=SQL_NON_NULLABLE_COLUMNS, rgbInfoValue=&00007fffec132790, cbInfoValueMax=2, pcbInfoValue=&00007fffec132780 )
---> Time elapsed - +3.000000E-006 seconds

SQLGetInfoW( rgbInfoValue=71499777, pcbInfoValue=2 )
<--- Unknown rc 1091 Time elapsed - +7.000000E-006 seconds

SQLAllocHandle( fHandleType=SQL_HANDLE_STMT, hInput=0:1, phOutput=&0000000004547df4 )
---> Time elapsed - +3.000000E-006 seconds

SQLAllocHandle( phOutput=1:1 )
<--- SQL_SUCCESS Time elapsed - +5.000000E-006 seconds

SQLExecDirectW( hStmt=1:1, pszSqlStr="SET SCHEMA onsite", cbSqlStr=17 )
---> Time elapsed - +3.000000E-006 seconds
( StmtOut="SET SCHEMA onsite" )
( Package="SYSSH200 ", Section=65 )
( COMMIT REPLY RECEIVED=1 )

SQLExecDirectW( )
<--- SQL_SUCCESS Time elapsed - +2.000000E-005 seconds

SQLGetConnectAttrW( hDbc=0:1, fOption=SQL_ATTR_PING_DB, pvParam=&00007fffec134620, cbParamMax=0, pcbParam=<NULL pointer> )
---> Time elapsed - +3.000000E-006 seconds

SQLGetConnectAttrW( pvParam=219 )
<--- SQL_SUCCESS Time elapsed - +7.000000E-006 seconds

SQLFreeHandle( fHandleType=SQL_HANDLE_STMT, hHandle=1:1 )
---> Time elapsed - +3.000000E-006 seconds
( Caching Statement Structure=1 )

SQLGetConnectAttrW( hDbc=0:1, fOption=SQL_ATTR_PING_DB, pvParam=&00007fffec1341b0, cbParamMax=0, pcbParam=<NULL pointer> )
---> Time elapsed - +3.000000E-006 seconds

SQLGetConnectAttrW( pvParam=295 )
<--- SQL_SUCCESS Time elapsed - +1.300000E-005 seconds

SQLAllocHandle( fHandleType=SQL_HANDLE_ENV, hInput=0:0, phOutput=&0000000003c95230 )
---> Time elapsed - +4.000000E-006 seconds

SQLAllocHandle( phOutput=0:2 )
<--- SQL_SUCCESS Time elapsed - +5.000000E-006 seconds

SQLSetEnvAttr( hEnv=0:2, fAttribute=SQL_ATTR_ODBC_VERSION, vParam=3, cbParam=0 )
---> Time elapsed - +3.000000E-006 seconds

SQLSetEnvAttr( )
<--- SQL_SUCCESS Time elapsed - +5.000000E-006 seconds

SQLAllocHandle( fHandleType=SQL_HANDLE_DBC, hInput=0:2, phOutput=&0000000003c95234 )
---> Time elapsed - +3.000000E-006 seconds

SQLAllocHandle( phOutput=0:2 )
<--- SQL_SUCCESS Time elapsed - +5.000000E-006 seconds

SQLSetConnectAttrW( hDbc=0:2, fOption=SQL_ATTR_AUTOCOMMIT, pvParam=&0000000000000001, iStrLen=-3 )
---> Time elapsed - +3.000000E-006 seconds

SQLSetConnectAttrW( )
<--- SQL_SUCCESS Time elapsed - +5.000000E-006 seconds

SQLDriverConnectW( hDbc=0:2, hwnd=0:0, szConnStrIn="DRIVER={IBM DB2 ODBC DRIVER}; DATABASE=ra_audit; HOSTNAME=localhost; PORT=50000; PROTOCOL=TCPIP; UID=db2inst1; ", cbConnStrIn=271, szConnStrOut=<NULL pointer>, cbConnStrOutMax=0, pcbConnStrOut=<NULL pointer>, fDriverCompletion=SQL_DRIVER_NOPROMPT )
---> Time elapsed - +3.000000E-006 seconds
( DBMS NAME="DB2/LINUXX8664", Version="10.01.0002", Fixpack="0x22030108" )
( Application Codepage=1208, Database Codepage=1208, Database XML Codepage=1208, Char Send/Recv Codepage=1208, Graphic Send/Recv Codepage=1200, XML Send/Recv Codepage=1208 )

SQLDriverConnectW( )
<--- SQL_SUCCESS Time elapsed - +5.500000E-005 seconds
( DRIVER="{IBM DB2 ODBC DRIVER}" )
( UID="db2inst1" )
( PWD="" )
( DATABASE="ra_audit" )
( HOSTNAME="localhost" )
( PORT="50000" )
( PROTOCOL="TCPIP" )

SQLGetConnectAttrW( hDbc=0:2, fOption=SQL_ATTR_AUTOCOMMIT, pvParam=&0000000003c95238, cbParamMax=0, pcbParam=<NULL pointer> )
---> Time elapsed - +2.100000E-005 seconds

SQLGetConnectAttrW( pvParam=1 )
<--- SQL_SUCCESS Time elapsed - +6.000000E-006 seconds

SQLGetInfoW( hDbc=0:2, fInfoType=SQL_DBMS_NAME, rgbInfoValue=&00000000030324c0, cbInfoValueMax=4096, pcbInfoValue=&00007fffec135580 )
---> Time elapsed - +3.000000E-006 seconds

SQLGetInfoW( rgbInfoValue="DB2/LINUXX8664", pcbInfoValue=28 )
<--- Unknown rc 968 Time elapsed - +8.000000E-006 seconds

SQLSetConnectAttrW( hDbc=0:2, fOption=SQL_ATTR_REPLACE_QUOTED_LITERALS, pvParam=&0000000000000001, iStrLen=-6 )
---> Time elapsed - +4.000000E-006 seconds

SQLSetConnectAttrW( )
<--- SQL_SUCCESS Time elapsed - +5.000000E-006 seconds

SQLGetInfoW( hDbc=0:2, fInfoType=SQL_DBMS_NAME, rgbInfoValue=&00007fffec1338a0, cbInfoValueMax=510, pcbInfoValue=&00007fffec133840 )
---> Time elapsed - +3.000000E-006 seconds

SQLGetInfoW( rgbInfoValue="DB2/LINUXX8664", pcbInfoValue=28 )
<--- SQL_SUCCESS Time elapsed - +8.000000E-006 seconds

SQLGetInfoW( hDbc=0:2, fInfoType=SQL_DBMS_VER, rgbInfoValue=&00007fffec133880, cbInfoValueMax=22, pcbInfoValue=&00007fffec133840 )
---> Time elapsed - +3.000000E-006 seconds

SQLGetInfoW( rgbInfoValue="10.01.0002", pcbInfoValue=20 )
<--- SQL_SUCCESS Time elapsed - +7.000000E-006 seconds

SQLGetInfoW( hDbc=0:2, fInfoType=SQL_DATABASE_CODEPAGE, rgbInfoValue=&00007fffec133860, cbInfoValueMax=4, pcbInfoValue=&00007fffec133840 )
---> Time elapsed - +4.000000E-006 seconds

SQLGetInfoW( rgbInfoValue=1208, pcbInfoValue=4 )
<--- SQL_SUCCESS Time elapsed - +6.000000E-006 seconds

SQLGetInfoW( hDbc=0:2, fInfoType=SQL_DATABASE_NAME, rgbInfoValue=&00007fffec1338a0, cbInfoValueMax=510, pcbInfoValue=&00007fffec133840 )
---> Time elapsed - +3.000000E-006 seconds

SQLGetInfoW( rgbInfoValue="RA_AUDIT", pcbInfoValue=16 )
<--- SQL_SUCCESS Time elapsed - +1.600000E-005 seconds

SQLGetInfoW( hDbc=0:2, fInfoType=SQL_SERVER_NAME, rgbInfoValue=&00007fffec1338a0, cbInfoValueMax=510, pcbInfoValue=&00007fffec133840 )
---> Time elapsed - +4.000000E-006 seconds

SQLGetInfoW( rgbInfoValue="db2inst1", pcbInfoValue=16 )
<--- SQL_SUCCESS Time elapsed - +7.000000E-006 seconds

SQLGetInfoW( hDbc=0:2, fInfoType=SQL_SPECIAL_CHARACTERS, rgbInfoValue=&00007fffec1338a0, cbInfoValueMax=510, pcbInfoValue=&00007fffec133840 )
---> Time elapsed - +4.000000E-006 seconds

SQLGetInfoW( rgbInfoValue="@#", pcbInfoValue=4 )
<--- SQL_SUCCESS Time elapsed - +7.000000E-006 seconds

SQLGetInfoW( hDbc=0:2, fInfoType=SQL_KEYWORDS, rgbInfoValue=&00007fffec133aa0, cbInfoValueMax=6144, pcbInfoValue=&00007fffec133840 )
---> Time elapsed - +4.000000E-006 seconds

SQLGetInfoW( rgbInfoValue="AFTER,ALIAS,ALLOW,APPLICATION,ASSOCIATE,ASUTIME,AUDIT,AUX,AUXILIARY,BEFORE,BINARY,BUFFERPOOL,CACHE,CALL,CALLED,CAPTURE,CARDINAL", pcbInfoValue=2832 )
<--- SQL_SUCCESS Time elapsed - +8.000000E-006 seconds

SQLGetInfoW( hDbc=0:2, fInfoType=SQL_DEFAULT_TXN_ISOLATION, rgbInfoValue=&00007fffec133870, cbInfoValueMax=4, pcbInfoValue=&00007fffec133840 )
---> Time elapsed - +1.100000E-005 seconds

SQLGetInfoW( rgbInfoValue=2, pcbInfoValue=4 )
<--- SQL_SUCCESS Time elapsed - +7.000000E-006 seconds

SQLGetInfoW( hDbc=0:2, fInfoType=SQL_TXN_ISOLATION_OPTION, rgbInfoValue=&00007fffec133870, cbInfoValueMax=4, pcbInfoValue=&00007fffec133840 )
---> Time elapsed - +3.000000E-006 seconds

SQLGetInfoW( rgbInfoValue=15, pcbInfoValue=4 )
<--- SQL_SUCCESS Time elapsed - +7.000000E-006 seconds

SQLGetInfoW( hDbc=0:2, fInfoType=SQL_ODBC_SQL_CONFORMANCE, rgbInfoValue=&00007fffec133860, cbInfoValueMax=4, pcbInfoValue=&00007fffec133840 )
---> Time elapsed - +3.000000E-006 seconds

SQLGetInfoW( rgbInfoValue=2, pcbInfoValue=2 )
<--- SQL_SUCCESS Time elapsed - +1.100000E-005 seconds

SQLGetInfoW( hDbc=0:2, fInfoType=SQL_PROCEDURES, rgbInfoValue=&00007fffec133880, cbInfoValueMax=22, pcbInfoValue=&00007fffec133840 )
---> Time elapsed - +3.000000E-006 seconds

SQLGetInfoW( rgbInfoValue="Y", pcbInfoValue=2 )
<--- SQL_SUCCESS Time elapsed - +8.000000E-006 seconds

SQLGetInfoW( hDbc=0:2, fInfoType=SQL_IDENTIFIER_QUOTE_CHAR, rgbInfoValue=&00007fffec133880, cbInfoValueMax=22, pcbInfoValue=&00007fffec133840 )
---> Time elapsed - +3.000000E-006 seconds

SQLGetInfoW( rgbInfoValue=""", pcbInfoValue=2 )
<--- SQL_SUCCESS Time elapsed - +7.000000E-006 seconds

SQLGetInfoW( hDbc=0:2, fInfoType=SQL_LIKE_ESCAPE_CLAUSE, rgbInfoValue=&00007fffec133880, cbInfoValueMax=22, pcbInfoValue=&00007fffec133840 )
---> Time elapsed - +4.000000E-006 seconds

SQLGetInfoW( rgbInfoValue="Y", pcbInfoValue=2 )
<--- SQL_SUCCESS Time elapsed - +7.000000E-006 seconds

SQLGetInfoW( hDbc=0:2, fInfoType=SQL_MAX_COLUMN_NAME_LEN, rgbInfoValue=&00007fffec133850, cbInfoValueMax=2, pcbInfoValue=&00007fffec133840 )
---> Time elapsed - +3.000000E-006 seconds

SQLGetInfoW( rgbInfoValue=128, pcbInfoValue=2 )
<--- SQL_SUCCESS Time elapsed - +6.000000E-006 seconds

SQLGetInfoW( hDbc=0:2, fInfoType=SQL_MAX_ROW_SIZE, rgbInfoValue=&00007fffec133860, cbInfoValueMax=4, pcbInfoValue=&00007fffec133840 )
---> Time elapsed - +4.000000E-006 seconds

SQLGetInfoW( rgbInfoValue=32677, pcbInfoValue=4 )
<--- SQL_SUCCESS Time elapsed - +6.000000E-006 seconds

SQLGetInfoW( hDbc=0:2, fInfoType=SQL_MAX_IDENTIFIER_LEN, rgbInfoValue=&00007fffec133850, cbInfoValueMax=2, pcbInfoValue=&00007fffec133840 )
---> Time elapsed - +3.000000E-006 seconds

SQLGetInfoW( rgbInfoValue=128, pcbInfoValue=2 )
<--- SQL_SUCCESS Time elapsed - +6.000000E-006 seconds

SQLGetInfoW( hDbc=0:2, fInfoType=SQL_MAX_INDEX_SIZE, rgbInfoValue=&00007fffec133860, cbInfoValueMax=4, pcbInfoValue=&00007fffec133840 )
---> Time elapsed - +4.000000E-006 seconds

SQLGetInfoW( rgbInfoValue=1024, pcbInfoValue=4 )
<--- SQL_SUCCESS Time elapsed - +6.000000E-006 seconds

SQLGetInfoW( hDbc=0:2, fInfoType=SQL_MAX_PROCEDURE_NAME_LEN, rgbInfoValue=&00007fffec133850, cbInfoValueMax=2, pcbInfoValue=&00007fffec133840 )
---> Time elapsed - +3.000000E-006 seconds

SQLGetInfoW( rgbInfoValue=128, pcbInfoValue=2 )
<--- SQL_SUCCESS Time elapsed - +6.000000E-006 seconds

SQLGetInfoW( hDbc=0:2, fInfoType=SQL_MAX_SCHEMA_NAME_LEN, rgbInfoValue=&00007fffec133850, cbInfoValueMax=2, pcbInfoValue=&00007fffec133840 )
---> Time elapsed - +3.000000E-006 seconds

SQLGetInfoW( rgbInfoValue=128, pcbInfoValue=2 )
<--- SQL_SUCCESS Time elapsed - +6.000000E-006 seconds

SQLGetInfoW( hDbc=0:2, fInfoType=SQL_MAX_STATEMENT_LEN, rgbInfoValue=&00007fffec133860, cbInfoValueMax=4, pcbInfoValue=&00007fffec133840 )
---> Time elapsed - +3.000000E-006 seconds

SQLGetInfoW( rgbInfoValue=2097152, pcbInfoValue=4 )
<--- SQL_SUCCESS Time elapsed - +6.000000E-006 seconds

SQLGetInfoW( hDbc=0:2, fInfoType=SQL_MAX_TABLE_NAME_LEN, rgbInfoValue=&00007fffec133850, cbInfoValueMax=2, pcbInfoValue=&00007fffec133840 )
---> Time elapsed - +3.000000E-006 seconds

SQLGetInfoW( rgbInfoValue=128, pcbInfoValue=2 )
<--- SQL_SUCCESS Time elapsed - +7.000000E-006 seconds

SQLGetInfoW( hDbc=0:2, fInfoType=SQL_NON_NULLABLE_COLUMNS, rgbInfoValue=&00007fffec133850, cbInfoValueMax=2, pcbInfoValue=&00007fffec133840 )
---> Time elapsed - +3.000000E-006 seconds

SQLGetInfoW( rgbInfoValue=1, pcbInfoValue=2 )
<--- SQL_SUCCESS Time elapsed - +6.000000E-006 seconds

SQLAllocHandle( fHandleType=SQL_HANDLE_STMT, hInput=0:2, phOutput=&00000000048680b4 )
---> Time elapsed - +3.000000E-006 seconds

SQLAllocHandle( phOutput=2:1 )
<--- SQL_SUCCESS Time elapsed - +5.000000E-006 seconds

SQLExecDirectW( hStmt=2:1, pszSqlStr="SET SCHEMA onsite", cbSqlStr=17 )
---> Time elapsed - +3.000000E-006 seconds
( StmtOut="SET SCHEMA onsite" )
( Package="SYSSH200 ", Section=65 )
( COMMIT REPLY RECEIVED=1 )

SQLExecDirectW( )
<--- SQL_SUCCESS Time elapsed - +2.000000E-005 seconds

SQLGetConnectAttrW( hDbc=0:2, fOption=SQL_ATTR_PING_DB, pvParam=&00007fffec1356e0, cbParamMax=0, pcbParam=<NULL pointer> )
---> Time elapsed - +4.000000E-006 seconds

SQLGetConnectAttrW( pvParam=276 )
<--- SQL_SUCCESS Time elapsed - +6.000000E-006 seconds

SQLAllocHandle( fHandleType=SQL_HANDLE_STMT, hInput=0:2, phOutput=&00000000048595e4 )
---> Time elapsed - +3.000000E-006 seconds

SQLAllocHandle( phOutput=2:2 )
<--- SQL_SUCCESS Time elapsed - +5.000000E-006 seconds

SQLTablesW( hStmt=2:2, szTableQualifier=<NULL pointer>, cbTableQualifier=0, szTableOwner="ONSITE", cbTableOwner=6, szTableName=<NULL pointer>, cbTableName=0, szTableType=<NULL pointer>, cbTableType=0 )
---> Time elapsed - +4.000000E-006 seconds
( StmtOut="CALL SYSIBM.SQLTABLES(?,?,?,?,?)" )
( Package="SYSSH200 ", Section=4 )
( Row=1, iPar=1, fCType=SQL_C_CHAR, rgbValue=<NULL pointer>, pcbValue=-1, piIndicatorPtr=-1 )
( Row=1, iPar=2, fCType=SQL_C_CHAR, rgbValue="ONSITE" - x'4F4E53495445', pcbValue=6, piIndicatorPtr=6 )
( Row=1, iPar=3, fCType=SQL_C_CHAR, rgbValue=<NULL pointer>, pcbValue=-1, piIndicatorPtr=-1 )
( Row=1, iPar=4, fCType=SQL_C_CHAR, rgbValue=<NULL pointer>, pcbValue=-1, piIndicatorPtr=-1 )
( Row=1, iPar=5, fCType=SQL_C_CHAR, rgbValue="DATATYPE='ODBC';" - x'44415441545950453D274F444243273B', pcbValue=16, piIndicatorPtr=16 )
( return=0 )
( Requested Cursor Attributes=x'00000000' )
( Reply Cursor Attributes=x'0A000808' )
( Actual Cursor Attributes=x'0A000808' )

SQLTablesW( )
<--- SQL_SUCCESS Time elapsed - +7.830000E-004 seconds

SQLNumResultCols( hStmt=2:2, pcCol=&0000000004658178 )
---> Time elapsed - +8.000000E-006 seconds

SQLNumResultCols( pcCol=5 )
<--- SQL_SUCCESS Time elapsed - +2.500000E-005 seconds

SQLDescribeColW( hStmt=2:2, iCol=1, pszColName=&00007fffec131b00, sColNameMaxCharLength=8192, psColNameCharLength=&00000000046f203a, pfSQLType=&00000000042bf470, pcbColDef=&00000000042bf474, pibScale=&00000000042bf478, pfNullable=&00000000042bf47a )
---> Time elapsed - +1.700000E-005 seconds

SQLDescribeColW( pszColName="TABLE_CAT", psColNameCharLength=536870921, pfSQLType=SQL_VARCHAR, pcbColDef=128, pibScale=65536, pfNullable=SQL_NULLABLE )
<--- SQL_SUCCESS Time elapsed - +5.900000E-005 seconds

SQLDescribeColW( hStmt=2:2, iCol=2, pszColName=&00007fffec131b00, sColNameMaxCharLength=8192, psColNameCharLength=&00000000046f203a, pfSQLType=&00000000042bf498, pcbColDef=&00000000042bf49c, pibScale=&00000000042bf4a0, pfNullable=&00000000042bf4a2 )
---> Time elapsed - +1.500000E-005 seconds

SQLDescribeColW( pszColName="TABLE_SCHEM", psColNameCharLength=536870923, pfSQLType=SQL_VARCHAR, pcbColDef=128, pibScale=0, pfNullable=SQL_NO_NULLS )
<--- SQL_SUCCESS Time elapsed - +4.800000E-005 seconds

SQLDescribeColW( hStmt=2:2, iCol=3, pszColName=&00007fffec131b00, sColNameMaxCharLength=8192, psColNameCharLength=&00000000046f203a, pfSQLType=&00000000042bf4c0, pcbColDef=&00000000042bf4c4, pibScale=&00000000042bf4c8, pfNullable=&00000000042bf4ca )
---> Time elapsed - +1.400000E-005 seconds

SQLDescribeColW( pszColName="TABLE_NAME", psColNameCharLength=536870922, pfSQLType=SQL_VARCHAR, pcbColDef=128, pibScale=0, pfNullable=SQL_NO_NULLS )
<--- SQL_SUCCESS Time elapsed - +4.600000E-005 seconds

SQLDescribeColW( hStmt=2:2, iCol=4, pszColName=&00007fffec131b00, sColNameMaxCharLength=8192, psColNameCharLength=&00000000046f203a, pfSQLType=&00000000042bf4e8, pcbColDef=&00000000042bf4ec, pibScale=&00000000042bf4f0, pfNullable=&00000000042bf4f2 )
---> Time elapsed - +1.400000E-005 seconds

SQLDescribeColW( pszColName="TABLE_TYPE", psColNameCharLength=536870922, pfSQLType=SQL_VARCHAR, pcbColDef=128, pibScale=65536, pfNullable=SQL_NULLABLE )
<--- SQL_SUCCESS Time elapsed - +4.600000E-005 seconds

SQLDescribeColW( hStmt=2:2, iCol=5, pszColName=&00007fffec131b00, sColNameMaxCharLength=8192, psColNameCharLength=&00000000046f203a, pfSQLType=&00000000042bf510, pcbColDef=&00000000042bf514, pibScale=&00000000042bf518, pfNullable=&00000000042bf51a )
---> Time elapsed - +1.400000E-005 seconds

SQLDescribeColW( pszColName="REMARKS", psColNameCharLength=536870919, pfSQLType=SQL_VARCHAR, pcbColDef=254, pibScale=65536, pfNullable=SQL_NULLABLE )
<--- SQL_SUCCESS Time elapsed - +1.060000E-004 seconds

SQLBindCol( hStmt=2:2, iCol=1, fCType=SQL_C_WCHAR, rgbValue=&0000000004859a10, cbValueMax=258, pcbValue=&0000000003e0ebd0 )
---> Time elapsed - +1.900000E-005 seconds

SQLBindCol( )
<--- SQL_SUCCESS Time elapsed - +2.800000E-005 seconds

SQLBindCol( hStmt=2:2, iCol=2, fCType=SQL_C_WCHAR, rgbValue=&000000000485d4c0, cbValueMax=258, pcbValue=&0000000003e0ebe0 )
---> Time elapsed - +1.300000E-005 seconds

SQLBindCol( )
<--- SQL_SUCCESS Time elapsed - +2.500000E-005 seconds

SQLBindCol( hStmt=2:2, iCol=3, fCType=SQL_C_WCHAR, rgbValue=&0000000004305290, cbValueMax=258, pcbValue=&0000000003e0ebf0 )
---> Time elapsed - +1.300000E-005 seconds

SQLBindCol( )
<--- SQL_SUCCESS Time elapsed - +2.600000E-005 seconds

SQLBindCol( hStmt=2:2, iCol=4, fCType=SQL_C_WCHAR, rgbValue=&00000000046fdea0, cbValueMax=258, pcbValue=&0000000003e0ec00 )
---> Time elapsed - +2.200000E-005 seconds

SQLBindCol( )
<--- SQL_SUCCESS Time elapsed - +4.000000E-005 seconds

SQLBindCol( hStmt=2:2, iCol=5, fCType=SQL_C_WCHAR, rgbValue=&0000000004652210, cbValueMax=510, pcbValue=&0000000003e0ec10 )
---> Time elapsed - +2.600000E-005 seconds

SQLBindCol( )
<--- SQL_SUCCESS Time elapsed - +3.000000E-005 seconds

SQLFetch( hStmt=2:2 )
---> Time elapsed - +1.300000E-005 seconds
( iRow=1, iCol=1, fCType=SQL_C_WCHAR, rgbValue=<NULL data>, pcbValue=-1 )
( iRow=1, iCol=2, fCType=SQL_C_WCHAR, rgbValue="O" - x'4F0000000000000000000000', pcbValue=12 )
( iRow=1, iCol=3, fCType=SQL_C_WCHAR, rgbValue="A" - x'410000000000000000000000', pcbValue=12 )
( iRow=1, iCol=4, fCType=SQL_C_WCHAR, rgbValue="T" - x'54000000000000000000', pcbValue=10 )
( iRow=1, iCol=5, fCType=SQL_C_WCHAR, rgbValue=<NULL data>, pcbValue=-1 )

SQLFetch( )
<--- SQL_SUCCESS Time elapsed - +1.370000E-004 seconds

SQLFetch( hStmt=2:2 )
---> Time elapsed - +1.400000E-005 seconds
( iRow=1, iCol=1, fCType=SQL_C_WCHAR, rgbValue=<NULL data>, pcbValue=-1 )
( iRow=1, iCol=2, fCType=SQL_C_WCHAR, rgbValue="O" - x'4F0000000000000000000000', pcbValue=12 )
( iRow=1, iCol=3, fCType=SQL_C_WCHAR, rgbValue="A" - x'4100000000000000000000000000000000000000000000000000', pcbValue=26 )
( iRow=1, iCol=4, fCType=SQL_C_WCHAR, rgbValue="T" - x'54000000000000000000', pcbValue=10 )
( iRow=1, iCol=5, fCType=SQL_C_WCHAR, rgbValue=<NULL data>, pcbValue=-1 )

SQLFetch( )
<--- SQL_SUCCESS Time elapsed - +1.500000E-004 seconds

SQLFetch( hStmt=2:2 )
---> Time elapsed - +1.400000E-005 seconds
( iRow=1, iCol=1, fCType=SQL_C_WCHAR, rgbValue=<NULL data>, pcbValue=-1 )
( iRow=1, iCol=2, fCType=SQL_C_WCHAR, rgbValue="O" - x'4F0000000000000000000000', pcbValue=12 )
( iRow=1, iCol=3, fCType=SQL_C_WCHAR, rgbValue="S" - x'53000000000000000000000000000000000000000000000000000000000000000000', pcbValue=34 )
( iRow=1, iCol=4, fCType=SQL_C_WCHAR, rgbValue="T" - x'54000000000000000000', pcbValue=10 )
( iRow=1, iCol=5, fCType=SQL_C_WCHAR, rgbValue=<NULL data>, pcbValue=-1 )

SQLFetch( )
<--- SQL_SUCCESS Time elapsed - +1.430000E-004 seconds

SQLFetch( hStmt=2:2 )
---> Time elapsed - +1.400000E-005 seconds

SQLFetch( )
<--- SQL_NO_DATA_FOUND Time elapsed - +1.500000E-005 seconds

SQLFreeHandle( fHandleType=SQL_HANDLE_STMT, hHandle=2:2 )
---> Time elapsed - +1.300000E-005 seconds
( COMMIT REPLY RECEIVED=1 )
( Caching Statement Structure=1 )

SQLAllocHandle( fHandleType=SQL_HANDLE_STMT, hInput=0:2, phOutput=&0000000004859214 )
---> Time elapsed - +1.300000E-005 seconds

SQLAllocHandle( phOutput=2:2 )
<--- SQL_SUCCESS Time elapsed - +6.300000E-005 seconds

SQLPrimaryKeysW( hStmt=2:2, szTableQualifier="", cbTableQualifier=0, szTableOwner="ONSITE", cbTableOwner=6, szTableName="AUDIT_DETAILS", cbTableName=13 )
---> Time elapsed - +1.800000E-005 seconds
( StmtOut="CALL SYSIBM.SQLPRIMARYKEYS(?,?,?,?)" )
( Package="SYSSH200 ", Section=4 )
( Row=1, iPar=1, fCType=SQL_C_CHAR, rgbValue=<NULL pointer>, pcbValue=-1, piIndicatorPtr=-1 )
( Row=1, iPar=2, fCType=SQL_C_CHAR, rgbValue="ONSITE" - x'4F4E53495445', pcbValue=6, piIndicatorPtr=6 )
( Row=1, iPar=3, fCType=SQL_C_CHAR, rgbValue="AUDIT_DETAILS" - x'41554449545F44455441494C53', pcbValue=13, piIndicatorPtr=13 )
( Row=1, iPar=4, fCType=SQL_C_CHAR, rgbValue="DATATYPE='ODBC';" - x'44415441545950453D274F444243273B', pcbValue=16, piIndicatorPtr=16 )
( return=0 )
( Requested Cursor Attributes=x'00000000' )
( Reply Cursor Attributes=x'0A000808' )
( Actual Cursor Attributes=x'0A000808' )

SQLPrimaryKeysW( )
<--- SQL_SUCCESS Time elapsed - +2.450000E-004 seconds

SQLNumResultCols( hStmt=2:2, pcCol=&00000000043b0908 )
---> Time elapsed - +1.400000E-005 seconds

SQLNumResultCols( pcCol=6 )
<--- SQL_SUCCESS Time elapsed - +2.000000E-005 seconds

SQLDescribeColW( hStmt=2:2, iCol=1, pszColName=&00007fffec131480, sColNameMaxCharLength=8192, psColNameCharLength=&000000000438d01a, pfSQLType=&0000000004850bb0, pcbColDef=&0000000004850bb4, pibScale=&0000000004850bb8, pfNullable=&0000000004850bba )
---> Time elapsed - +1.400000E-005 seconds

SQLDescribeColW( pszColName="TABLE_CAT", psColNameCharLength=536870921, pfSQLType=SQL_VARCHAR, pcbColDef=128, pibScale=65536, pfNullable=SQL_NULLABLE )
<--- SQL_SUCCESS Time elapsed - +4.800000E-005 seconds

SQLDescribeColW( hStmt=2:2, iCol=2, pszColName=&00007fffec131480, sColNameMaxCharLength=8192, psColNameCharLength=&000000000438d01a, pfSQLType=&0000000004850bd8, pcbColDef=&0000000004850bdc, pibScale=&0000000004850be0, pfNullable=&0000000004850be2 )
---> Time elapsed - +1.400000E-005 seconds

SQLDescribeColW( pszColName="TABLE_SCHEM", psColNameCharLength=536870923, pfSQLType=SQL_VARCHAR, pcbColDef=128, pibScale=0, pfNullable=SQL_NO_NULLS )
<--- SQL_SUCCESS Time elapsed - +4.600000E-005 seconds

SQLDescribeColW( hStmt=2:2, iCol=3, pszColName=&00007fffec131480, sColNameMaxCharLength=8192, psColNameCharLength=&000000000438d01a, pfSQLType=&0000000004850c00, pcbColDef=&0000000004850c04, pibScale=&0000000004850c08, pfNullable=&0000000004850c0a )
---> Time elapsed - +1.400000E-005 seconds

SQLDescribeColW( pszColName="TABLE_NAME", psColNameCharLength=536870922, pfSQLType=SQL_VARCHAR, pcbColDef=128, pibScale=0, pfNullable=SQL_NO_NULLS )
<--- SQL_SUCCESS Time elapsed - +4.500000E-005 seconds

SQLDescribeColW( hStmt=2:2, iCol=4, pszColName=&00007fffec131480, sColNameMaxCharLength=8192, psColNameCharLength=&000000000438d01a, pfSQLType=&0000000004850c28, pcbColDef=&0000000004850c2c, pibScale=&0000000004850c30, pfNullable=&0000000004850c32 )
---> Time elapsed - +1.500000E-005 seconds

SQLDescribeColW( pszColName="COLUMN_NAME", psColNameCharLength=536870923, pfSQLType=SQL_VARCHAR, pcbColDef=128, pibScale=0, pfNullable=SQL_NO_NULLS )
<--- SQL_SUCCESS Time elapsed - +4.500000E-005 seconds

SQLDescribeColW( hStmt=2:2, iCol=5, pszColName=&00007fffec131480, sColNameMaxCharLength=8192, psColNameCharLength=&000000000438d01a, pfSQLType=&0000000004850c50, pcbColDef=&0000000004850c54, pibScale=&0000000004850c58, pfNullable=&0000000004850c5a )
---> Time elapsed - +1.400000E-005 seconds

SQLDescribeColW( pszColName="KEY_SEQ", psColNameCharLength=536870919, pfSQLType=SQL_SMALLINT, pcbColDef=5, pibScale=65536, pfNullable=SQL_NULLABLE )
<--- SQL_SUCCESS Time elapsed - +4.500000E-005 seconds

SQLDescribeColW( hStmt=2:2, iCol=6, pszColName=&00007fffec131480, sColNameMaxCharLength=8192, psColNameCharLength=&000000000438d01a, pfSQLType=&0000000004850c78, pcbColDef=&0000000004850c7c, pibScale=&0000000004850c80, pfNullable=&0000000004850c82 )
---> Time elapsed - +1.500000E-005 seconds

SQLDescribeColW( pszColName="PK_NAME", psColNameCharLength=536870919, pfSQLType=SQL_VARCHAR, pcbColDef=128, pibScale=0, pfNullable=SQL_NO_NULLS )
<--- SQL_SUCCESS Time elapsed - +4.500000E-005 seconds

SQLBindCol( hStmt=2:2, iCol=1, fCType=SQL_C_WCHAR, rgbValue=&0000000003efbd30, cbValueMax=258, pcbValue=&0000000003efd840 )
---> Time elapsed - +1.400000E-005 seconds

SQLBindCol( )
<--- SQL_SUCCESS Time elapsed - +4.800000E-005 seconds

SQLBindCol( hStmt=2:2, iCol=2, fCType=SQL_C_WCHAR, rgbValue=&00000000043955a0, cbValueMax=258, pcbValue=&0000000003efd850 )
---> Time elapsed - +1.300000E-005 seconds

SQLBindCol( )
<--- SQL_SUCCESS Time elapsed - +2.600000E-005 seconds

SQLBindCol( hStmt=2:2, iCol=3, fCType=SQL_C_WCHAR, rgbValue=&00000000045885a0, cbValueMax=258, pcbValue=&0000000003efd860 )
---> Time elapsed - +1.300000E-005 seconds

SQLBindCol( )
<--- SQL_SUCCESS Time elapsed - +2.500000E-005 seconds

SQLBindCol( hStmt=2:2, iCol=4, fCType=SQL_C_WCHAR, rgbValue=&00000000048721a0, cbValueMax=258, pcbValue=&0000000003efd870 )
---> Time elapsed - +1.300000E-005 seconds

SQLBindCol( )
<--- SQL_SUCCESS Time elapsed - +2.500000E-005 seconds

SQLBindCol( hStmt=2:2, iCol=5, fCType=SQL_C_DEFAULT, rgbValue=&0000000003efd888, cbValueMax=2, pcbValue=&0000000003efd880 )
---> Time elapsed - +1.300000E-005 seconds

SQLBindCol( )
<--- SQL_SUCCESS Time elapsed - +2.500000E-005 seconds

SQLBindCol( hStmt=2:2, iCol=6, fCType=SQL_C_WCHAR, rgbValue=&0000000004210d70, cbValueMax=258, pcbValue=&0000000003efd890 )
---> Time elapsed - +1.200000E-005 seconds

SQLBindCol( )
<--- SQL_SUCCESS Time elapsed - +2.500000E-005 seconds

SQLFetch( hStmt=2:2 )
---> Time elapsed - +1.300000E-005 seconds
( iRow=1, iCol=1, fCType=SQL_C_WCHAR, rgbValue=<NULL data>, pcbValue=-1 )
( iRow=1, iCol=2, fCType=SQL_C_WCHAR, rgbValue="O" - x'4F0000000000000000000000', pcbValue=12 )
( iRow=1, iCol=3, fCType=SQL_C_WCHAR, rgbValue="A" - x'4100000000000000000000000000000000000000000000000000', pcbValue=26 )
( iRow=1, iCol=4, fCType=SQL_C_WCHAR, rgbValue="I" - x'49000000', pcbValue=4 )
( iRow=1, iCol=5, fCType=SQL_C_DEFAULT, rgbValue=x'0100', pcbValue=2 )
( iRow=1, iCol=6, fCType=SQL_C_WCHAR, rgbValue="S" - x'530000000000000000000000000000000000000000000000000000000000000000000000', pcbValue=36 )

SQLFetch( )
<--- SQL_SUCCESS Time elapsed - +1.810000E-004 seconds

SQLFreeHandle( fHandleType=SQL_HANDLE_STMT, hHandle=2:2 )
---> Time elapsed - +1.400000E-005 seconds
( COMMIT REPLY RECEIVED=1 )
( Caching Statement Structure=1 )

SQLAllocHandle( fHandleType=SQL_HANDLE_STMT, hInput=0:2, phOutput=&0000000004304db4 )
---> Time elapsed - +1.400000E-005 seconds

SQLAllocHandle( phOutput=2:2 )
<--- SQL_SUCCESS Time elapsed - +6.200000E-005 seconds

SQLExecDirectW( hStmt=2:2, pszSqlStr="TRUNCATE TABLE onsite.audit_details immediate", cbSqlStr=45 )
---> Time elapsed - +1.400000E-005 seconds
( StmtOut="TRUNCATE TABLE onsite.audit_details immediate" )
( Package="SYSSH200 ", Section=4 )
( COMMIT REPLY RECEIVED=1 )

SQLExecDirectW( )
<--- SQL_SUCCESS Time elapsed - +7.100000E-005 seconds

SQLAllocHandle( fHandleType=SQL_HANDLE_STMT, hInput=0:2, phOutput=&00000000044a8884 )
---> Time elapsed - +1.300000E-005 seconds

SQLAllocHandle( phOutput=2:3 )
<--- SQL_SUCCESS Time elapsed - +2.300000E-005 seconds

SQLExecDirectW( hStmt=2:3, pszSqlStr="INSERT INTO onsite.audit_details (id,audit_id,name,from_value,to_value) VALUES (2424479,553897,'specials','$500 off the first m", cbSqlStr=189 )
---> Time elapsed - +1.400000E-005 seconds
( StmtOut="INSERT INTO onsite.audit_details (id,audit_id,name,from_value,to_value) VALUES (2424479,553897,?,?,?)" )
( Package="SYSSH200 ", Section=5 )
( COMMIT REQUESTED=1 )
( COMMIT REPLY RECEIVED=1 )

SQLGetDiagRecW( fHandleType=SQL_HANDLE_STMT, hHandle=2:3, iRecNumber=1, pszSqlState=&0000000004878860, pfNativeError=&00007fffec135c00, pszErrorMsg=&00000000044a93c0, cbErrorMsgMax=1025, pcbErrorMsg=&00007fffec135bf0 )
---> Time elapsed - +1.400000E-005 seconds
( iRowNumber=-1, iColumnNumber=3 )

SQLGetDiagRecW( pszSqlState="07006", pfNativeError=-99999, pszErrorMsg="[IBM][CLI Driver] CLI0102E Invalid conversion. SQLSTATE=07006", pcbErrorMsg=62 )
<--- SQL_SUCCESS Time elapsed - +1.430000E-004 seconds

SQLFreeHandle( fHandleType=SQL_HANDLE_STMT, hHandle=2:3 )
---> Time elapsed - +3.400000E-005 seconds
( Caching Statement Structure=1 )

SQLDisconnect( hDbc=0:1 )
---> Time elapsed - +3.400000E-005 seconds

SQLDisconnect( )
<--- SQL_SUCCESS Time elapsed - +4.500000E-005 seconds

SQLFreeHandle( fHandleType=SQL_HANDLE_DBC, hHandle=0:1 )
---> Time elapsed - +1.200000E-005 seconds
( Number of allocations left before we freed the Pool=1 )

SQLFreeHandle( fHandleType=SQL_HANDLE_ENV, hHandle=0:1 )
---> Time elapsed - +1.200000E-005 seconds

SQLFreeHandle( )
<--- SQL_SUCCESS Time elapsed - +5.300000E-005 seconds

SQLDisconnect( hDbc=0:2 )
---> Time elapsed - +1.200000E-005 seconds

SQLDisconnect( )
<--- SQL_SUCCESS Time elapsed - +1.600000E-005 seconds

SQLFreeHandle( fHandleType=SQL_HANDLE_DBC, hHandle=0:2 )
---> Time elapsed - +1.200000E-005 seconds
( Number of allocations left before we freed the Pool=1 )

SQLFreeHandle( fHandleType=SQL_HANDLE_ENV, hHandle=0:2 )
---> Time elapsed - +1.200000E-005 seconds

SQLFreeHandle( )
<--- SQL_SUCCESS Time elapsed - +4.600000E-005 seconds