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