• 1 reply
  • Latest Post - ‏2013-02-04T15:38:05Z by nivanov1
17917 Posts

Pinned topic Schema.table_name is undefined name please help

‏2013-02-02T15:44:28Z |
Good day all

I have a database called Helpdesk and it contains a schema called hero and three table Employees,IT_categories,Tickets in in the server explorer it sees the database and all tables and all the data, but when i do a select query i get the below error any advice, any other requirements i need to meet.
I got ibm data studio installed, add ons. below is the full error

ERROR 42704 IBMDB2/NT64 SQL0204N "HERO.EMPLOYEES" is an undefined name.
Updated on 2013-02-04T15:38:05Z at 2013-02-04T15:38:05Z by nivanov1
  • nivanov1
    231 Posts

    Re: Schema.table_name is undefined name please help

    Did you by chance create the schema or table names not in upper case?