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

Similarity check
Description Value
The value used is the system default setting that exists at execution.
SQL/MX recompiles the statement at run time, depending on the outcome of late name resolution,
timestamp comparison, or table redefinition. Off
SQL/MX performs similarity checks at run time to determine whether the new table is similar to the
previous table. If similar, SQL/MX uses the table without recompilation. Otherwise, the SQL statement
is recompiled with the new table name. This setting is the default. On
Table Lock
Description Value
The value used is the system default setting that exists at execution.
This value indicates whether to use table locks for the specified table or view. Enable
Table locks are not used. Off
Table locks are used. On
Timeout
Description Value
The value used is the system default setting that exists at execution.
No timeout is specified. No Timeout
Does not wait for a table lock. If the lock cannot be acquired, SQL/MX returns an error. Will Not Wait
1 through 2147483519 in hundredths of a second. Interval
Copying a data source
If you want to create a data source that is similar to an already-configured data source, you can
use the configured data source as a template for the new data source. This procedure makes a
copy of an existing data source configuration and enables you to modify the copy as needed.
To make a copy of an existing data source:
1.
Log on to the HP NonStop SQL/MX Database Manager.
2. Under the navigation tree pane, click Connectivity.
MXDM displays a list of existing systems.
3. Expand the system for which you want to create a new data source.
4. Right-click Data Sources, and select Copy Data Source...
The Copy Data Source window appears.
5. Modify the required fields.
•
“Using General Properties” (page 83) .
NOTE: You must change the data source name. If you do not change the name, MXDM
returns an error message indicating that the data source already exists.
•
“Using the DEFINEs and SETs tab” (page 85)
Copying a data source 89