Release 10.1A: OpenEdge Data Management:
SQL 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 © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095