DBMAX_TEXT= LIBNAME Option

Determines the length of any very long DBMS character data type that is read into SAS or written from SAS when using a SAS/ACCESS engine.

Valid in:	SAS/ACCESS LIBNAME statement
Default:	1024
Restriction:	This option applies to appending and updating rows in an existing table. It does not apply when creating a table.
Data source:	Aster nCluster, DB2 under UNIX and PC Hosts, Greenplum, HP Neoview, MySQL, Microsoft SQL Server, Netezza, ODBC, OLE DB, Oracle, Sybase, Sybase IQ
See:	DBMAX_TEXT= data set option

Syntax

DBMAX_TEXT=<integer>

Examples of a DBMS data type are the Sybase TEXT data type or the Oracle CLOB (character large object) data type.

Oracle: This option applies for CLOB, BLOB, LONG, and LONG RAW data types.