Release 10.1A: OpenEdge Data Management:
SQL Reference

> ## SQLIStatement.makeNULL

> Sets the value of an SQL statement’s input parameter to `NULL`. This method is common to the `SQLCursor`, `SQLIStatement`, and `SQLPStatement` classes. This method is redundant with using the `setParam` method to set an SQL statement’s input parameter to `NULL`.

> ##### Format

> `public void makeNULL(int` `f``)`

> ##### Returns

> None

> ##### Parameters

> `f`

> An integer that specifies which input parameter of the SQL statement string to set to `NULL`. `1` denotes the first input parameter in the statement, `2` denotes the second, `n` denotes the `nth`.

> ##### Throws

> `DhSQLException`

> Example

> This code fragment illustrates the `makeNULL` method:

>     CREATE PROCEDURE sis_makeNULL()

>     BEGIN
>          SQLIStatement insert_sfns1 = new SQLIStatement ("INSERT INTO sfns
>           (fld_ref,small_fld,int_fld,doub_fld,char_fld,vchar_fld)
>           values (?,?,?,?,?,?)" );
>          insert_sfns1.setParam(1,new Integer(66));
>          insert_sfns1.makeNULL(2);
>          insert_sfns1.makeNULL(3);
>          insert_sfns1.makeNULL(4);
>          insert_sfns1.makeNULL(5);
>          insert_sfns1.makeNULL(6);
>          insert_sfns1.execute();
>     END

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