Purpose
Defines the type of SQL flagging performed on the SQL being preprocessed.
Usage Notes
The abbreviation for SQLFLAGGER is SQLFLAG.
Options for SQLFLAGGER (or -sf) are:
| Option | Level of SQL Flagging Provided |
|---|---|
| NONE | None. This is the default value. |
| ENTRY | Entry level ANSI compliance. Also specify SQLCHECK(FULL) when specifying SQLFLAG(ENTRY). |
| INTERMEDIATE | Intermediate level ANSI-compliance. |
| INTERMEDIATE | intermediate level ANSI-compliance. When this option is specified, the default value for TRANSACT becomes ANSI. Also specify SQLCHECK(FULL) when specifying SQLFLAG(INTERMEDIATE). |
When the SQL flagger is enabled, only static embedded SQL statements are flagged during precompilation and only dynamic embedded SQL statements are flagged during program execution (runtime).