Introduction to Access Paths › Changing Values › Creating an SQL Environment

Creating an SQL Environment

Using SQL facilitates the portability of generated applications and is the only means of database access across machines in Distributed Relational Database Architecture (DRDA).

For more information:

• On SQL, see the appendix "SQL Implementation" in the Administration Guide.
• On DRDA, see the chapter "Modifying Access Paths" in this guide, and the chapter "Distributed Relational Database Architecture" in Generating and Implementing Applications.

To create SQL tables and views or DDL indexes for your model, you need an SQL library known as a collection. This collection contains the SQL objects, including the catalog, a data dictionary, a journal, and two journal receivers.

When creating an SQL environment, use one of the following:

• SQLLIB parameter on the YCRTMDLLIB command creates a collection library name with MDL replaced by SQL or a name of your choosing.
• Create SQL Library (YCRTSQLLIB) command creates a collection and links it to a model.