About sets – HP Integrity NonStop J-Series User Manual
Page 89

Table 24 DEFINEs tab buttons
Function
Button
Displays the Add DEFINE dialog.
Add...
Displays the Edit DEFINE dialog.
Modify...
Removes the selected DEFINE statement.
Remove
Figure 33 Add DEFINE
About SETs
SET variables affect the behavior of MXCS. For example, you can set default catalog and schema
names for servers running in this data source when they are not set at the client data source. Client
data source values take precedence over server data source values.
NOTE:
SET variables are primarily used by HP support.
SET variables are stored as part of the configuration data for the data source. They are retrieved
by the association server when it reads the startup values for the data source. The data source
server then sets the value when a connection is established.
describes the SET tab functions.
Table 25 Functions on the SETs Tab
Function
Button
Displays the Add SET dialog.
Add...
Displays the Edit SET dialog.
Modify...
Removes the selected SET variable.
Remove
Some SET commands require that you specify a value in single quotes. For example, SET SESSION
commands always require that the value be within single quotes.
shows an
example of the SET SESSION command.
Creating a data source
89