Functions

OABIND

oabind lets you convert the data type and length of select items returned by a previous oaselect. This binds the type and length of the select items for subsequent OmniAccess operations for that cursor.

For example, if the second select item was a 32-bit integer and you convert it to a 12-byte character column, it is returned as a 12-byte character value for all subsequent oafetch and oaexport (with the DATA option) operations.

oabind establishes how data is returned for subsequent oafetches, oafetchkeys, or oaexports within a specified cursor. It determines what columns or data values (select items) are returned, as well as the data type and length of each column or value. oabind lets you override the default data type of a select item specified in the columns parameter of oaselect; that is, oabind lets you convert data returned by OmniAccess.

oabind data type conversions are the final operation in a select; therefore sorting operations will be based on the internal data type of the column rather than the converted data type, which may alter a chronological sort.

You can use oadescribe to return much of the information required by oabind.

Syntax

oabind establishes how data is returned for subsequent oafetches, oafetchkeys, or oaexports within a specified cursor. It determines what columns or data values (select items) are returned, as well as the data type and length of each column or value. oabind lets you override the default data type of a select item specified in the columns parameter of oaselect; that is, oabind lets you convert data returned by OmniAccess.

oabind data type conversions are the final operation in a select; therefore sorting operations will be based on the internal data type of the column rather than the converted data type, which may alter a chronological sort.

You can use oadescribe to return much of the information required by oabind.

Syntax

int oabind (cursor, *options, *status, num_columns, *select_list);

cursor -- Cursor is a 32-bit signed integer passed by value. This is the value returned by a successful call to oaopencursor. Cursor represents the retrieval environment to which the requested conversion applies.

options -- Options is currently reserved and must contain a semicolon or a null character passed by reference.

status -- Indicates the success or failure of the oabind routine. A zero status.error means a successful oabind. See Status Structure.

num_columns -- num_columns contains the number of columns or select items to return for the current cursor. Num_columns is a 32-bit signed integer passed by value. The value of num_columns must be equal to status word 11 returned from the preceding call to oaselect.

oaselect_list -- oaselect_list is an array that contains a select item descriptor for each select item specified in the columns parameter of the preceding call to oaselect. The number of entries in the select item list array is specified in num_columns.

Options

There are currently no options available for use with oabind. Support was added for future enhancements.

Example

Top