Setting Up to Implement an IP
Requirements for link edit and compiling an IP
Setting up IP source and schema
Setting up an OpenAccess SDK service and data source for your IP
Connecting to your data source
Interface Provider API
Overview
Reference
OAIP_connect, OAIP_connectW
OAIP_connect (8-bit character version)
OAIP_connectW (Unicode version)
Using COM Objects from the IP
Supporting Failover and Load Balancing
OAIP_dcl
OAIP_ddl
OAIP_disconnect
OAIP_endTransaction
OAIP_execute
OAIP_execute_dataTypes
OAIP_exit
OAIP_getDSInfo
OAIP_getInfo
OAIP_GetLongData
OAIP_getSupport
OAIP_init
OAIP_init_scalar
OAIP_native and OAIP_nativeW
OAIP_native (8-bit character version)
OAIP_nativeW (Unicode version)
OAIP_privilege and OAIP_privilegeW
OAIP_procedure
OAIP_procedure_dynamic
OAIP_schema and OAIP_schemaW
OAIP_schemaEx, OAIP_schemaExW
OAIP_setInfo
OAIP_startTransaction
IP_FUNC_XXX
OpenAccess SDK SQL Engine Core Functions API
Memory management
OAIP_init
OAIP_connect, OAIP_connectW
OAIP_schema, OAIP_schemaW
OAIP_execute
OAIP_ddl
OAIP_procedure
Exchanging data
Working with rows
Getting column handles
Data types
Custom scalar functions
dam_add_custom_scalar
dam_add_custom_scalarEx2
dam_getSetOfCustomConditionLists
dam_describeCustomCond
dam_describeCustomCondEx2
Using custom scalar functions in a WHERE clause
Using custom scalar functions with a C/C++ IP
Function Reference
Unicode and non-Unicode Differences
dam_add_damobj_column
dam_add_damobj_fkey
dam_add_damobj_proc
dam_add_damobj_proc_column
dam_add_damobj_stat
dam_add_damobj_table
dam_addBlockValuesToArray
dam_addCharValToRow
dam_addColAliasValToRow
dam_addError/dam_addErrorW
dam_addErrorEx/dam_addErrorExW
dam_addJoinRowSet
dam_addLOBLocatorValToRow
dam_addOutputRow
dam_addRowToRowSet
dam_addRowToTable
dam_add_scalar
dam_add_scalarEx
dam_add_scalarEx2
dam_addValToArray
dam_addValToRow
dam_allocArray
dam_allocOutputRow
dam_allocRow
dam_allocRowSet
dam_clearError
dam_compareCol
dam_copyRow
dam_createVal
dam_describeCol
dam_describeColDetail
sql_xo_type
dam_describeColResAlias
dam_describeColScalar
dam_describeColScalarEx2
dam_describeCondEx
dam_describeIndex
dam_describeIndexCol
dam_describeJoinCond
dam_describeJoinTable
dam_describeProcedure/dam_decribeProcedureW
dam_describeScalar
dam_describeScalarEx
dam_describeScalarEx2
dam_describeTable/dam_describeTableW
dam_describeTableByProcessOrder/ dam_describeTableByProcessOrderW
dam_describeTableCorrelationName/ dam_describeTableCorrelationNameW
dam_describeTableFunction/dam_describeTableFunctionW
dam_describeView/dam_describeViewW
dam_evaluateColCond
dam_freeRow
dam_FreeRowSet
dam_freeVal
dam_freeSetOfConditionList
dam_getBulkRowStatusArray
dam_getBulkValueToSet
dam_getCol/dam_getColW
dam_getColByNameAndType/ dam_getColByNameAndTypeW
dam_getColByNum
dam_getColCount
dam_getColInCond
dam_getColOption
dam_getColToSet
dam_getFirstCol
dam_getFirstComment/dam_getFirstCommentW
dam_getFirstCond
dam_getFirstCondList
dam_getFirstGrantedObject/dam_getFirstGrantedObjectW
dam_getFirstGrantee/dam_getFirstGranteeW
dam_getFirstIndexCol
dam_getFirstInsertRow
dam_getFirstPrivilege/dam_getFirstPrivilegeW
dam_getFirstSchemaObject
dam_getFirstValExp
dam_getFirstValueSet
dam_getFirstView
dam_getGroupByCol/dam_getGroupByColW
dam_getInfo
dam_getIP_hcol
dam_getInputRow
dam_getIP_hstmt
dam_getJoinColValue
dam_getJoinQuery
dam_getMemTree
dam_getNextCol
dam_getNextComment/dam_getNextCommentW
dam_getNextCond
dam_getNextCondList
dam_getNextGrantedObject/dam_getNextGrantedObjectW
dam_getNextGrantee/dam_getNextGranteeW
dam_getNextIndexCol
dam_getNextInsertRow
dam_getNextJoinStmt
dam_getNextPrivilege/dam_getNextPrivilegeW
dam_getNextSchemaObject
dam_getNextValExp
dam_getNextValueSet
dam_getNextView
dam_getOptimalIndexAndConditions
dam_getOrderByCol
dam_getOriginalQueryParamCount
dam_getOriginalQueryParamValue
dam_getQuery
dam_getQueryFirstResultValue
dam_getQueryNextResultValue
dam_getRestrictionList
Usage
dam_getRole and getRoleW
dam_getSchemaObjectList
dam_getSetOfConditionListsEx
dam_getTableSearchExp
dam_getTableStmt
dam_getTableFunctionArgList
dam_getUpdateRow
dam_getUpdateRowAsExp
dam_getUser/dam_getUserW
dam_getValueOfExpEx
dam_getValueToSet
dam_getValueTypeOfExp
dam_getViewQuery
dam_isSearchPatternObject
dam_isSchemaTableFunction/ dam_isSchemaTableFunctionW
dam_isTableFunction
dam_isTargetRow
dam_isTargetRowForConditionList
dam_setInfo
dam_setIP_hcol
dam_setIP_hstmt
dam_setJoinOrder
dam_setOption
Connection Options
Statement Options
Condition List Options
dam_strlikecmp
SQL Engine Parse Tree API
Pass-through query processing
SQL Engine Parse Tree functions reference
damex_addColValToRow
damex_addResValToRow
damex_addRowToTable
damex_allocRow
damex_describeCaseElem
damex_describeCaseValExp
damex_describeCol
damex_describeDataChainVal
damex_describeDeleteQuery
damex_describeInsertQuery
damex_describeLogicExp
damex_describeOrderByExp
damex_describeParamVal
damex_describeScalarValExp
damex_describeScalarValExpEx2
damex_describeSelectQuery
damex_describeSelectTopClause
damex_describeTable/damex_describeTableW
damex_describeTableJoinInfo
damex_describeTableFunction/ damex_describeTableFunctionW
damex_describeUnionQuery
damex_describeUpdateQuery
damex_describeVal
damex_describeValExp
damex_ describeValExpEx
damex_FreeRow
damex_getCol and damex_getColW
damex_getColByNum
damex_getFirstCaseElem
damex_getFirstCol
damex_getFirstColInList
damex_getFirstInsertRow
damex_getFirstInsertValueExp
damex_getFirstTable
damex_getFirstTableQueryVal
damex_getFirstUpdateSet
damex_getFirstValExp
damex_getNextCaseElem
damex_getNextCol
damex_getNextColInList
damex_getNextInsertRow
damex_getNextInsertValueExp
damex_getNextTable
damex_getNextTableQueryVal
damex_getNextUpdateSet
damex_getNextValExp
damex_getParentQuery
damex_getQuery
damex_getQueryType
damex_getSetOfConditionLists
damex_getTable/damex_getTableW
damex_getTableByNum
damex_isCorrelatedCol
damex_isTableSubQuery
General Support API
Memory allocation functions
Trace Function
tm_trace
tm_dumpHex
Setting Up the Samples
Description of the samples
C: example1
C++: example2
C: example3
C: memory
Setting up an example on Windows
Setting up a sample on Linux/UNIX
Embedding Server in C/C++ Applications
C API
server_start
server_stop
Sample for Windows
Files for embedding in C/C++ applications
Running C/C++ sample
Compiling C/C++ sample
Running C/C++ sample
Sample for UNIX
Files for embedding in C/C++ applications
Building C/C++ sample
Running C/C++ sample
Remarks
Setting Up to Implement an IP
Remarks