Checks that actual value is true and report failure if actual value is not.

Note:

In version 3 of the framework the TRUE value is different across database servers and appliances:

  • SQL Server – data type  BIT, value 1 or 0 are accepted. 1 is TRUE, 0 is FALSE;
  • Netezza – data type BOOLEAN, values are TRUE or FALSE;
  • Oracle – data type CHAR, values are ‘Y’ or ‘N’ are accepted. Y is TRUE, N is FALSE.

 Arguments

  • V_ActualValue - actual value.
  • v_UserMessage – message to report when assertion fails, Variable Character (255) in Oracle and Netezza, NVARCHAR(MAX) in SQL Server.

 

Examples

SQL Server

      EXEC DBTD_ASSERT_IS_TRUE 1, ‘Value should be 1 - true’;

Oracle

      DBTD_ASSERT_IS_TRUE (‘Y’, ‘Value should be Y - true’);

Netezza

      CALL DBTD_ASSERT_IS_TRUE( TRUE, ‘Value should be true’);

 

See Also