System Options for Relational Databases

Available System Options

Here are the available systems options.

No SAS/ACCESS interface support is available for the REPLACE= system option. (See SAS System Options: Reference.)

SAS System Options	Default
DB2CATALOG=	SYSIBM
DBFMTIGNORE	NODBFMTIGNORE
DBIDIRECTEXEC	NODBIDIRECTEXEC
DBSLICEPARM=	THREADED_APPS,2 [DB2 under z/OS, Oracle, and Teradata] THREADED_APPS,2 or THREADED_APP,3 [DB2 under UNIX and PC Hosts, Informix, Microsoft SQL Server, ODBC, and SAP ASE, SAP IQ]
DBSRVTP=	NONE
REPLACE=	No SAS/ACCESS interface support is available. See SAS System Options: Reference.
SASTRACE=	none
SASTRACELOC=	stdout
SQLGENERATION=	Specifies whether and when SAS procedures generate SQL for in-database processing of source data.
SQLMAPPUTTO=	Specifies whether the PUT function is mapped to the SAS_PUT() function for a database, possible also where the SAS_PUT() function is mapped.
VALIDVARNAME=	Controls the type of SAS variable names that can be used or created during a SAS session.

Last updated: February 3, 2026