Drop Database Connection

The Drop Database Connection VLDB property allows you to define whether the database connection is dropped after user-defined SQL is executed on the database. This VLDB property has the following options:

• Drop database connection after running user-defined SQL (default): The database connection is dropped after user-defined SQL is executed on the database. This ensures that database connections are not left open and unused for extended periods of time after user-defined SQL is executed.
• Do not drop database connection after running user-defined SQL: The database connection remains open after user-defined SQL is executed on the database. This can keep the database connection open for additional user-defined SQL statements to be executed.

Levels at Which You Can Set This

Database instance, report, and template