REFERENCES Clause

Used in the LOAD MODULE statement to provide the bindings for the reference table queries inside the module at load time.

Syntax

REFERENCES
		reference-inmodule = reference-parentmodule [, ...]

Components

reference-inmodule	The name of the reference defined in the module.
reference-parentmodule	The reference in the project to which this module reference is being bound.

Usage

Binding a reference in a module to one in the main project provides the module reference with the source table to look in, the service to use, and any reconnection information that has been defined in the reference in the main body of the project. If a primary key has been specified, it also identifies the schema of the database containing the table.

In order to bind a reference in a module to a reference in the project, the following must be the same for both references:

the number of columns
the datatypes of the columns
the order of the columns
the presence or absence of a primary key
the columns that comprise the primary key, if it is present

The names of the columns in the schema do not have to be identical.