Embedded SQL Companion Guide > Embedded SQL Companion Guide > Embedded SQL for Pascal > The SQL Communications Area > SQLSTATE Variable Usage
Was this helpful?
SQLSTATE Variable Usage
You can use the SQLSTATE variable in an ESQL/Pascal program to return status information about the last SQL statement that was executed. SQLSTATE must be declared in a declaration section. Also, it is valid across all sessions, so you only need to declare one SQLSTATE per application.
To declare this variable, use:
character 5 SQLSTATE
or :
character 5 SQLSTA
Last modified date: 08/14/2024