Database View SQL Properties

Problem:

- SQL Target   (Defaults to HCO)

- Allow Mixed Case   (Defaults to Yes)

- Generate Redefines   (Defaults to Yes)

How can I change the defaults so these are initially set correctly for our environment?

Resolution:

The database view properties are stored in the folder DDISYMB with a .prp extension. The .prp file is created with the save/build action is initiated for the subschema. Once created the .prp file are used for subsequent generations.