I would like to be able to query for all tables in a specific database (excluding the system tables). How do I go about doing that? The query "select tabname from systables" give all of the tables. What I want is the same table names list/results as I would get if I were to do a dbschema or dbexport.

Is this possible?? On IDS 9.21.UC3.

Thanks so much...

Try this query;
select tabname from systables where tabid > 99;
Above query gives all Your application tables (ie) other than systables