LOGIN

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