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 ofEXECUTE 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
- Accessing Databases
- Handling Transactions
- Creating a Database
- Processing Blob Data
- Processing Array Data