ODBC Function
|
SQL IP Function
|
SQLConnect
|
OASQLIP_alloc_connect
OASQLIP_connect
|
SQLDisconnect
|
OASQLIP_disconnect
OASQLIP_free_connect
|
SQLExecDirect
|
OASQLIP_alloc_stmt
OASQLIP_set_stmt_info
if parameters, then
OASQLIP_init_param
OASQLIP_execute_direct_stmt
OASQLIP_get_numcols
OASQLIP_get_colspec...
If the statement returns 1 or more columns, which is the case for Select and stored procedure calls, then the following sequence is executed until OASQLIP_fetch_row indicates that it is at end of the current buffer or at the end of the result set.
OASQLIP_fetch_row
OASQLIP_get_colval
If end of the rowset is returned, then close the cursor.
OASQLIP_close_cursor
|
SQLExecute
|
OASQLIP_set_stmt_info
if parameters, then
OASQLIP_init_param
OASQLIP_execute_stmt
OASQLIP_get_numcols
OASQLIP_get_colspec...
If the statement returns one or more columns, which is the case for Select and stored procedure calls, the following sequence is executed until OASQLIP_fetch_row indicates that it is at end of the current buffer or at the end of the result set.
OASQLIP_fetch_row
OASQLIP_get_colval
If end of the rowset is returned, then close the cursor.
OASQLIP_close_cursor
|
SQLFetch
|
If the client side buffer is exhausted, then:
OASQLIP_get_numcols
OASQLIP_get_colspec...
If the statement returns > 0 columns, which is the case for Select and stored procedure calls, then the following sequence is executed until OASQLIP_fetch_row indicates that it is at end of the current buffer or at the end of the result set.
OASQLIP_fetch_row
OASQLIP_get_colval
If end of the rowset is returned, then close the cursor.
OASQLIP_close_cursor
|
SQLFreeStmt(SQL_CLOSE)
|
if cursor open,
OASQLIP_close_cursor
OASQLIP_free_stmt
|
SQLPrepare
|
OASQLIP_alloc_stmt
OASQLIP_set_connect_info
OASQLIP_prepare_stmt
OASQLIP_get_numparams
OASQLIP_get_numcols
if columns, then
OASQLIP_get_colspec...
OASQLIP_get_numparams
if parameters, then
OASQLIP_get_paramspec...
|