Descriptive information
The following SQL statements can return information about
SQL statements:
- A DESCRIBE statement returns information about a prepared SQL statement. This information is useful when you execute dynamic SQL.
- A GET DIAGNOSTICS statement, when you call it after you have established a connection to a database environment, can return the name of the database server and the connection.
The Informix® Guide to SQL: Syntax fully describes these two statements.