HP 3000 Manuals

HP PC API User's Guide for ALLBASE/SQL and IMAGE/SQL

Why Are Some ALLBASE/SQL Statements Unsupported? 

There are several reasons that some ALLBASE/SQL statements are not
supported in the PC API environment.  They are explained here:

   *   Several ALLBASE/SQL statements work only with embedded SQL; PC API
       does not use embedded SQL.

   *   Some ALLBASE/SQL statements relate to functions, such as
       connection, that have been replaced by functions resident on the
       PC client.

   *   Some ALLBASE/SQL functions are best restricted to the DBA;
       statements which control these functions are accessible only
       through Interactive Structured Query Language (ISQL) on the
       server.

   *   PC API internally prepares a SQL statement to be dynamically
       preprocessed.  Therefore, you cannot use the EXECUTE IMMEDIATE
       statement.  Refer to the "PREPARE" section of the "SQL Statements"
       chapter in the ALLBASE/SQL Reference Manual for a list of
       statements that cannot be prepared.

MPE/iX 5.0 Documentation