SQL -204 error resolution to resolve quickly

In this post, I have given resolution on how to solve -205 SQL error.


I would say, correct the DB2 CREATOR or OBJECT NAMEs given in the SQLQuery. The Table name in your SQL query probably may not be correct.

SQL Error -204Check the database object names that you used in your SQL correct or not

DB2 Objects or Database Objects

The database is a collection of objects. Below is the complete list of those:

  • Partition group
  • Tablespaces
  • Tables
  • Views
  • Triggers
  • Stored procedures
  • Indexes
  • Buffer pools
  • UDF- User-defined functions
  • Packages
  • Sequences

Refer more here

Author: Srini

Experienced software developer. Skills in Development, Coding, Testing and Debugging. Good Data analytic skills (Data Warehousing and BI). Also skills in Mainframe.