DBMAX_TEXT= Data Set Option

Determines the length of any very long DBMS character data type that is read into SAS or written from SAS when you are using a SAS/ACCESS engine.
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
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, Microsoft SQL Server, MySQL, Netezza, ODBC, OLE DB, Oracle, Sybase, Sybase IQ
See: DBMAX_TEXT= LIBNAME option

Syntax

DBMAX_TEXT=integer

Syntax Description

integer
is a number between 1 and 32,767.

Details

DBMAX_TEXT= is usually used with a very long DBMS character data type, such as the Sybase TEXT data type or the Oracle CLOB data type.
Oracle: This option applies for CHAR, VARCHAR2, CLOB, and LONG data types.
For SAS 9 or higher, this option applies for CHAR, VARCHAR2, CLOB, LONG, and LOB data types. However, because PROC ACCESS and PROC DBLOAD behavior has not changed since SAS 8, only LONG and LOB data types are valid if you use this option with those procedures.