Table 4–2: ESQL-LIB Functions
Function
|
SQLCODE and SQLSTATE
|
Description
|
|
|
Allocates storage for an SQL descriptor area used to implement Dynamic cursor statements. Supports the EXEC SQL ALLOCATE DESCRIPTOR... statement.
|
|
–
|
Allocates data storage for columns in an SQL descriptor area.
|
|
|
Sets the ESQL application name.
|
|
–
|
Binds the address of your SQLCODE or SQLSTATE variables to ESQL in support of error and status reporting on each ESQL statement execution.
|
|
|
Commits any pending database transaction. Supports the EXEC SQL COMMIT WORK statement.
|
|
|
Connects to one or more databases using Progress database connection parameter.
|
|
|
Deletes the row at the current cursor position. Supports the Static positioned DELETE statement.
|
|
–
|
Initializes an SQL descriptor area.
|
|
|
Disconnects a database.
|
|
–
|
Frees the storage previously allocated with a call to sqlald() . Supports the EXEC SQL DEALLOCATE DESCRIPTOR... statement.
|
|
–
|
Calculates the memory size required to allocate an SQL descriptor area for a specified number of columns.
|
|
|
Closes a Static cursor specification (cursor SELECT statement), and resets (for repeated execution) or closes a Dynamic ESQL statement or cursor specification. Supports the Static or Dynamic EXEC SQL CLOSE... statement.
|
|
|
Obtains column description information for a Dynamic ESQL result set. Supports the Dynamic EXEC SQL DESCRIBE... statement.
|
|
|
Obtains description information for all parameter markers in a Dynamic ESQL statement.
|
|
|
Executes a prepared Dynamic ESQL statement. Supports both the Dynamic EXEC SQL OPEN... and EXEC SQL EXECUTE... statements.
|
|
|
Fetches the next row of a Dynamic cursor. Supports the Dynamic EXEC SQL FETCH... statement.
|
|
|
Retrieves the cursor name currently associated with a prepared Dynamic ESQL statement.
|
|
|
Retrieves the number of columns in a Dynamic ESQL result set.
|
|
|
Retrieves the number of parameter markers in a prepared Dynamic ESQL statement.
|
|
|
Fetches the specified row of a dynamic open cursor. Returns normalized values.
|
|
|
Prepares a Dynamic ESQL statement. Supports the Dynamic EXEC SQL PREPARE... statement.
|
|
|
Dynamically compiles and executes SQL requests other than cursor specifications. Supports the Dynamic EXEC SQL EXECUTE IMMEDIATE... statement.
|
|
|
Associates a cursor name with a prepared Dynamic ESQL statement. Supports the Dynamic EXEC SQL DECLARE... statement.
|
|
|
Fetches the next row of a Static ESQL cursor. Supports the Static EXEC SQL FETCH...INTO... statement.
|
|
–
|
Frees the storage previously allocated with a call to sqlalloc() .
|
|
–
|
Retrieves the next message in the Progress message queue.
|
|
|
Retrieves a request handle corresponding to a prepared Dynamic ESQL statement identifier.
|
|
–
|
Starts a Progress ESQL session using Progress startup parameters.
|
|
|
Terminates the Progress ESQL session.
|
|
|
Compiles and executes any Static ESQL statement or cursor specification, except the Static FETCH, positioned DELETE, and positioned UPDATE statements.
|
|
|
Rolls back any pending database transaction. Supports the EXEC SQL ROLLBACK WORK statement.
|
|
|
Sets a session-wide option for the ESQL interface.
|
|
|
Updates the row at the current cursor position. Supports the Static positioned UPDATE statement.
|