Informational Messages
Some SQL statements generate so-called informational messages. These messages are stored in the ESQL layer when a statement is executed. Informational messages are different from error messages. Errors are passed to DataFlex through the standard DataFlex error handling mechanism. Informational messages sometimes contain warnings and sometimes additional information on the status of a statement.
In SQL Server, for example, the T-SQL statement RESTORE VERIFYONLY returns an informational message rather than a result set.
To handle informational messages, the Embedded SQL interface defines a statement attribute, SQLSTMTATTRIB_NUMMESSAGES, and a function, SQLGetMessage.