User's Reference > General > TCL and General User Commands > Command Reference > F > FDB-SET

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.

RealityV15.1Online Documentation (MoTW) Revision 7

FDB-SET (TCL) (m604806+fdbset.htm)

To

Reality

Version

Topic

Submitted by

Company

Location

Email address

Comment

 

 

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'

RealityV15.1 (MoTW) Revision 7Comment on this topic