ODBC Server Reference Manual

HP NonStop ODBC Server Mapping Tables
HP NonStop ODBC Server Reference Manual—429151-002
8-23
ZNSPROF (For Profile Values)
Table 8-12. Description of ZNSPROF (page1of4)
Column Name
Primary Key Unique Index
Data Type Description
PROFILE_NAME
x–
VARCHAR (60) User-defined profile name that is
unique in the system in which it
is defined.
DEFAULT_DATABASE
––
VARCHAR (60) Default database for object
qualification in the NonStop
ODBC server or in NOSUTIL for
the user who indicates this
profile.
Internal default is MASTER,
which allows initialization to a
NonStop ODBC Server
customized database without
requiring direct user action
during the user session.
DEFAULT_SCHEMA
––
VARCHAR (60) Default schema name for object
qualification (owner) in the
NonStop ODBC server or in
NOSUTIL for the user indicating
this profile. This value affects
only schema unqualified object
references; it does not override
an application-provided schema
qualifier.
If blank (length 0), object
qualification uses the
NOS_USERNAME value
determined at login.
x Indicates the column is part of the primary key or is a unique index
– Indicates the column is not part of the primary key or is not a unique index