| The LIBNAME Statement for Relational Databases |
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.
| Default value: |
1024
|
| Valid in: |
SAS/ACCESS LIBNAME
statement
|
| DBMS support: |
Aster nCluster, DB2 under
UNIX and PC Hosts, Greenplum, HP Neoview, MySQL, Microsoft SQL Server, Netezza,
ODBC, OLE DB, Oracle, Sybase, Sybase IQ
|
-
integer
-
is an integer between 1 and 32,767.
This option applies to reading, appending,
and updating rows in an existing table. It does not apply when you are creating
a table.
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 CHAR, VARCHAR2, CLOB, and LONG
data types.
To apply this option to an individual data set, see
the DBMAX_TEXT= Data Set Option.
Copyright © 2010 by SAS Institute Inc., Cary, NC, USA. All rights reserved.
