Ok . Thank you

In insert query is it possible to insert the values directly. without using parameter?

like

/}}END:CLASS:CONSTRUCTOR

setSQLQuery("INSERT INTO USE.FEEDBACKIVR ( QUESTIONNO) VALUES ( '1' )");

It should just execute the insert statement fine. But make sure you set the parameters to an empty list by do this first:

//}}END:CLASS:CONSTRUCTOR

List parameters = new ArrayList();
setParameters(parameters);

Hi

setSQLQuery("SELECT STUDENT_DATA.ID, STUDENT_DATA.NAME FROM AVAYA.STUDENT_DATA");

// List variable that may be used
java.util.List list;

// Parameters
com.avaya.sce.runtime.connectivity.db.DbQueryParam parameter;
addParameter(new com.avaya.sce.runtime.connectivity.db.DbQueryParam("ID",0,12, "select:ID"));
addParameter(new com.avaya.sce.runtime.connectivity.db.DbQueryParam("NAME",0,12, "select:NAME"));

This select query contains 10 values... How can i retrieve all the value ?

You would be better off starting with the dbop wizard to create a query since it will create the variables and map them to the parameters or result columns for you and generate the code automatically. The Java api methods mentioned here were not designed for you to do things manually although you can make some modification on the generated code.