SAS/ACCESS Software for Relational Databases: Reference

SAS System Option for the Interface to CA-OpenIngres

When you use PROC ACCESS and PROC DBLOAD, you can still use the INGOPTS= system option to pass certain flags to the DBMS to override the default action. To pass these flags to the LIBNAME engine, you must use the CONN_OPTIONS= LIBNAME option. For a description of CONN_OPTIONS=, refer to CONN_OPTIONS=.

By default, CA-OpenIngres ignores exceptions and does not issue errors or warnings when arithmetic exceptions occur. By using the INGOPTS= option, you can specify whether you want exceptions handled as errors or warnings. The SAS/ACCESS interface view engine for CA-OpenIngres only supports the arithmetic handling mode flag -xk, where k can either be an f (fatal error) or a w (warning).

INGOPTS="INGARITH=-xf": handles exceptions as errors and the transaction is not completed.
INGOPTS="INGARITH=-xw": handles exceptions as warnings and the transaction is completed. This is the default action.

The INGOPTS= option can be included in a SAS configuration file, submitted on the SAS command line, or submitted from within the SAS System. For more information about options that set the arithmetic handling modes, refer to your CA-OpenIngres SQL reference manual.

Chapter Contents
Previous
Next
Top of Page