hello sir,
I have never worked with DB2.I am facing a problem with updation of row in DB2.The following piece of code is not working in DB2...but works fine for MSAccess and Oracle.

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection con1=DriverManager.getConnection ("jdbcdbc:tgmc","db2admin","laptop");
Statement stmt1 = con1.createStatement(ResultSet.TYPE_SCROLL_SENSITI VE,ResultSet.CONCUR_UPDATABLE);
ResultSet rs = stmt1.executeQuery("select * from \"GAURAV SRIVASTAVA\".form");
while(rs.next())
{
int f_id=rs.getInt("form_id");
if(f_id==11)
{
rs.updateString("status","ri");//here is the problem
rs.updateRow();
}
}
con1.close();

The above code throws NullPointerExecption.
Can you help me with this error??? Or can you suggest me an appropiate method for performing the task

As was suggested in your other thread on this topic, we suggest that you use the DB2 JDBC driver.

Andy

i am using IBM DB2 ODBC DRIVER - DB2COPY1.
thats the driver provided in Window's XP.Is it the driver thats creating the problem??? Can u provide me some links from where I can get the DB2 JDBC driver???

Did you load the DB2 client software on the computer? If so, you already have the jdbc driver. They will be located in C:\program files\ibm\sqllib\java

Andy