Difference between revisions of "LOGIN"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| (3 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Login to a gateway | Login to a gateway | ||
| Line 13: | Line 8: | ||
==See Also== | ==See Also== | ||
| − | [[CREATE GATEWAY]], [[ | + | [[CONNECTED()]], [[CREATE GATEWAY]], [[GATEWAY()]], [[LOGOUT]], [[MODIFY GATEWAY]], [[SET GATEWAY]] |
| Line 46: | Line 41: | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital Server, Recital |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Commands]] | [[Category:Commands]] | ||
| + | [[Category:Remote Data Connectivity]] | ||
| + | [[Category:Remote Data Connectivity Commands]] | ||
Latest revision as of 11:51, 22 June 2010
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 Server, Recital
