Altering LONG data types to VARCHAR data types

To enable insert and update operations for LONG data types, you can alter the LONG data types to the VARCHAR data type.

Table 1 lists the long data type by data source that you can alter.

Table 1. LONG data types by data source that can be altered to the VARCHAR data type
Data source	Remote data type	Length	Local default data type	ALTER to VARCHAR
DRDA	LONG VARCHAR	1–32672	CLOB	VARCHAR
	LONG VARCHAR FOR BIT DATA	1–32672	BLOB	VARCHAR FOR BIT DATA
Informix®	BYTE	1–32672	BLOB	VARCHAR FOR BIT DATA
	TEXT	1–32672	CLOB	VARCHAR
Microsoft SQL Server	IMAGE	1–32672 host vars; 1–8000 literal	BLOB	VARCHAR FOR BIT DATA
	TEXT	1–32672 host vars; 1–8000 literal	CLOB	VARCHAR
Oracle NET8	LONG	1–32672 host vars; 1–4000 literal	CLOB	VARCHAR
	LONG RAW	1–32672 host vars; 1–4000 literal	BLOB	VARCHAR FOR BIT DATA
Sybase CTLIB	IMAGE	1–32672	BLOB	VARCHAR FOR BIT DATA
	TEXT	1–32672	CLOB	VARCHAR
Teradata	BYTE	32673–64000	BLOB	VARCHAR FOR BIT DATA(32672)
	CHAR	32673–64000	CLOB	VARCHAR(32672)
	VARBYTE	32673–64000	BLOB	VARCHAR FOR BIT DATA(32672)
	VARCHAR	32673–64000	CLOB	VARCHAR(32672)