Specifying WHERE Parameter in I/O Commands

Fields that Allow SQL Null

A field allowing SQL Null may be used as a key or as part of a where parameter just the same as any other field. It may also be compared to SQL Null. The following example shows how you might retrieve all rows in MYFILE where #MYFLD1 has a real value (not SQL Null).

...

Note that fields allowing SQL Null may behave differently in where parameters at execution time when they are SQL Null. Refer to Assignment, Conditions, and Expressions with Fields allowing SQL Null for details.

Fields of type BLOB, CLOB, Binary or VarBinary

BLOB or CLOB fields on the file cannot be used in a where condition unless being compared against *SQLNULL. For example:

...

Any attempt to compare a BLOB or CLOB field on the file to any other value than *SQLNULL causes a FFC error.

Fields of type Float

Floats are an inaccurate numeric type. In the FFC, when a float is compared via *EQ or *NE (or equivalent) to a field, system variable (other than *ZERO), or literal value other than 0, *NULL, or *SQLNULL, a warning message is issued.

...