ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-72
PROFILE Statements
To execute MODIFY PROFILE, you must be authorized to modify the system catalog.
profile-name
specifies the profile you want to modify. For a description of the MODIFY PROFILE
parameters, see the ADD PROFILE statement.
Considerations – MODIFY PROFILE
The MODIFY PROFILE statement:
•
Modifies the entry for the specified profile name in the ZNSPROF table
•
Generates an error if the profile name is referenced in any logical username record
in ZNSUS
•
Generates a warning if database-name, schema-name, trace-name,
gov-name, or control-name cannot be found in the appropriate mapping table
•
Generates an error if you are not authorized to modify the system catalog
•
Generates an error if the system catalog is not customized for the NonStop ODBC
Server
Example
MODIFY PROFILE SQL_DIALECT TDM_TSQL SQL_UNSUPPORTED W
MODIFY 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 { N | Y | S } ]
[ STMT_CACHE_LEVEL cache-level ]
[ CON_MODE_ON { Y | N } ]
[ CON_NAME control-name ]
[ CLOSE_TABLES_PER_SESSION { Y | N } ]
[ UPDATE_SYSTEM_CONFIG ]