I have created a database using an SQL script. When I try to access any of the tables I get a SQLSyntaxErrorException with SQLCODE=-204.

When I print out the tablenames using metadata.getTables(...), I do see a bunch of table names incl. the one I am trying to access.

The offending line is
ResultSet rs = s0.executeQuery("SELECT * FROM XYZ")

Check the table schema

The first line of the script file is

CREATE SCHEMA "Schema";

I tried executeQuery("SELECT * from Schema.XYZ") -- same error msg
and executeQuery("SELECT * from <DB>.Schema.XYZ") -- same problem

Thanks!

Must Read before posting

Unfortunately that's not of much help
Any suggestions of what I can do/look at to try and track down this problem??
Thanks!

Your problem statement does not make a lot of sense either.

I gave you the link that explains how to describe problems so that other people can help.

execute : select distinct creator from sysibm.systables to find all schema names
select creator from sysibm.systables where name='tablename'