I have a db2 table T_CNTRT_NOTES

When I run the following query through my java application :

SELECT TRANSACTION_NUMBER FROM DB2ADMIN.T_CNTRT_NOTES WHERE CONTRACT_NOTE_NUMBER = '111111'

I get the following error

COM.ibm.db2.jdbc.DB2Exception: [IBM][JDBC Driver] CLI0611E Invalid column name. SQLSTATE=S0022

though the column already Exists

When I run the same query from db2 command line it works fine

I am using IBM DB2 version 8.1 on AIX 4.3

Any help would be greatly appreciated

Thanks

Falcon

Are you connected to the same database in both cases ...

In your application use the metadata apis and get information on the table columns and confirm the column exists in the database you connect to

Cheers
Sathyaram

Hi Sathyaram

I am connected to the same database and the column exists in the database

The query runs fine on DB2 command line but it fails in java application

Regards

Falcon