Setting-up the Host System

To set up the SQL interface on the host, you must:

1. If you require SQL updates, set up Transaction Handling on the database.

   If you want to support distributed transactions, the database must be configured for Transaction Logging.

2. Create a Reality user-id enabled for server access. Use option 2 (Define User Profiles) of the Reality SSM utility and, in the profiles for the required user-ids, set field 14 (Type) to either S (server mode) or * (both interactive and server modes). Choose both if the user must be able to log onto TCL as well as use SQL.

   Note that on UNIX the Reality user-id must match a corresponding UNIX user-id.

3. Run the SQLM command to set up the Reality account containing the data source. If the account has not been set up for SQL, you will be asked if you want to set it up. When you are prompted for a table name or the SQLM menu appears, press RETURN to return to TCL.

   If you wish to define your own Reality SQL data source, you must use SQLM to create an SQL catalog. If you are using a NEC-supplied SQL catalog, then the necessary files should already be present.

   Note

   The SQL.DEMO program (run from TCL) demonstrates Reality SQL. When you exit the program, you are offered the option to retain the sample tables used in the demonstration. These tables can be useful for testing your setup.