OAIP_getSupport

This function returns the requested information type in the buffer pInfoValue. This function is used by the OpenAccess SDK SQL engine to query the IP about its support for the types of SQL operations allowed, the mode in which the IP is working, whether DCL is supported, and other features.

The information reported by this function defines the mode in which the OpenAccess SDK SQL engine operates and how it interacts with the IP. It is called after OAIP_init, and may be called multiple times among other IP API calls.

int OAIP_getSupport(
    IP_HDBC  hdbc, 
    int      iSupportType, 
    int   *  piSupportExists)

Parameters for OAIP_getSupport

IP Support Options

The value for the IP_SUPPORT_OP_XX is the logical OR of the setting returned by this function and the setting in the OA_SUPPORT column of the OA_COLUMNS table for the specified column.

The value for the IP_SUPPORT_SELECT, IP_SUPPORT_INSERT, IP_SUPPORT_UPDATE, IP_SUPPORT_DELETE and IP_SUPPORT_SELECT_FOR_UPDATE is the logical OR of the setting returned by this function and the setting in the OA_SUPPORT column of the OA_TABLES table for the specified table name.

One way to implement this feature, and the template uses this approach, is to set up an array as shown in the following example, and to use the iSupportType as an index into it.

Example

const IP_SUPPORT_ARRAY    xxx_support_array =
        {0,
        1, /* IP_SUPPORT_SELECT */
         0, /* IP_SUPPORT_INSERT */
        0, /* IP_SUPPORT_UPDATE */
        0, /* IP_SUPPORT_DELETE */
        1, /* IP_SUPPORT_SCHEMA */ /* value is controlled by ip_getSupport */
        1, /* IP_SUPPORT_PRIVILEGES  */
        1, /* IP_SUPPORT_OP_EQUAL */
        0, /* IP_SUPPORT_OP_NOT   */
        0, /* IP_SUPPORT_OP_GREATER */
        0, /* IP_SUPPORT_OP_SMALLER */
        0, /* IP_SUPPORT_OP_BETWEEN */
        0, /* IP_SUPPORT_OP_LIKE    */
        0, /* IP_SUPPORT_OP_NULL    */
        0, /* IP_SUPPORT_SELECT_FOR_UPDATE */
        0, /* IP_SUPPORT_START_QUERY */
        0, /* IP_SUPPORT_END_QUERY */
        0, /* IP_SUPPORT_UNION_CONDLIST */
        1, /* IP_SUPPORT_CREATE_TABLE */
        1, /* IP_SUPPORT_DROP_TABLE */
        1, /* IP_SUPPORT_CREATE_INDEX */
        1, /* IP_SUPPORT_DROP_INDEX */
        1, /* IP_SUPPORT_PROCEDURE */
        0, /* IP_SUPPORT_CREATE_VIEW */
        0, /* IP_SUPPORT_DROP_VIEW */
        0, /* IP_SUPPORT_QUERY_VIEW */
        1, /* IP_SUPPORT_CREATE_USER */
        1, /* IP_SUPPORT_DROP_USER */
        1, /* IP_SUPPORT_CREATE_ROLE */
        1, /* IP_SUPPORT_DROP_ROLE */
        1, /* IP_SUPPORT_GRANT */
        1, /* IP_SUPPORT_REVOKE */
        0, /* IP_SUPPORT_PUSHDOWN_QUERY */
        1, /* IP_SUPPORT_NATIVE_COMMAND */
        1, /* IP_SUPPORT_ALTER_TABLE */
        0, /* IP_SUPPORT_QUERY_MODE_SELECTION */
        0, /* IP_SUPPORT_VALIDATE_SCHEMAOBJECTS_IN_USE */
        0, /* IP_SUPPORT_UNICODE_INFO */
        0, /* Reserved for future use */
        0, /* Reserved for future use */
        0, /* Reserved for future use */
        0, /* Reserved for future use */
        0, /* Reserved for future use */
        0, /* Reserved for future use */
        0, /* Reserved for future use */
        0, /* Reserved for future use */
        0, /* Reserved for future use */
        0, /* Reserved for future use */
        };