Data Set Options for Relational Databases |
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 |
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.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.