skip to main content
Interface Provider API : Reference : OAIP_ddl
 

OAIP_ddl

This function must be implemented by the IP, if the IP is to handle the DDL SQL syntax for creating tables, indexes, and other supported objects. This means that the OpenAccess SDK SQL engine calls this function anytime it needs to create or delete an object (for example, a table). The GETSUPPORT function should return true for the supported DDL operations.
int OAIP_ddl(
    IP_HDBC hdbc,
    DAM_HSTMT hstmt,
    int iType,
    int64 * piNumResRows)
Table 5. Parameters for OAIP_ddl
Parameter
Type
Description
IN
hdbc
IP_HDBC
The connection handle as defined by the IP.
hstmt
DAM_HSTMT
The statement handle of the currently active statement.
iType
int
The type of object management requested:
DAM_CREATE_TABLE - create a table.
DAM_CREATE_VIEW - create a view.
DAM_DROP_TABLE - drop a table.
DAM_DROP_VIEW - drop a view.
DAM_CREATE_INDEX - create an index.
DAM_DROP_INDEX - drop an index.
OUT
piNumResRows
int64 *
The number of rows affected by this operation.
RETURN
int
DAM_SUCCESS - on success
DAM_FAILURE - on failure
Refer to "DDL - Object Management" in the OpenAccess SDK SQL Engine Programmer's Guide for more information.