Powered by Zoomin Software. For more details please contactZoomin

DataDirect OpenAccess SDK Help

OASQLIP_execute_direct_stmt

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

This function executes the specified SQL statement and returns the number of rows affected by it. This function has to perform operations of both prepare and execute (parse the given statement to generate a plan for statement execution and execute the plan) if the backend data source does not support immediate execution mode.

It is recommended that the IP create a new memory tree to be used for statement prepare and execution and free the tree after completion. This function is only called to execute statements that do not return results. The client maps all SQLExecDirect calls.

int OASQLIP_execute_direct_stmt(
SQLIP_HSTMT sqlip_hstmt, 
OASQLIP_CHAR psSqlStmt, 
int64 * piNumResRows)

Parameters for OASQLIP_execute_direct_stmt

Parameter Type Description
INPUT    
sqlip_hstmt SQLIP_HSTMT Statement handle
psSqlStmt OASQLIP_CHAR Null terminated SQL string.
OUTPUT    
piNumResRows int64 * Number of rows affected
RETURN    
  int OADS_SUCCESS OADS_ERROR
TitleResults for “How to create a CRG?”Also Available inAlert