AIX | HP-UX | Linux | OS/2 | OS/390 | OS/400 | PTX | SUN | Win NT |
X | X | X | X | X | X | X | X | X |
Purpose
Accesses or displays the SQL state value returned from the database.
This variable is a predefined variable and its value cannot be modified. Use the variable as a variable reference.
Examples
Example 1: Displays the SQL state in the REPORT block
%FUNCTION (DTW_SQL) val1() { select * from customer %REPORT { ... %ROW { ... %} SQLSTATE=$(SQL_STATE) %}