This class of asserts will compares singular values

N - Netezza
O - Oracle
S - SQL Server

Assert Procedure N O S Description
 Asserting Singular Values
DBTD_ASSERT_ARE_EQUAL + + + Takes actual value and expected value, compares them for equality, and report failure if values are not equal. 
DBTD_ASSERT_INT_ARE_EQUAL     + Takes actual INT value and expected INT value, compares them for equality, and report failure if values are not equal. 
DBTD_ASSERT_MONEY_ARE_EQUAL     + Assert procedure takes actual and expected MONEY or SMALLMONEY values, compares them for equality and report failure if they are not equal
DBTD_ASSERT_DATETIME_ARE_EQUAL     +
Assert procedure that takes actual and expected DATETIME values, compares them for equality and report failure if they are not equal
DBTD_ASSERT_DATE_ARE_EQUAL     +
Assert procedure that takes actual and expected DATE values, compares them for equality and report failure if they are not equal
DBTD_ASSERT_FLOAT_ARE_EQUAL     + Assert procedure that takes actual and expected FLOAT values, compares them for equality and report failure if they are not equal
DBTD_ASSERT_HIERARCHYID_ARE_EQUAL     +
Assert procedure that takes actual and expected HIERARCHYID values, compares them for equality and report failure if they are not equal
DBTD_ASSERT_SQLVARIANT_ARE_EQUAL     + Assert procedure that takes actual and expected SQL_VARIANT values (a data type that stores values of various SQL Server-supported data types), compares them for equality and report failure if they are not equal
DBTD_ASSERT_ARE_NOT_EQUAL + + + Takes actual value and expected value, compares them for inequality, and report failure if values are equal. 
DBTD_ASSERT_IS_LESS_OR_EQUAL + + + Takes actual value and expected value, checks that actual value is less or equal to expected value and report failure if actual value is greater than expected. 
DBTD_ASSERT_IS_GREATER + + + Takes actual value and expected value, checks that actual value is greater than expected value and report failure if actual value is less or equal to expected value.
DBTD_ASSERT_IS_GREATER_OR_EQUAL     +  
DBTD_ASSERT_DATETIME_IS_GREATER + + + Takes actual time stamp value and expected time stamp value, checks that actual value is greater than expected value and report failure if actual value is less or equal to expected value. 
DBTD_ASSERT_DATETIME_IS_GREATER_OR_EQUAL + + + Takes actual time stamp value and expected time stamp value, checks that actual value is greater or equal to expected value and report failure if actual value is less than expected value.
DBTD_ASSERT_IS_TRUE + + + Checks that actual value is true and report failure if actual value is not.
DBTD_ASSERT_IS_NOT_NULL     + Checks that actual value IS NOT NULL and report failure if actual value is NULL.
DBTD_ASSERT_IS_NOT_NULL_OR_EMPTY     + Checks that actual value IS NOT NULL or empty string and report failure if actual value is NULL or an empty string.
DBTD_ASSERT_IS_NULL     + Checks that actual value IS NULL and report failure if actual value IS NOT NULL.
DBTD_ASSERT_IS_NULL_OR_EMPTY     + Checks that actual value IS NULL or an empty string and report failure if actual value IS NOT NULL or not an empty string.
DBTD_ASSERT_STRING_CONTAINS     + Looks for a pattern within the string and will fail if specified patter were not found
DBTD_ASSERT_STRING_NOT_CONTAIN     + Looks for a pattern within the string and will fail if specified patter were found in the string
Assert Procedure N O S Description

N - Netezza
O - Oracle
S - SQL Server

 

Assert procedures should not be altered.