Assert verifies that all values on the column are unique. Will fails if any duplicate values are found in the column.

Arguments

  • v_TableName – name of the table, Variable Character(255) in Oracle and Netezza, SYSNAME in SQL Server
  • v_ColumnName - column that will be checked for a value, Variable Character(255) in Oracle and Netezza, SYSNAME 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_IS_COLUMN_VALUE_UNIQUE ‘ArchivedOrders’, ‘OrderID’, ‘Duplicate records found’;

Oracle 

      DBTD_ASSERT_IS_COLUMN_VALUE_UNIQUE (‘ComponentParts’, ‘PartNumber’, ‘duplicate components are found’);

Netezza

      CALL DBTD_ASSERT_IS_COLUMN_VALUE_UNIQUE (‘Address’, ‘User’, ‘more than one address exists for one user’);
 


See Also