Hello !
I maintain a backend in a commercial context. The backend provides access to MS SQLServer (via ODBC) and Oracle (via OCI). Now I want to make it ready for PostgreSQL via ODBC.
For performance reasons we use bulk inserts/updates.
This is done in this manner:
SQLAllocStmt
SQLPrepare // insert into kfztest.KP values (?,?,...,?)
SQBindParameter // for each column
...
SQLSetStmtAttr // SQL_ATTR_PARAMSET_SIZE to 523
SQLSetStmtAttr // SQL_ATTR_PARAM_STATUS_PTR to an array of SQLSMALLINT
SQLSetStmtAttr // SQL_ATTR_PARAMS_PROCESSED_PTR to an SQLULEN variable
SQLExecute // ends with SQL_SUCCESS
SQLRowCount // delivers 1 !!!!
SQLEndTrans // with COMMIT
When necessary I can provide a full ODBC trace.
All records were written into table.
Thanks in advance.
Regards
Johann Letzel