In my opinion one of the best things about the DDS database is the use of Reference fields. I can define a field in a one file, a “Reference file”, and then use it to define fields in other files. These fields will inherit the properties of the “Reference field”.
If I need to make a change to the database, changing the size on one field, I can compile all the files that use the “Reference field” and the change will made to the file.
But how can I know which files use a particular “Reference field”?
Fortunately a SQL View gives me the information I need to do this.
Read more » Read More
Get empowered with IBM Power
