DB2-SQL Error -204 and Resolution

SAS + MAinframe Jobs
SAS + MAinframe Jobs

-204 name IS AN UNDEFINED NAME.

Suggestion: Correct DB2 CREATOR or OBJECT NAMEs located in SQL statements.

This is possible, the Table name that you have given in the SQL query is not available. Probably incorrect name given.

DB2 Objects:

Database is a collection of objects. It is you can find in almost all RDBMSystems.

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

Refer more here

Advertisements

Author: Srini

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