Qualifiers on Filers

A number of qualifiers can be used when compiling filer routines. These qualifiers are described in the table that follows. Several qualifiers are preset but can be manually overridden. Standard qualifier settings include:

In addition, you can also specify qualifiers on the Db.insert and Db.update methods.

Qualifiers are processed left to right. They are then passed to the filer, which reviews and performs the processing based on the qualifier values.

Qualifiers

Indicate whether to…

INDEX
NOINDEX

Execute index build code

JOURNAL
NOJOURNAL

Execute journal create code

NOFKCHK=1
NOVALREQ=0

Execute referential integrity within the filer instead of externally

TRIGAFT
NOTRIGAFT

Execute after (db update) triggers

TRIGBRF
NOTRIGBRF

Execute before (db update) triggers

UPDATE
NOUPDATE

Update the database

VALDD
NOVALDD

Validate data against data dictionary

VALREQ
NOVALREQ

Validate required fields

VALRI
NOVALRI

Build validation for referencial integrity