DISC

Contents | What's New | Quick Links

 

OmniAccess API

Introduction

Software Installation

Concepts and Design

Designing Applications

Omnidex Environments

SQL Reference

Omnidex API's

Utilities

Interfaces

Performance Guide

Troubleshooting Guide

Appendix

 

 

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.

Syntax

Options

Example

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 datatype conversions are the final operation in a select; therefore sorting operations will be based on the internal datatype of the column rather than the converted datatype, 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.

 

top

 

Options

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

 

top

 

Example

 

 

top

Dynamic Information Systems Corporation - Omnidex Version 3.8 Build 6 J15.03-Copyright © 2003

DISC | Documentation Home