ESQL-LIB Functions

Table 4–2 describes each of the functions in the ESQL-LIB interface. The middle column indicates whether a function can affect the value of the SQLCODE or SQLSTATE status variable.

Table 4–2: ESQL-LIB Functions
Function
SQLCODE
and SQLSTATE
Description
sqlald() 
Allocates storage for an SQL descriptor area used to implement Dynamic cursor statements. Supports the EXEC SQL ALLOCATE DESCRIPTOR... statement.
sqlalloc() 
Allocates data storage for columns in an SQL descriptor area.
sqlapplname() 
Sets the ESQL application name.
sqlcdbind() 
Binds the address of your SQLCODE or SQLSTATE variables to ESQL in support of error and status reporting on each ESQL statement execution.
sqlcommit() 
Commits any pending database transaction. Supports the EXEC SQL COMMIT WORK statement.
sqlconn() 
Connects to one or more databases using Progress database connection parameter.
sqldelrow() 
Deletes the row at the current cursor position. Supports the Static positioned DELETE statement.
sqldinit() 
Initializes an SQL descriptor area.
sqldiscon() 
Disconnects a database.
sqldld() 
Frees the storage previously allocated with a call to sqlald(). Supports the EXEC SQL DEALLOCATE DESCRIPTOR... statement.
sqldsize() 
Calculates the memory size required to allocate an SQL descriptor area for a specified number of columns.
sqldynclose() 
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.
sqldyndesc() 
Obtains column description information for a Dynamic ESQL result set. Supports the Dynamic EXEC SQL DESCRIBE... statement.
sqldyndescinp() 
Obtains description information for all parameter markers in a Dynamic ESQL statement.
sqldynexec() 
Executes a prepared Dynamic ESQL statement. Supports both the Dynamic EXEC SQL OPEN... and EXEC SQL EXECUTE... statements.
sqldynftch() 
Fetches the next row of a Dynamic cursor. Supports the Dynamic EXEC SQL FETCH... statement.
sqldyngetn() 
Retrieves the cursor name currently associated with a prepared Dynamic ESQL statement.
sqldynncols() 
Retrieves the number of columns in a Dynamic ESQL result set.
sqldynnparms() 
Retrieves the number of parameter markers in a prepared Dynamic ESQL statement.
sqldynposfetch() 
Fetches the specified row of a dynamic open cursor. Returns normalized values.
sqldynprep() 
Prepares a Dynamic ESQL statement. Supports the Dynamic EXEC SQL PREPARE... statement.
sqldynrq() 
Dynamically compiles and executes SQL requests other than cursor specifications. Supports the Dynamic EXEC SQL EXECUTE IMMEDIATE... statement.
sqldynsetn() 
Associates a cursor name with a prepared Dynamic ESQL statement. Supports the Dynamic EXEC SQL DECLARE... statement.
sqlfetch() 
Fetches the next row of a Static ESQL cursor. Supports the Static EXEC SQL FETCH...INTO... statement.
sqlfree() 
Frees the storage previously allocated with a call to sqlalloc().
sqlgetmsg() 
Retrieves the next message in the Progress message queue.
sqlgetrqhdl() 
Retrieves a request handle corresponding to a prepared Dynamic ESQL statement identifier.
sqllogin() 
Starts a Progress ESQL session using Progress startup parameters.
sqllogout() 
Terminates the Progress ESQL session.
sqlrequest() 
Compiles and executes any Static ESQL statement or cursor specification, except the Static FETCH, positioned DELETE, and positioned UPDATE statements.
sqlrollback() 
Rolls back any pending database transaction. Supports the EXEC SQL ROLLBACK WORK statement.
sqlsetlogoption() 
Sets a session-wide option for the ESQL interface.
sqlupdrow() 
Updates the row at the current cursor position. Supports the Static positioned UPDATE statement.


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