Hi,
Could you confirm that select for update is not supported by SAP DB under ODBC i.e.
cursors are not updateable.;
I'm having a problem where no data is getting added to the database. The SAP db ODBC
trace looks as follows and it has some vague warnings.
The program is a database provider for Nuance voice recognition and uses the
database to store binary data. It is known to work with Oracle/db2/Sybase.Initially it
did'nt work with SAPDB due to SAPDB's buggy handling of ODBC function parameters with
a null terminated string and length inclusive of terminator. (fixed that by passing
SQL_NTS instead of passing length).
So what is the best was of working around SQL_CONCUR_READ_ONLY?
Regards,
Ajit
PRODUCT : SAP DB C-PreComp Runtime
VERSION : 7.3.0
BUILD : 028-000-000-000
DATASOURCE: mmp
SESSION : 1;
SQLMODE : INTERN
SERVERDB : mmp
SERVERNODE: localhost
CONNECT "NUANCE " IDENTIFIED BY :A ISOLATION LEVEL 3
START : DATE : 2002-10-30 TIME : 0014:06:09
END : DATE : 2002-10-30 TIME : 0014:06:09
STMMODE : ORACLE
SELECT COUNT(*) FROM nuance.ndb__mmp WHERE nuance_key = ?
PARSE : CMD :
mfIndex init : 1
mfIndex init : 2
PARSEID: OUTPUT: 000017B5 00000201 3C002E00 01000000
START : DATE : 2002-10-30 TIME : 0014:06:12
END : DATE : 2002-10-30 TIME : 0014:06:12
STMMODE : ORACLE
SELECT COUNT(*) FROM nuance.ndb__mmp WHERE nuance_key = ?
EXECUTE: CMD :
PARSEID: INPUT : 000017B5 00000201 3C002E00 01000000
WARNING: W1--------------
INPUT : 1: COLUMN1 [Binary data here] : 1
mfIndex init : 2
mfIndex init : 2
WARNING: W1--------------
SQLRESULTNAME : SQL_CURSOR_0001
START : DATE : 2002-10-30 TIME : 0014:06:12
END : DATE : 2002-10-30 TIME : 0014:06:12
STMMODE : ORACLE
MASS STATEMENT :
FETCH "SQL_CURSOR_0001"
PARSE : CMD :
WARNING: W--3------------
PARSEID: OUTPUT: 000017B5 00000401 2A002B00 01000000
START : DATE : 2002-10-30 TIME : 0014:06:12
END : DATE : 2002-10-30 TIME : 0014:06:12
STMMODE : ORACLE
MASS STATEMENT :
FETCH "SQL_CURSOR_0001"
EXECUTE: CMD :
PARSEID: INPUT : 000017B5 00000401 2A002B00 01000000
PARAMETER DESCRIPTION: 0X014C8FD8
Application Kernel
Nr. Type Length Type Length Fraction
---------------------------------------------
1 7 13 0 10 0
OUTPUT : 1: EXPRESSION1 : 0
SQLERRD(INDEX_3) : 1
START : DATE : 2002-10-30 TIME : 0014:06:12
END : DATE : 2002-10-30 TIME : 0014:06:12
STMMODE : ORACLE
MASS STATEMENT :
FETCH "SQL_CURSOR_0001"
EXECUTE: CMD :
PARSEID: INPUT : 000017B5 00000401 2A002B00 01000000
SQLCODE: 100 ROW NOT FOUND
START : DATE : 2002-10-30 TIME : 0014:06:12
END : DATE : 2002-10-30 TIME : 0014:06:12
STMMODE : ORACLE
COMMIT WORK
START : DATE : 2002-10-30 TIME : 0014:06:12
END : DATE : 2002-10-30 TIME : 0014:06:12
STMMODE : ORACLE
CLOSE "SQL_CURSOR_0001"
PARSE : CMD :
PARSEID: OUTPUT: 000017B5 00000601 06002800 01000000
START : DATE : 2002-10-30 TIME : 0014:06:12
END : DATE : 2002-10-30 TIME : 0014:06:12
STMMODE : ORACLE
CLOSE "SQL_CURSOR_0001"
EXECUTE: CMD :
PARSEID: INPUT : 000017B5 00000601 06002800 01000000
PARSEID: SELECT: 00000000 00000000 00000000 01000000
START : DATE : 2002-10-30 TIME : 0014:06:12
END : DATE : 2002-10-30 TIME : 0014:06:12
PARSEID: DROP : 000017B5 00000401 2A002B00 01000000
START : DATE : 2002-10-30 TIME : 0014:06:12
END : DATE : 2002-10-30 TIME : 0014:06:12
SQCDROPPARSID
PARSEID: : 000017B5 00000401 2A002B00 01000000
PARSEID: DROP : 000017B5 00000601 06002800 01000000
START : DATE : 2002-10-30 TIME : 0014:06:12
END : DATE : 2002-10-30 TIME : 0014:06:12
SQCDROPPARSID
PARSEID: : 000017B5 00000601 06002800 01000000
mfIndex delete : 2
PARSEID: DROP : 000017B5 00000201 3C002E00 01000000
START : DATE : 2002-10-30 TIME : 0014:06:12
END : DATE : 2002-10-30 TIME : 0014:06:12
SQCDROPPARSID
PARSEID: : 000017B5 00000201 3C002E00 01000000
STMMODE : ORACLE
SELECT nuance_key FROM nuance.ndb_timestamp__mmp WHERE nuance_key = ? FOR
UPDATE OF
PARSE : CMD :
mfIndex init : 2
PARSEID: OUTPUT: 000017B5 00000A01 3C002F00 01000000
START : DATE : 2002-10-30 TIME : 0014:06:12
END : DATE : 2002-10-30 TIME : 0014:06:12
mfIndex delete : 2
PARSEID: DROP : 000017B5 00000A01 3C002F00 01000000
START : DATE : 2002-10-30 TIME : 0014:06:12
END : DATE : 2002-10-30 TIME : 0014:06:12
SQCDROPPARSID
PARSEID: : 000017B5 00000A01 3C002F00 01000000
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
