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 )
;
endHere 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.