Data Type Summary

Reference: Metadata Descriptions Example: Retrieving CLOBs Retrieving BLOB Values

These metadata descriptions define the data type descriptions currently available in the server environment. This does not mean that data types outside of these categories are not supported; rather, the descriptions indicate that data types existing in the various DBMS formats will be mapped internally to one of these categories. See the iWay Server Administration manual for information on specific DBMS data type support.

Reference: Metadata Descriptions

Code	Data Type	Metadata Description	Maximum Length	Scale
0	Unknown*	U	N	N
1	Integer	I	1	N
2	Single Float	F	9	Y
3	Double Float	D	20	Y
4	Decimal	P	31	Y
5	Alphanumeric	A	32,000	N
6	Binary (15)	B	4,000	N
7	Date	YYMD	10	N
8	Text	TX	N	N
9	Graphic (DBCS)	K	32,000	N
10	Binary LOB	BLOB	N	N
11	Character LOB	CLOB	2,147,483,647	N
13	Time	Time	6	N
14	Time Stamp	Time Stamp	20	N
15	Variable length character	AnV	32,768	N

Note: *These data types are not supported in the server environment.

Example: Retrieving CLOBs

To retrieve Character Large Object (CLOB) values, the following setting is required in a server profile:

SQL SET <DBMS> CONVERSION LONGCHAR CLOB

Example: Retrieving BLOB Values

To retrieve Binary Large Object (BLOB) values, the following setting is required in a server profile:

SQL SET <DBMS> CONVERSION LONGCHAR BLOB

See the iWay Server Administration manual for your specific platform for information on specific DBMS data type support.