DSQL Limitations (Using Dynamic SQL)

From InterBase

Go Up to Using Dynamic SQL


Although DSQL offers many advantages, it also has the following limitations:

  • Access to one database at a time.
  • Dynamic transaction processing is not permitted; all named transactions must be declared at compile time.
  • Dynamic access to Blob and array data is not supported; Blob and array data can be accessed, but only through standard, statically processed SQL statements, or through low-level API calls.
  • Database creation is restricted to CREATE DATABASE statements executed within the context of EXECUTE IMMEDIATE.

For more information about handling transactions in DSQL applications, see Handling Transactions. For more information about working with Blob data in DSQL, see Processing Blob Data. For more information about handling array data in DSQL, see Processing Array Data. For more information about dynamic creation of databases, see Creating a Database.

Topics

Advance To: