Connecting to the Database Server

4.2. Connecting to the Database Server

One connects to a database using the following statement:

EXEC SQL CONNECT TO target [AS connection-name] [USER user-name];

The target can be specified in the following ways:

There are also different ways to specify the user name:

The userid and password may be a constant text, a character variable, or a character string.

The connection-name is used to handle multiple connections in one program. It can be omitted if a program uses only one connection.

Home
Online Resources
General
Beginner Tutorials
MySQL
PostgreSQL
Oracle
mSQL
Microsoft SQL
Contact Us
Random quote of the moment:
Isn't it conceivable to you that an intelligent person could harbor two opposing ideas in his mind? -- Adlai Stevenson, to reporters
 
http://www.sql.org/
 
Proudly designed and hosted by OmegaSphere, providers of all your Web Hosting, SSL Certificate, and Domain Name needs!