Assert verifies that database exists on the server. Fail when database with a given name has not been found on the server.
Note: Supported in Netezza and SQL Server framework versions.
Arguments
-
v_DatabaseName – database name, Variable Character(255) in Netezza, SYSNAME in SQL Server
-
v_UserMessage – message to report when assertion fails, Variable Character(255) in Netezza, NVARCHAR(MAX) in SQL Server
Examples
Netezza
CALL DBTD_ASSERT_DB_EXISTS ('records_archive', 'cannot find database on the server');
SQL Server
EXEC DBTD_ASSERT_DB_EXISTS 'records_archive', 'cannot find database on the server';
See Also