sqlNullable

The modifier sqlNullable indicates whether a parameter used for database access can accept a null value. The modifier is only for code migrated from VisualAge® Generator. For new development, use a parameter that has the "?" extension character, as in the following example:
  Function myFunction( myInt int? inOut )
    ;
  end
Here is the same example with the modifier sqlNullable:
  Function myFunction ( myInt int inOut sqlNullable )
    ;
  end

When the modifier sqlNullable is in place, the input argument can be a null, the parameter can be set to null in the function, and the parameter can return a null. The business data in the parameter is preceded with four bytes, as described in “SQL record internals.”

The modifier sqlNullable allows for a loose type conversion when the function is being invoked with a variable that does not accept a null.


Feedback