Validates that column is nullable in the existing table, or that it allows NULL values to be stored in the column. Assert will fail if column is not nullable.

Arguments

  • v_ObjectName – table name. Supports four part object name. Variable Character(255) in Oracle and Netezza, SYSNAME in SQL Server
  • v_ColumnName – name of the column, 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_COLUMN_IS_NULLABLE ‘myTable’, ‘primaryKey’, ‘Cannot find object’;

Oracle 

      DBTD_ASSERT_COLUMN_IS_NULLABLE (‘Product’, ‘ProdutID’, ‘Cannot find object’);

Netezza

      CALL DBTD_ASSERT_COLUMN_IS_NULLABLE (‘Cat’, ‘Weight’, ‘’);

 

See Also