ODBC Server Reference Manual

HP NonStop ODBC Server Mapping Tables
HP NonStop ODBC Server Reference Manual—429151-002
8-55
ZNUPROC (For Stored Procedure Attributes)
ZNUPROC (For Stored Procedure Attributes)
The table ZNUPROC contains the combined attributes required to support execution of
stored procedures for both CORE SQL users and Transact-SQL users. The table
contains one row for each stored procedure supported by the NonStop ODBC Server.
ZNUPROC also provides support for the ODBC catalog function SQLProcedures and
the SQL Server catalog SYSOBJECTS.
ZNUPROC resides in both the subvolume of the system catalog and a customized
user catalog.
See also ZNUPCOL (For Stored Procedure Parameters and Results) on page 8-53.
Table 8-26. Description of ZNUPROC (page 1 of 2)
Column Name
Primary Key Unique Index
Data Type Description
T_OBJID
x–
INT (4) Object ID used internally by the
NonStop ODBC Server to satisfy
requirements of TSQL users.
T_PROCNUM
––
INT (2) Procedure number in a procedure
group.
N_PATHNAME
––
CHAR (15) Pathway Monitor name
([\node.]$process).
N_SERVERCLASS
––
CHAR (15) Pathway server class name.
N_SERVICE
––
VARCHAR (60) Pathway service name (takes the
procedure name in ADD
PROCEDURE).
T_NUMIPARMS
––
INT (2) Number of input parameters.
T_NUMOPARMS
––
INT (2) Number of output parameters.
T_NUMRESULTS
––
INT (2) Number of result sets.
T_RETURNSTAT
––
INT (2) Is status returned?
0 No
1 Yes
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