Hi Frank.

>I notice that GENDBC does not create SET FILTERS for primay key on indexed files in a dbc. I'm interested in doing this as part of a process to create a dbc with imbedded tables on the fly and need to get by requirement to add these manually. Any ideas anybody?

Consider using Stonefield Database Toolkit. It can create all your tables with a single call (or update their structures if the tables already exist). It knows how to create a filtered primary key.

As an alternative, you can modify the code generated by GENDBC, removing the PRIMARY definitions from the CREATE TABLE statements and adding ALTER TABLE statements to create the filtered primary keys. Of course, this is tedious, error-prone, and has to be done each time you make even the slightest change to your data structures.

Doug