SQLSTATE 42074 error

[uday123]

Hi,
We are using DB2 in an enterprise J2EE application and extracting data from here.

But i get the following exception when i try to retriece records from this database:

_______________ _______________ _______________ _______________ _____
COM.ibm.db2.jdb c.DB2Exception: [IBM][CLI Driver][DB2/SUN] SQL0727N An error occurred during implicit system action type "1". Information returned for the error includes SQLCODE "-204", SQLSTATE "42704" and message tokens "TCTDD00.CTDD_M QT_LOOKUP". SQLSTATE=56098
_______________ _______________ _______________ _______________ ______

I am unable to understand this error.

It would be nice if i could help from this forum...

Thanks and Regards,
Uday

[sofy]

Hi,
what is ur actual problem? At what time you are getting this error?Using JDBC/SQLJ/...???

Hi,
We are using DB2 in an enterprise J2EE application and extracting data from here.

But i get the following exception when i try to retriece records from this database:

_______________ _______________ _______________ _______________ _____
COM.ibm.db2.jdb c.DB2Exception: [IBM][CLI Driver][DB2/SUN] SQL0727N An error occurred during implicit system action type "1". Information returned for the error includes SQLCODE "-204", SQLSTATE "42704" and message tokens "TCTDD00.CTDD_M QT_LOOKUP". SQLSTATE=56098
_______________ _______________ _______________ _______________ ______

I am unable to understand this error.

It would be nice if i could help from this forum...

Thanks and Regards,
Uday

[Abhishekyerra]

This is an Implicit rebind of the package.Check the bind plan and bind the package once again with appropriate parameters.This should resolve the issue