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 |