beautypg.com

About sets – HP Integrity NonStop J-Series User Manual

Page 89

background image

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.

Table 25 (page 89)

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 34 (page 90)

shows an

example of the SET SESSION command.

Creating a data source

89

This manual is related to the following products: