JAVA

NAVIGATION
CATEGORIES
REFERRENCE
LINKS
  • Problem accessing AS400 data from Java

    0 answers - 648 bytes - related search similar search Add To My Delicious Add To My Stumble Upon Add To My Google Mark Add To My Facebook Add To My Digg Add To My Reddit

    I'm trying to access data on AS400 from Websphere.

    I'm getting an error

    COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][AS] SQL0204N "QSYS.NULLID" is an undefined name. SQLSTATE=42704

    when I try to execute a select statement.

    Here is the code that I used to get a connection.

    Class.forName("COM.ibm.db2.jdbc.app.DB2Driver");
    objConnection = DriverManager.getConnection("jdbc:db2:CAUNIDB","xxxxxxxx","yyyyyyyy");

    I got a connection succesfully. But when I execute a SELECT statement
    like SELECT * FROM <libname>/<tablename> I'm getting the above exception.

Re: Problem accessing AS400 data from Java


max 4000 letters.
Your nickname that display:
In order to stop the spam: 7 + 6 =
QUESTION ON "JAVA"

DATABASE TECH