ODBC Server Reference Manual
HP NonStop ODBC Server Mapping Tables
HP NonStop ODBC Server Reference Manual—429151-002
8-32
ZNSSCS (for SQL Communication Subsystem
Specifications)
ZNSSCS (for SQL Communication Subsystem Specifications)
The ZNSSCS table stores the definitions of the SCS process configuration. (It replaces
the user-specified edit files used in previous versions of NonStop ODBC.)
You can specify any value in the configuration that is used by the
PROCESS_CREATE_ procedure or can be passed in the startup message to the SCS
process. For columns with a PROCESS_CREATE_ option in the description, see the
Guardian Procedure Calls Reference Manual for a definition.
ZNSSCS resides only in the subvolume of the system catalog.
Table 8-15. Description of ZNSSCS (page 1 of 2)
Column Name
Primary Key
Unique Index
Data Type Description
SCS_NAME
x–
CHAR (16) Unique SCS name.
JOB_ID
– –
INT (2) PROCESS_CREATE_ option.
SCS_OBJECT
––
VARCHAR (35) Qualified file name.
SCS_LIBRARY_FILE
––
VARCHAR (35) PROCESS_CREATE_ option.
SCS_PRIORITY
––
INT (2) PROCESS_CREATE_ option.
CPU_PRIMARY
––
INT (2) PROCESS_CREATE_ option.
CPU_BACKUP
––
INT (2) PROCESS_CREATE_ option.
SWAPVOL
––
VARCHAR (17) PROCESS_CREATE_ option.
DATAPAGES
__
INT (2) Common Kernel startup option.
EXT_SWAPFILE
––
VARCHAR (35) PROCESS_CREATE_ option.
SCS_CREATE_
OPTIONS
––
INT (2) PROCESS_CREATE_ option.
EMIT_EVENTS
––
CHAR (1) Emit EMS events option.
PIPE_TEST
__
CHAR (1) Obsolete; not used.
MEMORY_CHECK
__
CHAR (1) SCS diagnostic parameter.
HOMETERM
––
VARCHAR (24) PROCESS_CREATE_ option.
IN_FILE
––
VARCHAR (35) PROCESS_CREATE_ option.
OUT_FILE
––
VARCHAR (35) PROCESS_CREATE_ option.
ERR_FILE
––
VARCHAR (35) PROCESS_CREATE_ option.
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