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
ft:locale
en-US
Product name
Connect CDC (SQData)
ft:title
Connect CDC (SQData) Apply engine
Copyright
2025
First publish date
2000
ft:lastEdition
2025-03-03
ft:lastPublication
2025-03-03T15:29:41.860000

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)