Hi,


If I know the table name how to find the creator for that table?
I am unable run queries for that table without the creator name.


Thanks

definer in syscat.tables

I think that you may be confusing schema name with creator name; they are not necessarily the same, and you definitely don't need the creator name to query the table.

It is always good practice to fully qualify all your database objects (tables, functions, ...) anyway, i.e. use schema and object name.

You told that you know the table name. Try with this query.

SELECT STRIP(CREATOR)||'.'||NAME FROM SYSIBM.SYSTABLES WHERE NAME = 'table_name' AND TYPE = 'T';

you should get the fully qualified table name for the above query. (1 or more)
Proved the table name you will provide really exists.

What error are you getting. Is that saying OBJECT does not exists ..?
you cannot query the table with out the owner's name unless you are an owner for that table. If you wont give the creator name in the query, then CURRENT SQLID will be considered as the table owner.
Give us the information about platform, and version details. If its z/os it should be giving -204.