Re: update through ODBC

Additional information:

v_sqltext shows that all these updates use the same sql_address.

"__" <2_at_2.com> wrote in message news:a2rloq$q8p16_at_kcweb01.netnews.att.com...
> Dear All,
>
> I am trying to tune an update of a single table by a third party software
> that uses ODBC to update 6000 rows. These 6000 rows take about 7 minutes
to
> update. The ODBC trace shows the following output. I am trying to
understand
> if the third party software is seding in row-by-row, or if all rows are
sent
> in simultaneously. To test this I updated only 9 rows from the thirdparty
> software and I got one "UPDATE" statement and nine "SQLEXECUTE" statements
> in the log. Am I write in assuming that the software is sending in 9
> different update statements?
>
> Any help will be greatly appreciated.
>
> svcar32 690-734 EXIT SQLPrepare with return code 0 (SQL_SUCCESS)
> HSTMT 007D26E8
> UCHAR * 0x0012F394 [ -3] "UPDATE abc1001 SET amount=?
> WHERE curncy=? AND nature=? AND accnt=? AND flow=? AND period=? AND
> enumber=? AND partner=? AND ctshare=? AND region=? AND prod=? AND cmt=?
AND
> supcat=? AND transf=? AND assign=? AND lnkacct=?\ 0"
> SDWORD -3
>
> svcar32 690-734 ENTER SQLExecute
> HSTMT 007D26E8
>
> svcar32 690-734 EXIT SQLExecute with return code 0 (SQL_SUCCESS)
> HSTMT 007D26E8
>
> svcar32 690-734 ENTER SQLExecute
> HSTMT 007D26E8
>
> svcar32 690-734 EXIT SQLExecute with return code 0 (SQL_SUCCESS)
> HSTMT 007D26E8
>
> svcar32 690-734 ENTER SQLExecute
> HSTMT 007D26E8
>
> svcar32 690-734 EXIT SQLExecute with return code 0 (SQL_SUCCESS)
> HSTMT 007D26E8
>
> svcar32 690-734 ENTER SQLExecute
> HSTMT 007D26E8
>
> svcar32 690-734 EXIT SQLExecute with return code 0 (SQL_SUCCESS)
> HSTMT 007D26E8
>
> svcar32 690-734 ENTER SQLExecute
> HSTMT 007D26E8
>
> svcar32 690-734 EXIT SQLExecute with return code 0 (SQL_SUCCESS)
> HSTMT 007D26E8
>
> svcar32 690-734 ENTER SQLExecute
> HSTMT 007D26E8
>
> svcar32 690-734 EXIT SQLExecute with return code 0 (SQL_SUCCESS)
> HSTMT 007D26E8
>
> svcar32 690-734 ENTER SQLExecute
> HSTMT 007D26E8
>
> svcar32 690-734 EXIT SQLExecute with return code 0 (SQL_SUCCESS)
> HSTMT 007D26E8
>
> svcar32 690-734 ENTER SQLExecute
> HSTMT 007D26E8
>
> svcar32 690-734 EXIT SQLExecute with return code 0 (SQL_SUCCESS)
> HSTMT 007D26E8
>
> svcar32 690-734 ENTER SQLExecute
> HSTMT 007D26E8
>
> svcar32 690-734 EXIT SQLExecute with return code 0 (SQL_SUCCESS)
> HSTMT 007D26E8
>
> svcar32 690-734 ENTER SQLTransact
> HENV 007D1250
> HDBC 007D12F8
> UWORD 0 <SQL_COMMIT>
>
> svcar32 690-734 EXIT SQLTransact with return code 0
(SQL_SUCCESS)
> HENV 007D1250
> HDBC 007D12F8
> UWORD 0 <SQL_COMMIT>
>
> svcar32 690-734 ENTER SQLSetConnectOption
> HDBC 007D12F8
> UWORD 102 <SQL_AUTOCOMMIT>
> SQLLEN 1
>
> svcar32 690-734 EXIT SQLSetConnectOption with return code 0
> (SQL_SUCCESS)
> HDBC 007D12F8
> UWORD 102 <SQL_AUTOCOMMIT>
> SQLLEN 1
>
> svcar32 690-734 ENTER SQLFreeStmt
> HSTMT 007D26E8
> UWORD 1 <SQL_DROP>
>
> svcar32 690-734 EXIT SQLFreeStmt with return code 0
(SQL_SUCCESS)
> HSTMT 007D26E8
> UWORD 1 <SQL_DROP>
>
>
Received on Fri Jan 25 2002 - 08:13:37 CST