Difference between revisions of "LOGIN"

From Recital Documentation Wiki
Jump to: navigation, search
 
Line 1: Line 1:
=LOGIN=
+
==Class==
 
+
 
Data Connectivity
 
Data Connectivity
  
Line 13: Line 12:
  
 
==See Also==
 
==See Also==
[[CREATE GATEWAY]], [[LOGOUT]], [[SET GATEWAY]], [[CONNECTED()]], [[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