ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-70
PROFILE Statements
SQL_UNSUPPORTED { E | W | I }
specifies the action taken by the parser/translator when it detects a syntax error for
dialect conflicts or nonconforming syntax:
This option can be useful in speeding up processing in situations where it is safe to
ignore syntax errors resulting from features not supported by the NonStop ODBC
Server, such as GRANT/REVOKE.
OBJ_NAME_CACHE
specifies the cache behavior for object names:
If you store object names in cache indefinitely, existing rules for invalidating an
entry in the name cache due to nonexistence still apply.
STMT_CACHE_LEVEL
is reserved for future use.
CON_MODE_ON { Y | N }
specifies whether to use an existing control statement entity in this profile:
CON_NAME control-name
specifies the name of an existing control statement entity to include in this profile;
control-name is an alphanumeric string up to 60 characters in length. It must
begin with an alphabetic character, followed by alphabetic, numeric, and
underscore characters.
1 SQL_TXN_READ_COMMITTED STABLE
2 SQL_TXN_REPEATABLE_READ REPEATABLE
3 SQL_TXN_SERIALIZABLE REPEATABLE (serializable)
E Exceptions are to be reported as errors.
W Exceptions are to be reported as warnings.
I Exceptions are not to be reported (that is, ignored)
Y Store object names in cache indefinitely.
N Do not to store object names in cache.
S Store object names in cache only during the current session.
Y Use the control statement entity you specify in control-name.
N Do not use a control statement entity.