Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

*SQLNULL Keyword

*SQLNULL is a special keyword like *NULL, but with a different meaning: *SQLNULL means the value for the field is unknown, whereas *NULL means the field is empty.

...

Code Block
Define Field(#B) Type(*CHAR) Length(8) Input_Atr(ASQN) Default(*SQLNULL)

...


Also See

ASQN (Allow SQL Nulls) attribute

Intrinsic Property .IsSqlNull

Intrinsic Method .AsValue

Assignment, Conditions, and Expressions with Fields allowing SQL Null