Previous Topic: Impact of Database Definition ChangesNext Topic: Non-SQL-Defined Databases and Caching


SQL-Defined Databases and Caching

Because SQL-defined databases have an associated catalog and because areas for SQL-defined databases have timestamps, CA IDMS is able to automatically detect definitional changes that impact cached SQL statements. Whenever a statement needs recompilation, CA IDMS automatically detects this condition and recompiles the affected statement dynamically.