OPSVIEW Control Option › How to Use the Resource Editor to Create and Maintain SSM Resource Tables (Option 4.11.R) › The Resource Copy Panel › Fields on the Resource Copy Panel

Fields on the Resource Copy Panel

The following fields appear on the Resource Copy panel:

COPY

Displays the command name that invoked this panel.

Wait

Displays the maximum number of seconds to wait for a cross-system response (1-300).

FROM table

Displays the name of the copy FROM resource table. A new resource table may be selected by typing in the name or entering a '?' to select a new resource table from the Resource Tables display.

TO table

Displays the name of the copy TO resource table. An existing resource table may be selected by typing in the name or entering a '?' to select a new resource table from the Resource Tables display. If the TO table does not exist on the indicated system, the table name will be rejected unless the CREATE table copy option is set to 'Y'.

Ver

Displays the highest version of SSM met by the table's column structure.

System

Displays the MSF ID's of the system on which the copy FROM and TO resource tables reside. '*' means the local system. Enter a '?' in this field to select a new system name or type in the MSF ID of a new system.

Additional TO systems

Displays a comma delimited list of additional active MSF IDs or system.subsys names for the copy TO table. Another alternative is to enter a global variable name of at least 11 characters in length. The GLV value should be a system list that will be substituted for the global variable name. All systems entered are validated and converted to MSF IDs. Inactive MSF connections are discarded. Enter a '?' in this field to select additional systems from a list of active MSF connections to other systems.

TO table options

Controls how the copy operation is performed. The Update and Insert option control whether an existing row in the TO table should be updated and whether a new row should be added when the row does not exist in TO table. Deleting all the rows before copying starts, insures that only the copied rows exist in the TO table without actually deleting the TO table. The recreate option deletes the TO table before the copy operation starts. If the TO table does not exist, the create option will create the TO table using the column structure of the FROM table.

Column names option

Provides for the entry of a comma-delimited list of column names to be excluded or included in a copy update or insert operation, or dropped from a table create operation. The option value is E/I/D respectively. Primary key columns are always implicitly included in the update and insert operations. A '?' may be entered in this field in order to select a list of column names from the resource table column structure panel.

FROM row select

Provides for the entry of an SQL WHERE clause value that is appended to the SQL statement that selects the rows to copy from the FROM table. For a complete table copy, no SQL WHERE clause is required. For a single resource copy, the value should be set to NAME='resname'. Other more complex statements such as “NAME LIKE 'CICS%' AND CURRENT_STATE <> 'UP'” may also be entered and may result in multiple rows being selected. A '?' may be entered in this field in order to select a specific set of resources from the resources panel. The SQL WHERE clause will be dynamically constructed from the resources selected.