DBMAX_TEXT_TYPES= LIBNAME Statement Option

Specifies whether the DBMAX_TEXT= LIBNAME option is applied to all character types or only "long" data types.

Valid in: SAS/ACCESS LIBNAME statement
Category: Variable Control
Default: LONG
Data source: Hadoop, JDBC, Spark
Note: Support for this option was added in SAS 9.4M9.
See: DBMAX_TEXT= LIBNAME statement option, DBMAX_TEXT_TYPES= data set option

Syntax

DBMAX_TEXT_TYPES=LONG | ALL

Optional Arguments

ALL

specifies that the DBMAX_TEXT= LIBNAME option applies to columns of the STRING, CHAR, and VARCHAR data types.

LONG

specifies that the DBMAX_TEXT= LIBNAME option applies to columns of the STRING data type.

Details

By default, the DBMAX_TEXT= LIBNAME option applies to STRING columns.

Example

This Hadoop LIBNAME statement specifies that the DBMAX_TEXT= LIBNAME option applies to columns of the STRING, CHAR, and VARCHAR data types.

libname x hadoop user='user-name' 
pwd='password'
server='hive-server' 
dbmax_text_types=all;
Last updated: February 3, 2026