Unanswered: problem while accessing CLOB data type column
I have Database server DB2/6000 7.2.8, i am using command line processor for DB2 SDK 8.1.0
I have LOGFILE column with data type CLOB. When i try to execute the following command in the command line processor it's giving the following error
db2 => SELECT LOGFILE FROM DB2ADMIN.PAYLOADLOG WHERE TSTAMP='2004-04-09-10.04.46.371000'
SQL0351N An unsupported SQLTYPE was encountered in position "1" of the output SQLDA (select list). SQLSTATE=56084
may be it could be version problem. I was not able to execute this query through Java applicaion also.I am using "db2java.zip" file of the same server version and using app Driver called COM.ibm.db2.jdbc.app.DB2Driver.
I don't understand why it's not getting executed with Java application atleast?
Are you using db2java.zip of V7 whilst on a V8 client ? JDBC Types 1 through 3 use parts of db2 client code other than those in db2java.zip ... I have seen errors even when db2java.zip is on a different fixlevel than the rest of the code ...
If you are using V7 client and still facing the problem, I would suggest a CLI and JDBC Trace ...
Visit the new-look IDUG Website , register to gain access to the excellent content.
Still in my machine i have V8.1 client is installed. But i put db2java.zip of V7 in my classpath of the application server. I guess it should work as long as i have right version db2java.zip file in the classpath. but it's not working. What i suppose to do?