ADELIA |
VADELIA |
SADELIA |
WADELIA |
MADELIA |
(I/B) |
(I/B) (S) |
(B) (S) |
(I/B) (S) |
(I) (S) |
Section for use
All
Syntax
SET_INDICATOR Value EntityOrListName Field
Value |
Þ |
*TRUE | *FALSE |
Field |
Þ |
EntityOrListVarId | *ALL |
Description
This instruction lets you set the EntityOrListVarId column or all EntityOrListName columns of the entity or of the list (of the *INDIC type) to NULL (Value to *TRUE) or to change it from NULL (Value to *FALSE), before a CREATE_SQL, UPD_SQL_C or UPD_SQL (type *ALL) instruction.
Important: CREATE_SQL, UPD_SQL_C, and UPD_SQL must have the *NULL_IND parameter to take null values into account.
NB: the lists defined with *INDIC are used for the CREATE_SQL instructions in *BLOCK when the user wishes to manage NULL values.
Example
SET_INDICATOR *TRUE CLIENT CLIADDRESS2
CREATE_SQL CLIENT *NULL_IND
This example lets you set the value NULL for the CLIADDRESS2 column when creating an entry in the CLIENT array.