ALLOWED_SQLCODES= LIBNAME Statement Option

Specifies the SQL warnings and errors to ignore during preparation, execution, and fetch operations.

Valid in: SAS/ACCESS LIBNAME statement
Category: Data Set Control
Default: none
Requirement: You must separate multiple values with commas and enclose the entire list in parentheses. Use double quotation marks around each value in the list.
Data source: DB2 under z/OS
Example:
libname x db2 allowed_sqlcodes=("144","-803") ssid=DB2;

Table of Contents

Syntax

ALLOWED_SQLCODES=("sqlcode"<, "sqlcode"<, "sqlcode" ...>>)

Syntax Description

sqlcode

specifies one or more values that you want to control. These values subsequently do not appear in the log.

Details

Use this option to pass a list of specific warnings and errors for the SAS/ACCESS engine to ignore. This is helpful to allow execution to continue for errors or warnings that are for informational purposes only.

Last updated: February 3, 2026