Product Documentation

FairCom Java & .NET Stored Procedures

Previous Topic

Next Topic

SQLPStatement.makeNULL

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

TOCIndex