Previous Page | Next Page

Data Set Options for Relational Databases

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.
Default value: 1024
Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
DBMS support: Aster nCluster, DB2 under UNIX and PC Hosts, Greenplum, HP Neoview, Microsoft SQL Server, MySQL, Netezza, ODBC, OLE DB, Oracle, Sybase, Sybase IQ

Syntax
Syntax Description
Details
See Also

Syntax

DBMAX_TEXT=integer

Syntax Description

integer

is a number between 1 and 32,767.


Details

This option applies to appending and updating rows in an existing table. It does not apply when creating a table.

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.


See Also

To assign this option to a group of relational DBMS tables or views, see the DBMAX_TEXT= LIBNAME Option.

Previous Page | Next Page | Top of Page