SQL_OJ_ANSI= LIBNAME Statement Option

Specifies whether to pass ANSI outer-join syntax through to the database.

Valid in: SAS/ACCESS LIBNAME statement
Default: Data Set Control
NO
Restriction: SAP ASE can process SQL outer joins only if the version of the Adaptive Server Enterprise (ASE) database is 12.5.2 or higher.
Data source: SAP ASE

Table of Contents

Syntax

SQL_OJ_ANSI=YES | NO

Syntax Description

YES

specifies that ANSI outer-join syntax is passed through to the database.

NO

disables pass-through of ANSI outer-joins.

Last updated: February 3, 2026