Progress
SQL-92
Guide and 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 © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095