LOGIN

From Recital Documentation Wiki
Revision as of 11:27, 17 March 2009 by Yvonnemilne (Talk | contribs)

(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

LOGIN

Data Connectivity


Purpose

Login to a gateway


Syntax

LOGIN [<server>,<nodename>,<username>,<password>[,<database>]]


See Also

CREATE GATEWAY, LOGOUT, SET GATEWAY, CONNECTED(), GATEWAY()


Description

The LOGIN command allows you to connect to an external database via the Recital Database Server. In Recital Terminal Developer environments, the login command can be issued without specifying all the connection parameters. In this case, a dialog box labeled "LOGIN TO DATABASE SERVER" will be displayed on the screen prompting for the missing parameters.


Parameter Description
Server Database server type, e.g. ORACLE, ODBC, RECITAL
Nodename IP Address or hostname of the machine on which the database resides
Username Username to login to the external database
Password Password for username above
Database Database to connect to. For Oracle databases this entry can be left blank or used to pass hostname information when SQL*NET is being used. The information required differs depending on the version of SQL*NET being used:

SQL*NET 1 - 'database' = T:<node>:<SID> SQL*NET 2 - 'database' = <service name>


Example

login "oracle", "hp", "scott", "tiger"
select * from emp;


Products

Recital Database Server, Recital Mirage Server, Recital Terminal Developer