Editing Relational Tables › Edit a Table on Another System

Edit a Table on Another System

When CA OPS/MVS copies are running on two or more systems and communicating through the CA OPS/MVS MSF or CAICCI cross-platform communications services, you can edit a relational table residing on a remote system using the table editor on the local system.

To edit a table on a remote system, you specify both the system name and the table name on the RDF Table Editor Primary Panel. Separate the system name and the table name with a greater-than symbol (>) instead of a blank, like this:

systemname>tablename

You can specify the ? and * characters instead of a specific system name. The following list shows how to use these characters as wildcards:

• To select one of the tables defined on the current system:

  Enter the name of that table.

• To select a table from a list of tables on the current system:

  Enter an asterisk (*), or leave the Name field blank. In response, you see a panel listing available tables.

• To select a specific table on another system:

  Enter the name of the system followed by the greater-than symbol (>) and the table name, as shown here:

  sysname>tablename
  

• To select a list of all systems having defined tables:

  Enter the characters ?>* or ?>(blank)

  In response, you see a list of systems running CA OPS/MVS. To select one or more systems, type S beside the system name or names.

  Note: You cannot select systems whose status is not active.

  Result-You see a list of all relational tables on the selected systems.

• To select a list of all tables named tablename:

  Enter the following text: ?>tablename

  This text causes the table editor to display a list of systems running CA OPS/MVS. After you choose one or more systems, the table editor displays a list of all tables on the selected systems that have the name tablename.

• To select a list of all tables on all systems

  Enter any of the following character sets:

  (blank)>(blank)

  (blank)>*

  *>(blank)

  *>*

• To select a list of all tables named tablename on all systems:

  Enter one of the following:

  (blank)>tablename

  *>tablename

  This text displays a list of all tables with the specified name without displaying a list of systems.

• To select a list of all tables on the specified system:

  Enter one of the following:

  sysname>(blank)

  sysname>*