R
Rob Fitzpatrick
Guest
Stephanie, I just use an ABL program to input from a db/tabanalys file and import line by line. The data you care about (table stats) is bracketed by "RECORD BLOCK SUMMARY" and "RM block(s) found in the database.". The table line items begin with "PUB.", so you can import those and discard the rest. Note that long table names can cause a line wrap so you have to account for that. Export the data to a .csv file and from there it's easy to import into Excel. Note that once you get to 11.x there are a few format changes in the report, e.g. some changes for multi-tenancy and the fact that system tables are now prefixed with "PUB.". So in that case application tables begin with "PUB." but not with "PUB._". balaji, If you can post a bit more detail about what you have tried (maybe including a relevant snippet of code) and what issues or errors you're seeing then we may be able to help.
Continue reading...
Continue reading...