HP MPE/iX 6.x Operating System manual Appendix a Implementation Notes ODBCLink/SE Reference Manual

Appendix A Implementation Notes ODBCLink/SE Reference Manual

ALLBASE/SQL and IMAGE/SQL Statements That Work Only with Embedded SQL

PC client application software that accesses ALLBASE/SQL and IMAGE/SQL databases through ODBCLink/SE do not support embedded SQL. The application software calls the database functions directly; there is no need for preprocessing.

Because the following ALLBASE/SQL and IMAGE/SQL statements function only with embedded SQL, they are not supported by ODBCLink/SE:

CLOSE CURSOR

BEGIN DECLARE SECTION

DECLARE CURSOR

DESCRIBE

END DECLARE SECTION

EXECUTE

EXECUTE IMMEDIATE

FETCH

INCLUDE

OPEN

PREPARE

REFETCH

SQLEXPLAIN

WHENEVER

ALLBASE/SQL and IMAGE/SQL Statements Replaced by Func- tions on the PC Client

Some of the functionality has been moved from the database server to the PC client with ODBCLink/SE.

The following ALLBASE/SQL and IMAGE/SQL statements are not supported because they have been replaced by other functions resident on the PC client:

CONNECT

DISCONNECT

RELEASE

RESET

SET CONNECT

SET MULTITRANSACTION

START DBE

START DBE NEW

START DBE NEWLOG

STOP DBE

Note: If you attempt to use any of these unsupported statements, you will receive an error message.

	ODBCLink/SE
70	©M.B. Foster Associates Limited 1995-2000