I am new to data studio and I'm trying to write SQL statements to get results from the table I have created.
When I typed the SQL such as "SELECT * FROM MyScheme."TableName"; " or "SELECT COUNT(*) FROM MyScheme."TableName"; ",
it works and the entire table and the row numbers will be displayed.
However, when I typed the SQL statements with condition or I had to project a particular field, like:
SELECT CustomerName From MyScheme."Customer" ;
it doesn't work and will display : "MyScheme.Customer" is an undefined name.. SQLCODE=-204, SQLSTATE=42704, DRIVER=4.17.30"
I can't think of the solution to solve this problem, and I'd really appreciate if anyone could help:)