|
|
|
Sets the value of a FairCom DB 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 a 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 FairCom DB SQL statement string to set to null (1 denotes the first input parameter in the statement, 2 denotes the second, and so on).
Throws
DhSQLException
Example
CREATE PROCEDURE sps_makeNULL()
BEGIN
SQLPStatement insert_sfns1 = new SQLPStatement ("INSERT INTO sfns"
+ "(fld_ref,small_fld,int_fld,doub_fld,char_fld,vchar_fld)"
+ "values (?,?,?,?,?,?)" );
insert_sfns1.setParam(1,new Integer(666));
insert_sfns1.makeNULL(2);
insert_sfns1.makeNULL(3);
insert_sfns1.makeNULL(4);
insert_sfns1.makeNULL(5);
insert_sfns1.makeNULL(6);
insert_sfns1.execute();
END
