Progress
Embedded SQL-92
Guide and Reference


Introduction

"ESQL-92 Program Structure" describes how to use ESQL statements to access and manipulate data in a database. Before you can gain access to data, you must have a valid connection to the database. You manage this access with connection management statements. Use connection management statements to establish a connection to a database, to set an existing connection as current, or to drop an existing connection. These are the connection management statements in SQL-92:

The CONNECT statement establishes a connection from an ESQL application to a database. The database you specify in the CONNECT statement becomes the current connection.

NOTE: The server for the database must be running before an ESQL program can connect to it.

The SET CONNECTION statement allows the application to set a particular database connection to the status of current. The DISCONNECT statement terminates the connection between an application and the associated database. Each of these statements is described in a following section.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095