ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-100
SQL Communications Subsystem (SCS) Statements
Considerations – MODIFY SCS
The MODIFY SCS statement generates an error if you are not authorized to modify the
system catalog or a warning if network-service-name cannot be found in the
ZNSNET table.
Example
MODIFY SCS $scs02 scs_library_file bugfix
REMOVE SCS
The REMOVE SCS statement removes an SCS named configuration from the
ZNSSCS table. To execute REMOVE SCS, you must be a privileged user.
scs-processname
specifies the Guardian process name of the SCS named configuration you want to
remove from the ZNSSCS table.
Considerations – REMOVE SCS
The REMOVE SCS statement:
•
Removes the corresponding entry for the SCS named configuration in ZNSSCS
•
Generates an error if you are not a privileged user
Example
REMOVE SCS $myscs
START SCS
The START SCS statement creates a new SCS process with a specific named
configuration from the ZNSSCS table. Configuration values you specify affect an SCS
process only when it is started; existing SCS processes are unaffected.
In addition to the named configuration, START SCS searches for and sets any stored
DEFINEs to associate with scs-processname.
Considerations – START SCS
The START SCS statement:
•
Reads configuration values for the SCS named configuration in ZNSSCS
REMOVE SCS scs-processname [ UPDATE_SYSTEM_CONFIG ]
START SCS scs-processname