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