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.
Related Questions
- When I roll back an update routine, some sql statements are not rolled back. Why?
- Why Are Some ALLBASE/SQL Statements Unsupported?
- How To Include Numeric Values in SQL statements?
- How To Include Numeric Values in SQL statements?
- How To Enter Binary Numbers in SQL Statements?
- How To Enter Binary Numbers in SQL Statements?
