Products Downloads


French version


 


ADELIA

VADELIA

SADELIA

WADELIA

EADELIA

(I/B)

(I/B) (S)

(B) (S)

(I/B) (S)

(B) (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.


↑ Top of page

  • Aucune étiquette