Data Set Options for Relational Databases DBMAX_TEXT= Data Set Option 181
select * from ora.bigtab(dbmaster=yes), db2.smalltab
bigtab.x=smalltab.x;
Details
This option can be used with the MULTI_DATASRC_OPT= option to specify which table
reference in a join is the larger table. This can improve performance by eliminating the
processing normally performed by the software to determine this information. The
specification of this option will be ignored, however, during the processing of any outer
joins.
See Also
“MULTI_DATASRC_OPT= LIBNAME Option” on page 108
DBMAX_TEXT= Data Set Option
Determines the length of a 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)
DBMS support: DB2 UNIX/PC, ODBC, OLE DB, Oracle, Microsoft SQL Server, SYBASE
Default value:
1024
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 LONG RAW data type.
See Also
To assign this option to a group of relational DBMS tables or views, see the
LIBNAME option “DBMAX_TEXT= LIBNAME Option” on page 92.
