<div>
Try quoting &quot;schemaname&quot;.&quot;tablename&quot; individually.
</div>


Try quoting "schemaname"."tablename" individually.

<div>
Yes, Will work on inputs and get back to you.
</div>


Yes, Will work on inputs and get back to you.

<div>
<div class="content wysiwyg-content">
Hi All<br />
<br />
Greetings<br />
<br />
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. <br />
<br />
SQL0204N &nbsp;&quot;schemaname.table1&quot; is an undefined name. &nbsp;SQLSTATE=42704<br />
<br />
This is the first time I am facing the issue like this.<br />
<br />
I have also done the runstats on the table, still facing the same error.<br />
<br />
Any inputs Please.
</div>
</div>


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.

SQL0204N  &quot;schemaname.table1&quot; is an undefined name.  SQLSTATE=42704 -- need inputs

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.

Databases

IBM DB2 is a family of relational database server products developed by IBM that have been extended to support object-relational features and non-relational structures like JSON and XML. There are three main products in the DB2 family: DB2 for Linux, UNIX and Windows (informally known as DB2 LUW), DB2 for z/OS (mainframe), and DB2 for i (formerly OS/400), plus a version for IBM's Virtual Storage Extended (VSE) operating system.

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.

SQL0204N &quot;schemaname.table1&quot; is an undefined name. SQLSTATE=42704 -- need inputs

SQL0204N "schemaname.table1" is an undefined name. SQLSTATE=42704 -- need inputs