HP MPE/iX 6.x Operating System manual Supported Data Types, Sqldecimal

Application Development ODBCLink/SE Reference Manual

Supported Data Types

The following is a table of correspondence between HP data types and ODBC data types.

ALLBASE/SQL or Image or IMAGE/SQL Data Type

ODBC Data Type

Comments

CHAR, max length <255		SQL_CHAR
CHAR, max length >=255		SQL_LONGVARCHAR
VARCHAR, max length <255		SQL_VARCHAR
VARCHAR, max length >=255		SQL_LONGVARCHAR
BINARY, length <256		SQL_BINARY
BINARY, length >=256		SQL_LONGVARBINA
		RY
VARBINARY <256		SQL_VARBINARY
VARBINARY >=256		SQL-
		LONGVARBINARY
LONG BINARY		SQL_LONGVARBINA
		RY
LONG VARBINARY		SQL_LONGVARBINA
		RY
INTEGER (32-bit)		SQL_INTEGER
DECIMAL	(Internal	SQL_DECIMAL	Character representation with leading sign
representation is packed decimal)			and decimal point
Image Zoned (Z)		SQL_DECIMAL	Converted by Image/SQL
Image Packed (P)		SQL_DECIMAL	Converted by Image/SQL
Image I3 (48-bit integer)		SQL_DECIMAL	Converted by Image/SQL
Image I4 (64-bit integer)		SQL_DECIMAL	Converted by Image/SQL
FLOAT(24) or REAL or Image		SQL_REAL
E2
FLOAT(53) or	DOUBLE	SQL_DOUBLE
PRECISION or Image E4
Image R2 (non-IEEE float)		SQL_REAL	Converted by Image/SQL
Image R4 (non-IEEE float)		SQL_DOUBLE	Converted by Image/SQL

	ODBCLink/SE
34	©M.B. Foster Associates Limited 1995-2000