Preprocessing and Run Time Databases
Go Up to Declaring a Database
Normally, each SET DATABASE
statement specifies a single database file to associate with a handle. When a program is preprocessed, gpre
uses the specified file to validate the program’s table and column references. Later, when a user runs the program, the same database file is accessed. Different databases can be specified for preprocessing and run time when necessary.