Takes actual value and expected value, compares them for inequality, and report failure if values are equal. 

Arguments

  • V_ActualValue - actual value, Variable Character(255) in Oracle and Netezza, NVARCHAR(MAX) in SQL Server
  • V_ExpectedValue - expected value, Variable Character(255) in Oracle and Netezza, NVARCHAR(MAX) in SQL Server
  • 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_ARE_NOT_EQUAL 5, 6, ‘Values should NOT be the same’;

Oracle

      DBTD_ASSERT_ARE_NOT_EQUAL (5, 6, ‘Values should NOT be the same’);

Netezza

      CALL DBTD_ASSERT_ARE_NOT_EQUAL (5, 6, ‘Values should NOT be the same’);

 

See Also