Creating and Managing Your Model › Creating a CA 2E Design Model › Implementing SQL/DDL and DDS in the Same Model

Implementing SQL/DDL and DDS in the Same Model

CA 2E lets you implement both SQL/DDL and DDS within a design model. For example, if you normally use DDS but want to create a model that uses both DDS and SQL, you would create the model as follows:

1. Set the SQLLIB parameter value of the YCRTMDLLIB command to *GEN. CA 2E generates the SQL collection library and builds a name according to the rules described in the previous section.
2. Ensure that the value for the parameter DBFGEN is set to *DDS.
3. Set other model parameters as needed and create the model.

The model library list contains the SQL collection library, listed below the generation library. If you want to use SQL to implement certain CA 2E access paths in the model:

1. Set the access path details to SQL.
2. Edit the model library list so that the SQL library is listed above the generation library.
3. Update the related job description.

Note: When you use both DDS and SQL in the same model, CA 2E imposes restrictions.

For more information about using SQL/DDL and DDS, see the chapter "Setting Default Options for Your Access Paths” in the Building Access Paths guide.