Hello db2perl,
Tuesday, June 19, 2001, 12:33:07 AM, you wrote:
I specified file instead of dir. Now i changed it to dir
and, heh, trace file appeared ;). Here is it
[ Process: 1104, Thread: 1024 ]
[ Date & Time: 19/06/2001 10.54.23.000008 ]
[ Product: QDB2/NT 7.1.0.41 ]
[ Level Identifier: 03010105 ]
[ CLI Driver Version: 07.02.0000 ]
[ Informational Tokens: "DB2 v7.1.0.41","n010426","WR21254" ]
SQLAllocHandle( fHandleType=SQL_HANDLE_ENV, hInput=0:0, phOutput=&01ae3fcc )
---> Time elapsed - 0 seconds
SQLAllocHandle( phOutput=0:1 )
<--- SQL_SUCCESS Time elapsed - +2.705000E-003 seconds
SQLSetEnvAttr( hEnv=0:1, fAttribute=SQL_ATTR_ODBC_VERSION, vParam=3, cbParam=0 )
---> Time elapsed - +3.670000E-004 seconds
SQLSetEnvAttr( )
<--- SQL_SUCCESS Time elapsed - +1.475000E-003 seconds
SQLAllocHandle( fHandleType=SQL_HANDLE_DBC, hInput=0:1, phOutput=&01a8ba78 )
---> Time elapsed - +4.220000E-004 seconds
SQLAllocHandle( phOutput=0:1 )
<--- SQL_SUCCESS Time elapsed - +2.281700E-002 seconds
SQLConnect( hDbc=0:1, szDSN="rent", cbDSN=-3, szUID="", cbUID=-3, szAuthStr="",
cbAuthStr=-3 )
---> Time elapsed - +1.150700E-002 seconds
( DBMS NAME="DB2/NT", Version="07.02.0000", Fixpack="0x23010105" )
( Application Codepage=1251, Database Codepage=1251, Char Send/Recv Codepage=1251,
Graphic Send/Recv Codepage=1251, iGraphic Codepage=1251 )
SQLConnect( )
<--- SQL_SUCCESS Time elapsed - +1.830246E+000 seconds
( DSN=""RENT"" )
( UID=" " )
( PWD="*" )
SQLSetConnectAttr( hDbc=0:1, fOption=SQL_ATTR_AUTOCOMMIT, pvParam=&00000001, iStrLen=0
)
---> Time elapsed - +2.225000E-003 seconds
SQLSetConnectAttr( )
<--- SQL_SUCCESS Time elapsed - +8.693000E-003 seconds
SQLAllocHandle( fHandleType=SQL_HANDLE_STMT, hInput=0:1, phOutput=&01a4f284 )
---> Time elapsed - +9.600000E-004 seconds
SQLAllocHandle( phOutput=1:1 )
<--- SQL_SUCCESS Time elapsed - +2.133600E-002 seconds
SQLPrepare( hStmt=1:1, pszSqlStr="call sp_Get_Buildings()", cbSqlStr=-3 )
---> Time elapsed - +6.350000E-003 seconds
( StmtOut="call sp_Get_Buildings()" )
SQLPrepare( )
<--- SQL_SUCCESS Time elapsed - +1.919000E-002 seconds
SQLNumParams( hStmt=1:1, pcPar=&0140fb0e )
---> Time elapsed - +3.300000E-004 seconds
SQLNumParams( pcPar=0 )
<--- SQL_SUCCESS Time elapsed - +1.268000E-003 seconds
SQLNumResultCols( hStmt=1:1, pcCol=&0140faf2 )
---> Time elapsed - +1.681000E-003 seconds
SQLNumResultCols( pcCol=0 )
<--- SQL_SUCCESS Time elapsed - +1.289000E-003 seconds
SQLExecute( hStmt=1:1 )
---> Time elapsed - +8.473000E-003 seconds
( return=0 )
SQLExecute( )
<--- SQL_SUCCESS Time elapsed - +1.783976E+000 seconds
SQLNumResultCols( hStmt=1:1, pcCol=&0140fbf2 )
---> Time elapsed - +3.310000E-004 seconds
SQLNumResultCols( pcCol=5 )
<--- SQL_SUCCESS Time elapsed - +1.184000E-003 seconds
SQLDescribeCol( hStmt=1:1, iCol=1, pszColName=&01c86760, cbColNameMax=128,
pcbColName=&01a74744, pfSQLType=&01a7473c, pcbColDef=&01a7474c, pibScale=&01a74750,
pfNullable=&01a74752 )
---> Time elapsed - +2.940000E-004 seconds
SQLDescribeCol( pszColName="ID" - X"4944", pcbColName=2, pfSQLType=SQL_INTEGER,
pcbColDef=10, pibScale=0, pfNullable=SQL_NO_NULLS )
<--- SQL_SUCCESS Time elapsed - +6.074300E-002 seconds
SQLColAttribute( hStmt=1:1, iCol=1, fDescType=SQL_DESC_DISPLAY_SIZE, rgbDesc=NULL,
cbDescMax=0, pcbDesc=NULL, pfDesc=&01a74748 )
---> Time elapsed - +3.120000E-004 seconds
SQLColAttribute( pfDesc=11 )
<--- SQL_SUCCESS Time elapsed - +2.213000E-003 seconds
SQLBindCol( hStmt=1:1, iCol=1, fCType=SQL_C_CHAR, rgbValue=&01b2fc20, cbValueMax=12,
pcbValue=&01a74760 )
---> Time elapsed - +2.510000E-004 seconds
SQLBindCol( )
<--- SQL_SUCCESS Time elapsed - +2.665000E-003 seconds
SQLDescribeCol( hStmt=1:1, iCol=2, pszColName=&01c86763, cbColNameMax=128,
pcbColName=&01a74770, pfSQLType=&01a74768, pcbColDef=&01a74778, pibScale=&01a7477c,
pfNullable=&01a7477e )
---> Time elapsed - +2.630000E-004 seconds
SQLDescribeCol( pszColName="STREET_ID" - X"5354524545545F4944", pcbColName=9,
pfSQLType=SQL_INTEGER, pcbColDef=10, pibScale=0, pfNullable=SQL_NO_NULLS )
<--- SQL_SUCCESS Time elapsed - +4.233000E-003 seconds
SQLColAttribute( hStmt=1:1, iCol=2, fDescType=SQL_DESC_DISPLAY_SIZE, rgbDesc=NULL,
cbDescMax=0, pcbDesc=NULL, pfDesc=&01a74774 )
---> Time elapsed - +2.570000E-004 seconds
SQLColAttribute( pfDesc=11 )
<--- SQL_SUCCESS Time elapsed - +2.138000E-003 seconds
SQLBindCol( hStmt=1:1, iCol=2, fCType=SQL_C_CHAR, rgbValue=&01ab7600, cbValueMax=12,
pcbValue=&01a7478c )
---> Time elapsed - +2.520000E-004 seconds
SQLBindCol( )
<--- SQL_SUCCESS Time elapsed - +1.684000E-003 seconds
SQLDescribeCol( hStmt=1:1, iCol=3, pszColName=&01c8676d, cbColNameMax=128,
pcbColName=&01a7479c, pfSQLType=&01a74794, pcbColDef=&01a747a4, pibScale=&01a747a8,
pfNullable=&01a747aa )
---> Time elapsed - +2.450000E-004 seconds
SQLDescribeCol( pszColName="NAME" - X"4E414D45", pcbColName=4, pfSQLType=SQL_VARCHAR,
pcbColDef=100, pibScale=0, pfNullable=SQL_NULLABLE )
<--- SQL_SUCCESS Time elapsed - +4.239000E-003 seconds
SQLColAttribute( hStmt=1:1, iCol=3, fDescType=SQL_DESC_DISPLAY_SIZE, rgbDesc=NULL,
cbDescMax=0, pcbDesc=NULL, pfDesc=&01a747a0 )
---> Time elapsed - +2.800000E-004 seconds
SQLColAttribute( pfDesc=100 )
<--- SQL_SUCCESS Time elapsed - +2.054000E-003 seconds
SQLBindCol( hStmt=1:1, iCol=3, fCType=SQL_C_CHAR, rgbValue=&01b25ab8, cbValueMax=101,
pcbValue=&01a747b8 )
---> Time elapsed - +2.510000E-004 seconds
SQLBindCol( )
<--- SQL_SUCCESS Time elapsed - +1.705000E-003 seconds
SQLDescribeCol( hStmt=1:1, iCol=4, pszColName=&01c86772, cbColNameMax=128,
pcbColName=&01a747c8, pfSQLType=&01a747c0, pcbColDef=&01a747d0, pibScale=&01a747d4,
pfNullable=&01a747d6 )
---> Time elapsed - +2.430000E-004 seconds
SQLDescribeCol( pszColName="NUMBER" - X"4E554D424552", pcbColName=6,
pfSQLType=SQL_VARCHAR, pcbColDef=20, pibScale=0, pfNullable=SQL_NULLABLE )
<--- SQL_SUCCESS Time elapsed - +3.274000E-003 seconds
SQLColAttribute( hStmt=1:1, iCol=4, fDescType=SQL_DESC_DISPLAY_SIZE, rgbDesc=NULL,
cbDescMax=0, pcbDesc=NULL, pfDesc=&01a747cc )
---> Time elapsed - +9.260000E-004 seconds
SQLColAttribute( pfDesc=20 )
<--- SQL_SUCCESS Time elapsed - +2.106000E-003 seconds
SQLBindCol( hStmt=1:1, iCol=4, fCType=SQL_C_CHAR, rgbValue=&015df908, cbValueMax=21,
pcbValue=&01a747e4 )
---> Time elapsed - +2.490000E-004 seconds
SQLBindCol( )
<--- SQL_SUCCESS Time elapsed - +1.678000E-003 seconds
SQLDescribeCol( hStmt=1:1, iCol=5, pszColName=&01c86779, cbColNameMax=128,
pcbColName=&01a747f4, pfSQLType=&01a747ec, pcbColDef=&01a747fc, pibScale=&01a74800,
pfNullable=&01a74802 )
---> Time elapsed - +3.250000E-004 seconds
SQLDescribeCol( pszColName="CORPS" - X"434F525053", pcbColName=5,
pfSQLType=SQL_VARCHAR, pcbColDef=20, pibScale=0, pfNullable=SQL_NULLABLE )
<--- SQL_SUCCESS Time elapsed - +3.353000E-003 seconds
SQLColAttribute( hStmt=1:1, iCol=5, fDescType=SQL_DESC_DISPLAY_SIZE, rgbDesc=NULL,
cbDescMax=0, pcbDesc=NULL, pfDesc=&01a747f8 )
---> Time elapsed - +2.400000E-004 seconds
SQLColAttribute( pfDesc=20 )
<--- SQL_SUCCESS Time elapsed - +9.331000E-003 seconds
SQLBindCol( hStmt=1:1, iCol=5, fCType=SQL_C_CHAR, rgbValue=&01b29450, cbValueMax=21,
pcbValue=&01a74810 )
---> Time elapsed - +2.570000E-004 seconds
SQLBindCol( )
<--- SQL_SUCCESS Time elapsed - +2.435000E-003 seconds
SQLRowCount( hStmt=1:1, pcRow=&01a4f29c )
---> Time elapsed - +4.640000E-004 seconds
SQLRowCount( pcRow=-1 )
<--- SQL_SUCCESS Time elapsed - +1.228000E-003 seconds
SQLAllocHandle( fHandleType=SQL_HANDLE_STMT, hInput=0:1, phOutput=&01c864d4 )
---> Time elapsed - +8.910000E-004 seconds
SQLAllocHandle( phOutput=1:2 )
<--- SQL_SUCCESS Time elapsed - +2.602000E-003 seconds
SQLPrepare( hStmt=1:2, pszSqlStr="call sp_Get_Streets()", cbSqlStr=-3 )
---> Time elapsed - +2.900000E-004 seconds
( StmtOut="call sp_Get_Streets()" )
SQLPrepare( )
<--- SQL_SUCCESS Time elapsed - +2.021000E-003 seconds
SQLNumParams( hStmt=1:2, pcPar=&0140fb0e )
---> Time elapsed - +3.400000E-004 seconds
SQLNumParams( pcPar=0 )
<--- SQL_SUCCESS Time elapsed - +1.168000E-003 seconds
SQLNumResultCols( hStmt=1:2, pcCol=&0140faf2 )
---> Time elapsed - +8.430000E-004 seconds
SQLNumResultCols( pcCol=0 )
<--- SQL_SUCCESS Time elapsed - +1.305000E-003 seconds
SQLExecute( hStmt=1:2 )
---> Time elapsed - +3.570000E-004 seconds
( return=0 )
SQLExecute( )
<--- SQL_SUCCESS Time elapsed - +8.533300E-002 seconds
SQLNumResultCols( hStmt=1:2, pcCol=&0140fbf2 )
---> Time elapsed - +2.720000E-004 seconds
SQLNumResultCols( pcCol=2 )
<--- SQL_SUCCESS Time elapsed - +1.148000E-003 seconds
SQLDescribeCol( hStmt=1:2, iCol=1, pszColName=&015d7e90, cbColNameMax=128,
pcbColName=&01b25464, pfSQLType=&01b2545c, pcbColDef=&01b2546c, pibScale=&01b25470,
pfNullable=&01b25472 )
---> Time elapsed - +3.020000E-004 seconds
SQLDescribeCol( pszColName="ID" - X"4944", pcbColName=2, pfSQLType=SQL_INTEGER,
pcbColDef=10, pibScale=0, pfNullable=SQL_NO_NULLS )
<--- SQL_SUCCESS Time elapsed - +4.043000E-003 seconds
SQLColAttribute( hStmt=1:2, iCol=1, fDescType=SQL_DESC_DISPLAY_SIZE, rgbDesc=NULL,
cbDescMax=0, pcbDesc=NULL, pfDesc=&01b25468 )
---> Time elapsed - +2.520000E-004 seconds
SQLColAttribute( pfDesc=11 )
<--- SQL_SUCCESS Time elapsed - +2.252000E-003 seconds
SQLBindCol( hStmt=1:2, iCol=1, fCType=SQL_C_CHAR, rgbValue=&01b319b0, cbValueMax=12,
pcbValue=&01b25480 )
---> Time elapsed - +2.540000E-004 seconds
SQLBindCol( )
<--- SQL_SUCCESS Time elapsed - +1.678000E-003 seconds
SQLDescribeCol( hStmt=1:2, iCol=2, pszColName=&015d7e93, cbColNameMax=128,
pcbColName=&01b25490, pfSQLType=&01b25488, pcbColDef=&01b25498, pibScale=&01b2549c,
pfNullable=&01b2549e )
---> Time elapsed - +2.420000E-004 seconds
SQLDescribeCol( pszColName="NAME" - X"4E414D45", pcbColName=4, pfSQLType=SQL_VARCHAR,
pcbColDef=100, pibScale=0, pfNullable=SQL_NULLABLE )
<--- SQL_SUCCESS Time elapsed - +4.093000E-003 seconds
SQLColAttribute( hStmt=1:2, iCol=2, fDescType=SQL_DESC_DISPLAY_SIZE, rgbDesc=NULL,
cbDescMax=0, pcbDesc=NULL, pfDesc=&01b25494 )
---> Time elapsed - +2.530000E-004 seconds
SQLColAttribute( pfDesc=100 )
<--- SQL_SUCCESS Time elapsed - +2.029000E-003 seconds
SQLBindCol( hStmt=1:2, iCol=2, fCType=SQL_C_CHAR, rgbValue=&01c869f0, cbValueMax=101,
pcbValue=&01b254ac )
---> Time elapsed - +2.480000E-004 seconds
SQLBindCol( )
<--- SQL_SUCCESS Time elapsed - +1.709000E-003 seconds
SQLRowCount( hStmt=1:2, pcRow=&01c864ec )
---> Time elapsed - +2.450000E-004 seconds
SQLRowCount( pcRow=-1 )
<--- SQL_SUCCESS Time elapsed - +1.194000E-003 seconds
SQLFetch( hStmt=1:1 )
---> Time elapsed - +3.670000E-004 seconds
SQLFetch( )
<--- SQL_SUCCESS Time elapsed - +1.764700E-002 seconds
( iCol=1, fCType=SQL_C_CHAR, rgbValue="22" - X"3232", pcbValue=2 )
( iCol=2, fCType=SQL_C_CHAR, rgbValue="1" - X"31", pcbValue=1 )
( iCol=3, fCType=SQL_C_CHAR, rgbValue="��" - X"E2F3F6E2F3F6", pcbValue=6 )
( iCol=4, fCType=SQL_C_CHAR, rgbValue="11" - X"3131", pcbValue=2 )
( iCol=5, fCType=SQL_C_CHAR, rgbValue="22" - X"3232", pcbValue=2 )
SQLFetch( hStmt=1:1 )
---> Time elapsed - +7.004000E-003 seconds
SQLFetch( )
<--- SQL_SUCCESS Time elapsed - +1.376000E-003 seconds
( iCol=1, fCType=SQL_C_CHAR, rgbValue="25" - X"3235", pcbValue=2 )
( iCol=2, fCType=SQL_C_CHAR, rgbValue="1" - X"31", pcbValue=1 )
( iCol=3, fCType=SQL_C_CHAR, rgbValue="��" - X"E2F3F6E2F3F6", pcbValue=6 )
( iCol=4, fCType=SQL_C_CHAR, rgbValue="1" - X"31", pcbValue=1 )
( iCol=5, fCType=SQL_C_CHAR, rgbValue="2" - X"32", pcbValue=1 )
SQLFetch( hStmt=1:1 )
---> Time elapsed - +6.828000E-003 seconds
SQLFetch( )
<--- SQL_NO_DATA_FOUND Time elapsed - +7.946000E-003 seconds
SQLFreeStmt( hStmt=1:1, fOption=SQL_CLOSE )
---> Time elapsed - +9.209000E-003 seconds
( COMMIT=1 )
SQLFreeStmt( )
<--- SQL_SUCCESS Time elapsed - +7.853500E-002 seconds
SQLFetch( hStmt=1:2 )
---> Time elapsed - +5.070000E-004 seconds
SQLFetch( )
<--- SQL_ERROR Time elapsed - +9.119200E-002 seconds
SQLGetDiagRec( fHandleType=SQL_HANDLE_STMT, hHandle=1:2, iRecNumber=1,
pszSqlState=&0140faf0, pfNativeError=&0140fafc, pszErrorMsg=&0140f6ec,
cbErrorMsgMax=1025, pcbErrorMsg=&0140fb16 )
---> Time elapsed - +3.822700E-002 seconds
SQLGetDiagRec( pszSqlState="HY010", pfNativeError=-99999, pszErrorMsg="[IBM][CLI
Driver] CLI0125E Function sequence error. SQLSTATE=HY010" -
X"5B49424D5D5B434C49204472697665725D20434C493031323545202046756E6374696F6E2073657175656E6365206572726F722E2053514C53544154453D4859303130",
pcbErrorMsg=67 )
<--- SQL_SUCCESS Time elapsed - +3.746800E-002 seconds
SQLFreeStmt( hStmt=1:2, fOption=SQL_CLOSE )
---> Time elapsed - +2.950000E-004 seconds
SQLFreeStmt( )
<--- SQL_SUCCESS Time elapsed - +1.420000E-003 seconds
SQLFreeHandle( fHandleType=SQL_HANDLE_STMT, hHandle=1:1 )
---> Time elapsed - +3.313300E-002 seconds
SQLFreeHandle( )
<--- SQL_SUCCESS Time elapsed - +7.420500E-002 seconds
SQLFreeHandle( fHandleType=SQL_HANDLE_STMT, hHandle=1:2 )
---> Time elapsed - +5.110000E-004 seconds
SQLFreeHandle( )
<--- SQL_SUCCESS Time elapsed - +2.105000E-003 seconds
SQLDisconnect( hDbc=0:1 )
---> Time elapsed - +1.297000E-003 seconds
SQLDisconnect( )
<--- SQL_SUCCESS Time elapsed - +5.944670E-001 seconds
SQLFreeHandle( fHandleType=SQL_HANDLE_DBC, hHandle=0:1 )
---> Time elapsed - +3.280000E-004 seconds
SQLFreeHandle( )
<--- SQL_SUCCESS Time elapsed - +1.238000E-003 seconds
SQLFreeHandle( fHandleType=SQL_HANDLE_ENV, hHandle=0:1 )
---> Time elapsed - +2.720000E-004 seconds
SQLFreeHandle( )
<--- SQL_SUCCESS Time elapsed - +4.779500E-002 seconds
dcic> Hi Alex, I assumed sqllib is your DB2 install directory, if it isn't that's
dcic> okay, db2cli.ini is in the root of the DB2 for Windows install path. Did
dcic> you replace <some path> with an existing directory?
[...]
dcic> I'm using the latest release of DBD::DB2 module(v0.75) and DB2
dcic> v7.1 on windows 2000.
dcic> I added those lines in db2cli.ini as you advised, but nothing
dcic> happend.
dcic> After i runned my script trace file didn't appear. I tried to
dcic> reboot, but i got the same result...
dcic> BTW, i found db2cli.ini only in the root of DB2 installation
dcic> and there is no sqllib directory.
dcic> Maybe i'm doing smth wrong ? Do DB2 fixpack's have any importance
dcic> in this problem ? For a while i didn't install any of them,
dcic> but if it helps i'll download that 250M with FP3.
dcic>> Hi Alex, what version of DBD::DB2 are you using? If you are not
dcic> using the
dcic>> latest (0.75) please upgrade. If you are, then please send me a CLI
dcic> trace
dcic>> of the failure. Add this to db2cli.ini (sqllib\db2cli.ini on
dcic> Windows,
dcic>> sqllib/cfg/db2cli.ini on Unix):
dcic>> [common]
dcic>> trace=1
dcic>> traceflush=1
dcic>> tracepathname=<some path>
dcic> [...]
dcic>> I'm trying to fetch data from 2 stored procedures one after
dcic>> another and i'm getting weird error message when it start to
dcic>> fetch from second one. Here is a code snippet
dcic>> ----
dcic>> my $sth1 = $dbh->prepare("call sp_Get_Buildings()");
dcic>> $sth1->execute();
dcic>> my $sth2 = $dbh->prepare("call sp_Get_Streets()");
dcic>> $sth2->execute();
dcic>> print "1st sth" while($sth1->fetch);
dcic>> print "2nd sth" while($sth2->fetch);
dcic>> ----
dcic>> On last line it writes
dcic>> ---
dcic>> DBD::DB2::st fetch failed: [IBM][CLI Driver] CLI0125E Function
dcic> se
dcic>> quence error. SQLSTATE=HY010 at 1.pl line 12.
dcic>> ---
dcic>> I already found several solutions for this - place each out
dcic> after
dcic>> corresponding while($sth->fetch), but it isn't suit for me, cos
dcic> in
dcic>> real project i have to at first prepare each $sth and only then
dcic> do
dcic>> smth with them. Another solution is to replace call to stored
dcic>> procedure by SQL statement itself, but i think it's not good...
dcic>> So, here are a couple of questions:
dcic>> 1. What does that error message mean ?
dcic>> 2. How i can get rid of it ?
dcic>> Thanks in advance.
--
Best regards,
Alex mailto:[EMAIL PROTECTED]
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
