Progress
SQL-92
Guide and Reference


SQLCursor.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 sc_makeNULL()
BEGIN
     SQLCursor select_btypes = new SQLCursor (
         "SELECT small_fld from sfns where small_fld = ? ");
     select_btypes.makeNULL(1);
     select_btypes.open();
     select_btypes.fetch();
   .
   .
   .
     select_btypes.close();
END 


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