ODBC Server Reference Manual

Contents
HP NonStop ODBC Server Reference Manual—429151-002
xi
8. HP NonStop ODBC Server Mapping
Tables (continued)
8. HP NonStop ODBC Server Mapping Tables (continued)
Default Values for NonStop ODBC Server Attributes 8-4
Table Mapping Security 8-5
Table Relationships 8-6
Data Types 8-7
Restoring Tables 8-7
Database and Object Mapping 8-8
ZNSALT (For Alternate Usernames) 8-11
ZNSCON (For Control Statements) 8-12
ZNSDB (For NonStop ODBC Server Databases) 8-13
ZNSDEF (For NonStop ODBC Server DEFINEs) 8-14
ZNSDUMMY (For Use With DLIB Applications) 8-15
ZNSGOV (For Governing Policies) 8-16
ZNSMSG (For Error Messages) 8-18
ZNSNET (For Network Service Specifications) 8-20
ZNSPROF (For Profile Values) 8-22
ZNSPROT (For User Permission Data) 8-27
ZNSSCFG (For System Configuration Values) 8-28
ZNSSCS (for SQL Communication Subsystem Specifications) 8-32
ZNSSER (For NonStop ODBC Server Process Definitions) 8-34
ZNSSMAP (For Server Class to SCS Description Mapping) 8-36
ZNSTRA (For Trace Data) 8-37
ZNSUMAP (For User and Profile Name to Server Class Mapping) 8-39
ZNSUS (For Logical Username to Guardian Username Mapping) 8-40
ZNSVALUE (For ODBC or SQL Server spt_values Support) 8-41
ZNUDT (For Data Types Mapping) 8-42
ZNUIX (For Logical Index Names to Guardian Names Mapping) 8-44
ZNUMTRX (For Resource Accounting Log Data) 8-45
ZNUOBJ (For Logical Object Names Mapping) 8-51
ZNUPCOL (For Stored Procedure Parameters and Results) 8-53
ZNUPROC (For Stored Procedure Attributes) 8-55
ZNUQST (For Query Status Data) 8-57
ZNUTRA (For Trace Records Logging) 8-59
System Table Mapping 8-60
SQLColumns Procedure (ZVUOCOL) 8-60
SQLProcedureColumns Procedure (ZVUPCOL) 8-61
SYSCOLUMNS Catalog View (ZVUCOL) 8-62
SYSDATABASES Catalog View (ZVSDB) 8-63
SYSINDEXES Catalog View (ZVUIX) 8-64