RE: How to get only the user table names from systables

joseph v d'silva wrote > > > I am planning to write a shell script that will unload all user > tables from a database, but for this I require to get all the > usertable names, now the problem is that the systables lists system > tables also. On the other hand if you go to dbaccess where the table > info is listed, you will have only user tables listed. I want to know > how dbaccess works out this "magic" of distinguishing system tables > and usertables. > Well what we usually use is - where tabid > 99 and tabtype = 'T' and for good measure we sometimes add and tabname not matches 'deltab*' ( to exclude ER conflict resolution tables ) Colin Bull c.bull@videonetworks.com sending to informix-list