Communicator 3000 MPE/iX Release 6.0 (Platform Software Release C.60.00) (30216-90269)

Chapter 10 233
Technical Articles
Introducing ODBCLink/SE
Unsupported ALLBASE/SQL and IMAGE/SQL
Statements
There are several reasons why some ALLBASE/SQL and IMAGE/SQL
statements are not supported in the ODBCLink/SE environment:
• ODBCLink/SE does not support embedded SQL, therefore
statements that work only with embedded SQL are not supported.
See details that follow.
• Statements that relate to functions, such as connection, that have
been replaced by functions resident on the client. See details that
follow.
• Some functions are best restricted to the DBA; statements which
control these functions are accessible only through Interactive
Structured Query Language (ISQL) on the server.
• ODBCLink/SE internally prepares an SQL statement to be
dynamically preprocessed. Therefore, you cannot use some
statements such as EXECUTE IMMEDIATE.
Statements that Work Only with Embedded SQL
Client application software that accesses ALLBASE/SQL and
IMAGE/SQL databases through ODBCLink/SE does 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:
Table 10-8 Functions Not Supported by ODBCLink/SE
Statements Replaced by Functions on the Client
Some ALLBASE/SQL and IMAGE/SQL functions have been moved
from the server to the client with ODBCLink/SE.
CLOSE CURSOR BEGIN DECLARE SECTION
DECLARE CURSOR DESCRIBE
END DECLARE SECTION EXECUTE
EXECUTE IMMEDIATE FETCH
INCLUDE OPEN
PREPARE REFETCH
SQLEXPLAIN WHENEVER