For any RDBMS SQL Query to work a physical database must be defined to which the SQL query is directed. Only one physical database can be defined for all the queries in the GRG file. The physical database is defined as shown in the example below.
%%DEFINE PHYSDB animals
Remember that there is no default physical database. Without defining this the loading of SQL Query database files will fail.
A physical database is only required for the Ingres RDBMS since this has multiple ones. If you are using the GNU SQL Server you do not need to use this option.
Go to the first, previous, next, last section, table of contents.