Using &NDB Verbs › Work with NDBs › Retrieve Records from an NDB › Determine Which Fields Are Present

Previous Topic: Define Fields to Return (&NDBFMT)

Next Topic: Retrieve Records Directly by RID

Determine Which Fields Are Present

Since NDBs support null fields, it might be necessary to determine, when a particular record is read, which fields are present and which are not. The MODFLD option on the &NDBGET verb allows the use of &ZVARCNT and &ZMODFLD to access the modified fields:

&NDBGET dbname retrieval-method format-method MODFLD=YES
&field1 = &ZMODFLD
&field2 = &ZMODFLD
...