ADELIA |
VADELIA |
SADELIA |
WADELIA |
MADELIA |
(I/B) |
(I/B) |
(B) |
(I/B) |
(I) |
Description
After an Adelia SQL read operation, this function retrieves the value of the indicator variable to find out whether or not, for a given column of a given entity, the value read is a NULL value.
Syntax
Result = &GET_INDICATOR(EntityName;EntityVarId)
Parameters
|
Description |
Contents |
Controls |
Result |
Numeric variable. |
Value of SQL indicator variable for column. Possible values: = 0 column value is not NULL, < 0 column value is NULL, > 0 column value is not NULL but the data was altered during the read operation (e.g. truncated value, etc.). Interpretation of this result depends on the DBMS. |
|
EntityName |
Name. |
Entity name. |
Mandatory parameter. |
EntityVarId |
Guide word. |
Guide word corresponding to the entity column. |
Mandatory parameter. |
Example
CHAIN_SQL INSURED *COND(INS_ID_NBR = :WID_NBR)
IF &GET_INDICATOR(INSURED;INS_ADDRESS) = 0
* The insured has an address.
...
END
List of predefined functions by topic