Considerations for SQL-invoked External Routines › Database Name Inheritance

Database Name Inheritance

An SQL-invoked external routine can inherit the current database of the current session. The DEFAULT DATABASE attribute of the SQL-invoked external routine definition controls the inheritance of the default database as follows:

• DEFAULT DATABASE NULL guarantees compatibility with previous releases of CA IDMS.
• DEFAULT DATABASE CURRENT makes the current database the default database for any subordinate database session started by the SQL-invoked external routine.