Previous Topic: Specifying Select/Omit CriteriaNext Topic: SQL and DDS Joins


Specifying Generation Mode

CA 2E lets you specify the mode in which you generate the source (Data Definition Language).

Specify Generation Mode. At the Edit Access Path Details panel enter or change the generation mode at the Generation Mode field and press Enter.

Options are:

In CA 2E, some combinations of files and access paths that use different Data Definition Languages are permitted, while some are not. For example, you cannot have a CA 2E SQL logical file over a CA 2E DDS physical file. The following table outlines these rules:

 

 

CA 2E Logical Access Path

 

 

 

 

 

CA 2E Physical Access Path

 

DDS

SQL

DDL

 

 

DDS

Yes

No

No

 

 

SQL

Yes

Yes

Yes