FDB-SET

Changes the functionality of the CREATE-FILE and restore commands so that files are created/restored on the specified foreign database. This changed functionality of CREATE-FILE remains in place throughout the current logon session, or until the FDB-CLEAR command is executed.

Command Class

TCL-I command.

Syntax

FDB-SET database, {user}, {password}

Syntax Elements

databaseis the ODBC Data Source Name (DSN) for the foreign database. The DSN may itself include a user-id, and password if required, for logging on to the database. In this case, you will not need to enter them as independent parameters. For information on how to set up DSNs, refer to the documentation for the ODBC installation on your Reality system.

useris the user-id for logging on to the database. (If the database is not made up entirely of Reality files, it may be partitioned so that all Reality files share one user-id.)

passwordis the password associated with this user-id.

Example

:FDB-SET FINANCE,REALITY,WELCOME
[5426] Foreign Database active: Dsn 'FINANCE', User 'REALITY'