SQL Concepts and Language Elements › SQL Dataviews › SQL NULL Attribute

SQL NULL Attribute

CA Ideal supports the NULL concept in SQL. Fields in dataviews that are defined as null‑eligible do not require indicator variables. Rather, the programmer uses the keyword NULL, as in IF FIELD_X IS NULL. CA Ideal also handles the null attribute in conditional and arithmetic expressions and in working data, parameter data, and on panels and reports.