ODBC Server Reference Manual

HP NonStop ODBC Server Mapping Tables
HP NonStop ODBC Server Reference Manual—429151-002
8-60
System Table Mapping
System Table Mapping
The NonStop ODBC Server maintains tables and views that correspond to the SQL
Server system tables. The prefix “SYS” indicates a view specific to TSQL that is
provided by the NonStop ODBC Server and corresponds to a TSQL system catalog
table or view.
When you specify a system table name, the NonStop ODBC Server searches the
object mapping table, ZNUOBJ, and locates the view name that corresponds to the
system table.
The subsections that follow list the view definitions for TSQL compatibility.
SQLColumns Procedure (ZVUOCOL)
The view ZVUOCOL satisfies the SQLColumns query for ODBC access. It translates
the column information in COLUMNS into the NonStop ODBC Server column
description form.
ZVUOCOL resides in both the subvolume of the system catalog and a customized user
catalog.
See also ZNUDT (For Data Types Mapping) on page 8-42 and SQLColumns on
page 7-122.
Table 8-29. Description of ZVUOCOL
Column Name
Column Name in ZNUDT,
ZNUOBJ, or COLUMNS Description
T_UNAME ZNUOBJ.T_UNAME Fully qualified owner name in
uppercase letters.
T_OBJNAME ZNUOBJ.T_OBJNAME Fully qualified ODBC or SQL Server
object name in uppercase letters.
COLNAME COLUMNS.COLNAME Object ID used internally by the
NonStop ODBC Server.
T_ODBCTYPE ZNUDT.T_ODBCTYPE Column/parameter name.
T_NAME ZNUDT.T_NAME Number (sequence) of this column.
PRECISION COLUMNS.PRECISION Degree of precision of this column
(type-dependent; numeric or datetime
only).
LENGTH COLUMNS.COLSIZE Length of the column data.
SCALE COLUMNS.SCALE Scale factor of this column (type-
dependent; numeric or datetime only).
T_NULLABLE ZNUDT.T_NULLABLE Indicate whether the ODBC or SQL
Server data type allows null values.