HP Driver for JDBC User's Manual

Chapter 5 49

ALLBASE/SQL Speciﬁcs

Unsupported ALLBASE/SQL SQL Statements

Table 5-3 shows a list of unsupported ALLBASE/SQL statement types

in HP JDBC. Note that, in many cases, JDBC provides a standardized

method of performing the same action. For example, the

ALLBASE/SQL “COMMIT WORK” statement is not supported, since the

user should be using the java.sql.Connection.commit method.

Table 5-3 Unsupported Statements

ADVANCE BEGIN DECLARE SECTION BEGIN WORK

CLOSE COMMIT WORK CONNECT

DECLARE CURSOR DELETE WHERE CURRENT DESCRIBE

DISCONNECT END DECLARE SECTION EXECUTE

EXTRACT FETCH INCLUDE

OPEN PREPARE RELEASE

ROLLBACK WORK SET CONNECTION SET SESSION

SET TRANSACTION SETOPT START DBE

STOP DBE SQLEXPLAIN UPDATE WHERE CURRENT

TERMINATE USER WHENEVER