Connect to the Host DBMS through the Gateway
To connect from an Ingres tool to the DBMS, use the following format:
tool_name dbalias/server_class [-u effective_user ] [-P dbms_password]
tool_name
Specifies the name of the Ingres tool, for example, sql or isql.
dbalias
Identifies the database alias name.
server_class
Specifies the server class as either mssql, oracle, or db2udb.
-u effective_user
Defines the user ID used to connect to the database. This parameter is processed by the gateway and sent to the host DBMS. The user ID must have been defined to the host DBMS and permissions provided that would allow it to access the requested databases. Authentication can also be performed using gateway aliases or roles. See
Gateway Alias Configuration for more information.
-P dbms_ password
Defines the password used to connect to the database. This parameter is processed by the gateway and sent to the host DBMS. The password is associated with the user ID used to connect to the host DBMS database. If the -u flag was used, this password will be associated with that user ID. If the client did not pass the -u flag to the gateway, the default client user ID will be associated with this password. Authentication can also be performed using gateway aliases or roles. See
Gateway Alias Configuration for more information.
Tip to connect using Terminal Monitor: If using another database product that also contains an executable sql, ensure that the Ingres bin directory is specified first in the execution path, or that the sql symbol is pointing to the correct executable:
sql oracledb/oracle -ufred -Psecret