OmniAccess API

Introduction

Software Installation

Concepts and Design

Designing Applications

Troubleshooting Guide

Appendix

Convert Data Types Through oaSelect_List

To declare a select item as a different type than its default or defined type in the Omnidex environment catalog, you must pass its new type through the oaselect_list parameter of oabind.

The datatype element contains an integer value representing the default data type. To convert the data into a different data type, specify an integer value representing the data type you want in the req_datatype element. See oaSelect_List.

The integer values and their corresponding data types are shown below.

Connect to an Environment

Open a Cursor

Manage Data Across Cursors

Manage Large Lists of Records

Convert Data Types

Undetermined Criteria

100	CHAR	1008	ASCII DATE
201	C STRING	1009	DB2 DATE
300	[SIGNED] INTEGER	1099	OMNIDEX DATE
400	UNSIGNED INTEGER	1100	TIME
500	BOOLEAN	1101	ODBC TIME
501	BITMAP	1102	DB2 TIME
600	FLOAT	1199	OMNIDEX TIME
601	HP REAL or HP FLOAT	1200	DATETIME
602	D FLOAT	1201	VMS_DATETIME
603	G FLOAT	1202	ORACLE_DATETIME
604	F FLOAT
700	PACKED	1205	C_DATETIME
800	[RIGHT OVERPUNCH] ZONED	1206	INFORMIX DATETIME
801	LEFT ASCII OVERPUNCH ZONED	1207	ODBC DATETIME
802	RIGHT SEPARATE ZONED	1208	DB2 DATETIME
803	LEFT SEPARATE ZONED	1299	OMNIDEX DATETIME
804	UNSIGNED ZONED	1501	ORACLE ROWID
805	RIGHT ASCII OVERPUNCH ZONED	1502	RMS ROWID
806	LEFT ASCII OVERPUNCH ZONED	1503	IMAGE ROWID
900	RADIX50	1504	FLATFILE ROWID
1000	DATE	1506	INFORMIX ROWID
1001	INFORMIX_DATE	1507
1002	PH_DATE	1508	ISAM ROWID
1003	ASK_DATE	1509	CISAM ROWID
1004	J_DATE	1510	ODBC ROWID
1005	MM_DATE	1511	DISAM ROWID
1006	RSI DATE	1512	DB2 ROWID
1007	ODBC DATE	1600	RECNO

top

DISC | Documentation Home