FLDNULL - connect_cdc_sqdata - Latest

Connect CDC (SQData) Apply engine

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (SQData)
Version
Latest
Language
English
Product name
Connect CDC (SQData)
Title
Connect CDC (SQData) Apply engine
Copyright
2024
First publish date
2000
Last edition
2024-07-30
Last publish date
2024-07-30T20:19:56.898694

The FLDNULL function checks the value of a field pointed to by an index for a given record layout is NULL. Returns TRUE(1) if the value of a field pointed to by an index for a given record layout is NULL else returns FALSE(0).

Category

Record

Syntax
*FLDNULL(* index )*
*FLDNULL(REC_ALIAS*, index)*
*FLDNULL('<recname>' | variable *, index *)*
Parameter and Description
Parameter Description
<recname>

Resolves at runtime to a string and represent the record name used to locate the record alias in the description of the input datastore.

index

An index pointer to a given field within the specified record alias of the input datastore.

Example

IF FLDNULL(RECNAME(INPUT DATASTORE, V_INDEX) = TRUE (1)