ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-101
SQL Communications Subsystem (SCS) Statements
•
Sets any defines stored in ZNSDEF for scs-processname
•
Creates a new SCS process
•
Generates an error, if scs-processname does not exist in ZNSSCS
•
Generates an error, if NOSUTIL cannot create the SCS process
•
Fails to start NOS processes, if the user is not a registered ODBC user
Example
START SCS $myscs
STATUS SCS
The STATUS SCS statement returns information about an existing SCS process.
Executing STATUS SCS returns the following information:
PROCESS file name
PRIORITY
HOMETERM
PROCESS time
CREATOR ID
PROCESS ACCESS ID
JOB ID
PROGRAM file name
SWAP file name
ERROR detail
Considerations – STATUS SCS
The STATUS SCS statement:
•
Returns status information about the scs-processname process
•
Generates an error if scs-processname does not exist in ZNSSCS
•
Generates an error if NOSUTIL is unable to get information about
scs-processname
Example
STATUS SCS $myscs
STATUS SCS scs-processname