Got problem droping tables. Our application inserts new table in our database once a users has a successfull logon on the application. Now when I run "info" from dbaccess, table menu tab it list all the tables in the database including the new tables created by the application.
These new tables are accumulating everyday. Meaning every users logon is equavalent to one table and informix assgins unique name but always starts with something like "btv_". So we wanted to create a script that will drop those tables. I have this sql script just to list the new tables but when I run this sql script it doesnt find the new tables. Here's the sql script
select database sysmaster
select tabname from systabnames
where dbsname = "dbname" and tabname = "btv_%"
order by tabname
btv_% is just a wildcard to filter all tables that start with this name. Unfornately it wont show when you run the script. Is every databases has it's own sysmaster? Am I missing something here?