When framework finds DBTD_DO_NOT_USE_TRANSACTION hint procedure call anywhere in the body of the Unit Test procedure, test runner will NOT wrap such Unit Test into a transaction, and will NOT rollback any changes after execution, leaving behind any changes in the database. 

DBTD_DO_NOT_USE_TRANSACTION hint will force framework NOT to use transaction, regardless of the test runner options used during the run.

Use teardown functionality to clean Unit Test results if needed.

Note: Supported in Oracle and SQL Server logic, Netezza does not support transactions at this time. 

Arguments

  • v_Message – user message, Variable Characters (4000). Optional parameter, default value 'Transactions will NOT be used'. SQL Server version uses NVARCHAR(MAX) data type.

 

Examples

SQL Server

      EXEC DBTD_DO_NOT_USE_TRANSACTION 'Keep test changes in the database, because they will be used in the other test suite';

Oracle

      CALL DBTD_DO_NOT_USE_TRANSACTION ('Keep test changes in the database, because they will be used in the other test suite');

 

See Also