By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,836 Members | 2,097 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,836 IT Pros & Developers. It's quick & easy.

SQL1086C An operating system error "" occurred on databasemetadata.getcolumns()

P: n/a
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
Nov 12 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.