Difference between revisions of "LOGIN"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| Line 1: | Line 1: | ||
| − | = | + | ==Class== |
| − | + | ||
Data Connectivity | Data Connectivity | ||
| Line 13: | Line 12: | ||
==See Also== | ==See Also== | ||
| − | [[CREATE GATEWAY]], [[ | + | [[CONNECTED()]], [[CREATE GATEWAY]], [[GATEWAY()]], [[LOGOUT]], [[MODIFY GATEWAY]], [[SET GATEWAY]] |
| Line 49: | Line 48: | ||
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
| + | [[Category:Data Connectivity]] | ||
| + | [[Category:Data Connectivity Commands]] | ||
Revision as of 11:02, 3 June 2009
Class
Data Connectivity
Purpose
Login to a gateway
Syntax
LOGIN [<server>,<nodename>,<username>,<password>[,<database>]]
See Also
CONNECTED(), CREATE GATEWAY, GATEWAY(), LOGOUT, MODIFY GATEWAY, SET 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
