Specifies whether the DBMAX_TEXT= data set option is applied to all character types or only "long" data types.
| Valid in: | DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software) |
|---|---|
| Category: | Variable Control |
| Default: | LONG |
| Data source: | Hadoop, JDBC, Spark |
| Note: | Support for this data set option was added in SAS 9.4M9. |
| See: | DBMAX_TEXT= data set option, DBMAX_TEXT_TYPES= LIBNAME option |
Table of Contents
specifies that the DBMAX_TEXT= LIBNAME option applies to columns of the STRING, CHAR, and VARCHAR data types.
specifies that the DBMAX_TEXT= LIBNAME option applies to columns of the STRING data type.
By default, the DBMAX_TEXT= data set option applies to STRING columns.
In this example, X is a HADOOP LIBNAME statement and NAME is a STRING column in Hive. Column NAME will be shortened to 255 bytes when it is created as a CHAR column in the Work.Customer data set.
proc sql;
create table work.customer
(dbmax_text=255 dbmax_text_types=all) as
select name, age from x.class;
quit;