SQL_STATE

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)
%}
 


[ Top of Page | Previous Page | Next Page | Index ]