I have a simple JDBC 2.0(app driver) code snippet like:
###########################
cSQL = DriverManager.getConnection(sDBURL, sDBUser, sDBPasswd);
DatabaseMetaData dmd = cSQL.getMetaData();
//rs = dmd.getColumns( null, null, tableName.toUpperCase(), null );
rs = dmd.getColumns( null, "DB2INST1", tableName.toUpperCase(), null
);
###########################
When I run this against my db2 database:
###############################
Database Name DB2/6000
Database version :07.02.0006
Driver Major Version :7
Driver Minor Version :1
###############################
I get this stack trace:
############################################
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/6000] SQL1086C
An operating system error "" occurred.
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_S QLException(SQLExceptionGenerator.java:273)
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.throw_S QLException(SQLExceptionGenerator.java:210)
at COM.ibm.db2.jdbc.app.SQLExceptionGenerator.check_r eturn_code(SQLExceptionGenerator.java:461)
at COM.ibm.db2.jdbc.app.DB2DatabaseMetaData.getColumn s(DB2DatabaseMetaData.java:1950)
at connectDB2.main(connectDB2.java:47)
############################################
Has anyone seen this before ?
Thanks in advance,
Jairam