CA-L-Serv › CA-L-Serv Configuration › Define SQL Relational Tables for CA-L-Serv › Tell CA-L-Serv which SQL Definition Members to Use

Previous Topic: Define SQL Relational Tables for CA-L-Serv

Next Topic: Multiple System Environment Configuration

Tell CA-L-Serv which SQL Definition Members to Use

The LDMSQDEF member of the CA‑L‑Serv parameter data set points to all SQL definition members. All SQL definition members must be included in the LDMSQDEF member.

For example, to point to the member PRODSQL containing SQL table definitions, you would include the PRODSQL member as shown here:

LDMSQDEF **This member points to all SQL definition members used by CA‑L‑Serv**

INCLUDE PRODSQL

**This member defines SQL tables for an unspecified client application.

Note: The LDMSQDEF member is read automatically at startup by the SQL server. Consequently, the name of the member must not be altered.