Powered by Zoomin Software. For more details please contactZoomin

DataDirect OpenAccess SDK Help

OASQLIP_start_transaction

  • Last Updated: May 12, 2026
  • 1 minute read
    • OpenAccess SDK
    • Version 8.1
    • Documentation

This function starts a new transaction on the specified connection in response to a request for an explicit start transaction by the client. The IP must ensure that a transaction is always active on a connection. This function is not called for an implied transaction that is always open on a connection after a connection is opened or after a commit on a top-level transaction.

If nested transactions are supported, then this function is called when the client has made a start transaction API call. If you do not want to support nested transactions, return a OADS_ERROR when this function is called. When a commit is called, you must commit on the current nested level and set the current transaction to the previous level. If a commit is called for the top-level transaction, then you must commit and then start a new high-level transaction because a call to OASQLIP_start_transaction will not be made.

int OASQLIP_start_transaction(
SQLIP_HDBC sqlip_hdbc, 
int iExplicitFlag,
intisoLevel)

Parameters for OASQLIP_start_transaction

Parameter Type Description
INPUT    
sqlip_hdbc SQLIP_HDBC Connection handle of the IP
iExplicitFlag int For nested transaction, this value is set to 1.
isoLevel int Isolation level for this transaction.  
RETURN    
  int OADS_SUCCESS
OADS_ERROR
TitleResults for “How to create a CRG?”Also Available inAlert