Hi,

I use "dbisqlc" in shell script to get the tables from a database.
In the look up it shows the table name as "master.testDB etc".
I want to retrive all tables with prefix as "master".
For this I use the sql statement as;
sql="SELECT TABLE_NAME FROM SYS.SYSTABLE WHERE TABLE_NAME LIKE
'%master%'"

But I don't get the tables with "master" prefix although I can see them in
the lookup of dbisqlc.
If I use the sql to retrieve the table records of master.testDB, I am able
to do so.

Can somebody please let me know whether these tables be retrieved in any
way?

In general, I want to get all the tables names from the database owned by
the current user.

Any help is appreciated.

Regards
Subrat