SQL 92--How to execute a query

[Manu]

Hai All!

I am new to Progress..
Here is my problem.. I have DB called library having some of the tables.

I started DB , opened SQL Explorer of Porgress , connected to DB.

Now i entered query to Insert some data to one of the tables.
The query is given below.

Insert into State (State,State_Name,Region) values ('CA','Cali','Amer')


while executing this query it is giving error

=== SQL Exception 1 ===
SQLState=42S02
ErrorCode=-20005
[JDBC Progress Driver]:Table/View/Synonym not found (7519)

Not only this..no query seems to be executing,,

I wrote a query to insert a new table..
No error is getting displayed but when DB is seen using Data Dictionary the newly added table is not getting displayed..

So..Where i am going wrong?

Pls guide me..


Thanks in Advance..

Rgds
Manohar

 

[Gabor Topor]

Hi,


1. Try to use 'pub.state' instead of 'state'
2. You can use
set schema 'pub'
...

3. SQL tables are not visible from Data Dictionary. You can use system tables to examine them.


Best regards,
Gabor