ODBC Server Reference Manual

Managing Customized Catalogs
HP NonStop ODBC Server Reference Manual—429151-002
7-104
TABLE Statements
scfg-name
specifies the attribute for which you are modifying a default value; scfg-name is
an alphanumeric string up to 60 characters in length and must be the name of a
column in the ZNSSCFG table. For a list of the ZNSSCFG column names, see
Appendix D, Summary of System Installation Defaults,
The value you specify must be alphanumeric; there is no further check for validity.
scfg-value
specifies the new default value for scfg-name. Enclose the value in quotation
marks. There is no check for validity.
Example
MODIFY SCFG NET_PROTOCOL "NETBIOS"
REMOVE SCFG
The REMOVE SCFG SCFG statement removes an existing system configuration
attribute-value pair in the ZNSSCFG table. To execute REMOVE SCFG, you must be a
privileged user.
scfg-name
specifies the attribute (and corresponding value) you are removing from the
ZNSSCFG table.
The following REMOVE SCFG statement removes the NET_PROTOCOL attribute and
its associated value from the ZNSSCFG table:
REMOVE SCFG NET_PROTOCOL UPDATE_SYSTEM_CONFIG
TABLE Statements
The following TABLE statements affect whether a NOSCOM user can access a
NonStop SQL/MP base table:
•
ADD TABLE
•
REMOVE TABLE
Caution. If you specify an invalid value for scfg-value, a subsequent NOSUTIL, NOS, or
SCS process that uses that value for configuration might fail to start up.
REMOVE SCFG scfg-name [ UPDATE_SYSTEM_CONFIG ]
Caution. If you remove a system configuration attribute pair from ZNSSCFG, you must
replace it in a subsequent ADD SCFG statement. If an attribute-value pair is missing from the
ZNSSCFG table or the value you specified is not valid, a subsequent NOSUTIL, NOS, or SCS
process that uses that value for configuration might fail to start up.