Hi Everyone,

We delete the shared tables tttxt010/tttxt001/tttxt002 and created them as physical tables for all our 60 companies. The problem is that the tttxt010 table is over a million records.

After a reorganize table I noticed that the fields refcntd and refcntu are mostly zero. Is it possible to delete all recs where these 2 fields are zero????

Is there another way I can clean up these tables w/o losing data for each company??

Thanks......

The Cat

After reorg you can use tttxt1210m000 to get rid of unused text numbers per company.

Regards,
Klaas

Been there and tried that session to print... It told me that 3 lines can be deleted....... :-((