Products Downloads


French version


 

 

ADELIA

VADELIA

SADELIA

WADELIA

EADELIA

(I/B)

(I/B)

(B)

(I/B)

(B)

 

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

 

↑ Top of page

  • Aucune étiquette