User's Reference > Administration > Reality on the Host > Networking > Windows Network Administration Utility > Remote Databases

Comment on this topic

Documentation Comments

Use this form to comment on this topic. You can also provide any general observations about the Online Documentation, or request that additional information be added in a future release.

Reality V15.0 ()

Remote Databases (Windows) (m605016+remotedatabase.htm)

To

Reality

Version

Topic

Submitted by

Company

Location

Email address

Comment

 

 

Windows onlyRemote Databases

Remote Database entries allow local databases to connect to remote databases. A Remote Database entry contains the following information:

Database name The name of the Remote Database entry; that is, the name by which the database will be known on your local system. This will normally be the same as on the remote system, but it could be a local alias.

Remote host The name of the Destination entry for the host that holds the database.

Remote database name
The name of the database as it appears in the ROUTE-FILEon the remote system:

netadmin option 4 - Remote Databases  allows you to add, delete, edit and list Remote Database entries. Selecting this option displays the menu:

Northgate NETWORK ADMINISTRATION - REMOTE DATABASES
1. Add remote database
2. Edit remote database
3. Delete remote database
4. List remote databases
Select action [1-4 / q] :

Adding an Entry

To add a Remote Database entry, select option 1 from the Remote Databases menu. The following sequence of prompts is displayed.

  1. Enter remote database name [DatabaseName / q] :
     >>

    Enter the name by which the remote database is to be known locally. If the name is already in use, you are re-prompted. The name must be no longer than 49 characters.

  2. The names of the existing Destination Host entries are displayed and you are prompted to enter the entry number of the host on which the remote database is held. If there are more than 20 entries, press return to display the next list.

    Note: You can also create a Remote Database entry that is a alias for a local database. In this case, set this field to the localhost entry.

  3. Enter name of database on remote system [DatabaseName/(admin)/n:none/q]:
     >>

    • Enter the name by which this database is known on the remote system. The default is the name entered in step 1.
    • Alternatively, enter n  to leave the name blank. This allows you to connect to the command prompt on a remote UNIX host.
  4. The complete entry is then displayed, followed by a confirmation prompt. Enter y  to save the entry, or n  to discard it; you are then returned to the menu.

Editing an Entry

To edit a Remote Database entry, select option 2 from the Remote Databases menu.

  1. The names of the existing entries are displayed - enter the number of the required entry. If there are more than 20 entries, press return to display the next list.
  2. The details of the selected entry are displayed, followed by a prompt that allows you to change the database name - enter a new name if required or press RETURN to retain the current name.
  3. The remaining prompts are the same as when you add a Remote Database entry, except that the defaults are the current values.

Deleting an Entry

To delete a Remote Database entry, select option 3 from the Remote Databases menu.

  1. The names of the existing entries are displayed and you are prompted to enter an entry number. If there are more than 20 entries, press return to display the next list.

  2. The details of the selected database are displayed, followed by a prompt asking you to confirm that you want to delete the entry. Enter y  to delete the entry, or n  to keep it.

    You are then returned to the menu.

Listing Entries

To list the Remote Database entries, select option 4 from the Remote Databases menu.

  1. The names of the existing Remote Database entries are displayed and you are prompted to enter an entry number or *  to list the details of all the entries. If there are more than 20 entries, press return to display the next list.
  2. The details of the selected database are displayed. Press RETURNafter each entry to display the next one, or enter q  to return to the menu. At the end of the list you are returned to the menu.

RealityV15.0Comment on this topic