Checks that table has records, report failure if table is empty.

Note:
Oracle framework version uses DBTD_ASSERT_TBL_HAS_RECORDS name for this assert procedure, due to character limit for an object names.

Arguments

  • v_TableName – name of the table, Variable Characters (255) in Oracle and Netezza, SYSNAME in SQL Server
  • v_UserMessage – message to report when assertion fails, Variable Characters (255) in Oracle and Netezza, NVARCHAR(MAX) in SQL Server

Examples

SQL Server

      EXEC DBTD_ASSERT_TABLE_HAS_RECORDS ‘table1’, ‘TABLE1 should have records’;

Oracle

      DBTD_ASSERT_TBL_HAS_RECORDS (‘table1’, ‘TABLE1 should have records’);

Netezza

      CALL DBTD_ASSERT_TABLE_HAS_RECORDS (‘table1’, ‘TABLE1 should have records’);

See Also