ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-66
PROFILE Statements
ADD PROFILE
The ADD PROFILE statement defines the configuration of a new named profile. To
execute ADD PROFILE, you must be a privileged user.
profile-name
specifies the profile to create; profile-name is an alphanumeric string up to 60
characters. It must begin with an alphabetic character, followed by alphabetic,
numeric, and underscore characters in length. The name must be unique.
DEFAULT is reserved for the profile of the DEFAULT server class.
DEFAULT_DATABASE database-name
specifies the default NonStop ODBC Server database for this profile;
database-name is an alphanumeric string up to 60 characters in length. It must
match a valid entry in the ZNSDB mapping table. The default is MASTER.
DEFAULT_SCHEMA schema-name
specifies the default NonStop ODBC Server schema to use for qualifying object
references in a DML SQL statement. However, it cannot be used for the
qualification of the object name for DDL statements. These statements must
always use the authenticated process ID which is mapped as an ODBC user for
object qualification.
ADD PROFILE profile-name
[ DEFAULT_DATABASE database-name ]
[ DEFAULT_SCHEMA schema-name ]
[ DEFAULT_LOCATION network-volume ]
[ DEFAULT_SECURITY security-string ]
[ TRA_MODE_ON { Y | N } ]
[ TRA_NAME trace-name ]
[ ACC_MODE_ON { Y | N } ]
[ ACC_LOGTABLE_NAME acc-name ]
[ ACC_LEVEL { SESSION | SQL_STATEMENT } ]
[ GOV_MODE_ON { Y | N } ]
[ GOV_NAME gov-name ]
[ QST_MODE_ON { Y | N } ]
[ SQL_ACCESS_MODE { RO | RW } ]
[ SQL_CURSOR_MODE { RO | RW } ]
[ SQL_DIALECT { TDM_CORE | TDM_TSQL } ]
[ SQL_MAX_STATEMENT_CACHE user-statement-cache-limit ]
[ SQL_TXN_ISOLATION { 0 | 1 | 2 | 3 } ]
[ SQL_UNSUPPORTED { E | W | I } ]
[ OBJ_NAME_CACHE ]
[ STMT_CACHE_LEVEL ]
[ CON_MODE_ON { Y | N } ]
[ CON_NAME control-name ]
[ CLOSE_TABLES_PER_SESSION { Y | N } ]
[ UPDATE_SYSTEM_CONFIG ]