using ttaad4222m000 - count number of records by table, you can run this wide open to an ascii file, import into excel and create a list of all the tables that actually have rows in them. Then from there of course you would create a flat file with just the table names - being careful not to have ^M after each table name. Then you have your list for the -I option.

In my circumstance in regards to how we use Baan, this report would yield a list of about 600 tables, out of the 2500 or so that are created for a single/single. Yes this is a simple method, I'm sure there are more clever and sexy ways out there, but this method is relatively quick and it will work. :)

bdbpre6.1 with -I option. Oh well, if you read the above and your wondering what on earth I am talking about I apologize.

perhaps a moderator will move this under the "Problem with Bdbpre" thread:)