Progress
SQL-92
Guide and Reference


DhSQLResultSet.makeNULL

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, n denotes the nth.

Throws

DhSQLException

EXAMPLE

This code fragment illustrates SQLResultSet.set and SQLResultSet.makeNULL:

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 


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095