|
|
|
Sets a field of the currently-active row in a procedure's result set to null. This method is redundant with using the DhSQLResultSet.set() method to set a procedure result-set field to null.
Format
public void makeNULL(int field)
Returns
None
Parameters
field
An integer that specifies which field of the result-set row to set to null (1 denotes the first field in the row, 2 denotes the second, and so on).
Throws
DhSQLException
Example
CREATE PROCEDURE test_makeNULL2(
IN char_in CHAR(20))
RESULT ( res_char CHAR(20) , res_vchar VARCHAR(30))
BEGIN
SQLResultSet.set(1,char_in);
SQLResultSet.makeNULL(2);
END
Note: The input parameter char_in in the procedure above should be of type CHAR in ANSI versions of FairCom DB SQL.
