HP Integrity NonStop J-Series - Manual (Page 86)

Figure 32 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.
Table 25 (page 86) 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.
Figure 33 (page 86) shows an
example of the SET SESSION command.
Figure 33 SET SESSION example 1
Internally, MXDM concatenates the Name and Value fields to form the SET command. Therefore,
you can specify the value alone in the value field and the rest of the command in the Name field,
as shown in the example. Alternatively, you can specify the type of the SET command in the Name
field and the rest of the command in the Value field. HP recommends that you use this approach.
Figure 34 (page 87) shows an example.
86 Managing MXCS objects