Hello,
I get the following error, when I try to connect to DB2 database on the mainframe using DB2 CLI, the same routine works fine with a database on an AIX. Any idea on the error will be appreciated. On mainfram, I am on V6.1 of DB2. Thanks.
SQLSetConnectAttr( hDbc=0:1, fOption=SQL_ATTR_AUTOCOMMIT, pvParam=NULL,
iStrLen=-3 )
---> Time elapsed - +2.231000E-003 seconds
SQLSetConnectAttr( )
<--- SQL_SUCCESS Time elapsed - +1.617000E-003 seconds
SQLSetConnectAttr( hDbc=0:1, fOption=SQL_CLOSE_BEHAVIOR, pvParam=&00000001,
iStrLen=-3 )
---> Time elapsed - +2.560000E-004 seconds
SQLSetConnectAttr( )
<--- SQL_SUCCESS_WITH_INFO Time elapsed - +1.718400E-002 seconds
SQLError( hEnv=0:1, hDbc=0:0, hStmt=0:0, pszSqlState=&0012c084,
pfNativeError=&0012c288, pszErrorMsg=&0012c08a, cbErrorMsgMax=506,
pcbErrorMsg=&0012c2a2 )
---> Time elapsed - +3.030000E-004 seconds
SQLError( )
<--- SQL_NO_DATA_FOUND Time elapsed - +1.243100E-002 seconds
SQLTransact( hEnv=0:1, hDbc=0:1, fType=SQL_ROLLBACK )
---> Time elapsed - +7.130000E-004 seconds
( Unretrieved error message="CLI0005W Option value changed.
SQLSTATE=01S02" )
I get the following error, when I try to connect to DB2 database on the mainframe using DB2 CLI, the same routine works fine with a database on an AIX. Any idea on the error will be appreciated. On mainfram, I am on V6.1 of DB2. Thanks.
SQLSetConnectAttr( hDbc=0:1, fOption=SQL_ATTR_AUTOCOMMIT, pvParam=NULL,
iStrLen=-3 )
---> Time elapsed - +2.231000E-003 seconds
SQLSetConnectAttr( )
<--- SQL_SUCCESS Time elapsed - +1.617000E-003 seconds
SQLSetConnectAttr( hDbc=0:1, fOption=SQL_CLOSE_BEHAVIOR, pvParam=&00000001,
iStrLen=-3 )
---> Time elapsed - +2.560000E-004 seconds
SQLSetConnectAttr( )
<--- SQL_SUCCESS_WITH_INFO Time elapsed - +1.718400E-002 seconds
SQLError( hEnv=0:1, hDbc=0:0, hStmt=0:0, pszSqlState=&0012c084,
pfNativeError=&0012c288, pszErrorMsg=&0012c08a, cbErrorMsgMax=506,
pcbErrorMsg=&0012c2a2 )
---> Time elapsed - +3.030000E-004 seconds
SQLError( )
<--- SQL_NO_DATA_FOUND Time elapsed - +1.243100E-002 seconds
SQLTransact( hEnv=0:1, hDbc=0:1, fType=SQL_ROLLBACK )
---> Time elapsed - +7.130000E-004 seconds
( Unretrieved error message="CLI0005W Option value changed.
SQLSTATE=01S02" )