ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-67
PROFILE Statements
schema-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.
The default for this parameter is the logical username of the current user.
DEFAULT_LOCATION network-volume
specifies the default location of objects created using this profile;
network-volume is an alphanumeric string up to 60 characters in length and
must be a valid Guardian volume name in the following format:
[\node.]$volume
If you omit network-volume, objects are placed in the subvolume where the
catalog for the current database resides.
DEFAULT_SECURITY security-string
is a four-character alphabetic string that specifies the Guardian read, write,
execute, and purge (RWEP) access for NonStop SQL/MP objects created by a
user with this profile. This value affects CREATE DATABASE, CREATE TABLE,
CREATE VIEW, and CREATE INDEX statements. The default is the default
Guardian security for the current user.
For more information about security for NonStop SQL/MP objects, see the
“Security” entry in the NonStop SQL/MP Reference Manual.
TRA_MODE_ON { Y | N }
specifies whether to use an existing trace entity in this profile:
TRA_NAME trace-name
specifies the name of an existing trace entity to include in this profile; trace-name
is an alphanumeric string up to 60 characters in length. It must begin with an
alphabetic character, followed alphabetic, numeric, and underscore characters.
If the trace entity you specify for trace-name does not already exist, tracing
features are not enabled for this profile. See ADD TRACE on page 7-109 to learn
how to create a new trace entity.
The NonStop ODBC Server uses the trace entity you specify only if you also
specify a value of Y for the TRA_MODE_ON keyword.
Y Perform tracing using the existing trace entity specified in trace-name.
N Do not perform tracing for this profile.