Parameter | Description |
---|---|
WITH NULL | The parameter can be null. If no value is provided, Actian Data Platform passes a null. |
NOT NULL WITH DEFAULT | The parameter does not accept nulls. If no value is provided, Actian Data Platform passes 0 for numeric and money columns, or an empty string for character and date columns. |
NOT NULL NOT DEFAULT or NOT NULL | The parameter is mandatory and does not accept nulls. |
WITH NULL WITH DEFAULT | Not allowed. |
WITH NULL NOT DEFAULT | Not allowed. |
WITH DEFAULT | Not allowed without NOT NULL clause. |
NOT DEFAULT | Not allowed without NOT NULL clause. |