Prardhan N
asked on
SQL0204N "schemaname.table1" is an undefined name. SQLSTATE=42704 -- need inputs
Hi All
Greetings
I have just created a new table with instance user. But I am facing the below error while doing the select of the same table which i just created.
SQL0204N "schemaname.table1" is an undefined name. SQLSTATE=42704
This is the first time I am facing the issue like this.
I have also done the runstats on the table, still facing the same error.
Any inputs Please.
Greetings
I have just created a new table with instance user. But I am facing the below error while doing the select of the same table which i just created.
SQL0204N "schemaname.table1" is an undefined name. SQLSTATE=42704
This is the first time I am facing the issue like this.
I have also done the runstats on the table, still facing the same error.
Any inputs Please.
Try quoting "schemaname"."tablename" individually.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Yes, Will work on inputs and get back to you.