Generating, Compiling, and Executing › Implementing Access Paths and Functions › Selecting All Access Paths for Batch Generation and Compilation

Selecting All Access Paths for Batch Generation and Compilation

The Display All Access Paths panel presents a list of all access paths in the design model. It lets you perform many design, control, and generation tasks for one or more access paths from one panel.

Select all of the existing access path designs for batch generation and compilation by typing a J in the Subfile selector next to each access path in the list.

Press Roll Up to display the next screen of access paths. Select all remaining access paths with a J.

Press Enter.

Limitation:

When you to take the G / J option to generate the access paths from the Display All Access Paths panel and the access path has either of the four DDL limitations, the generation is prevented. The access path source is not generated and no entry is added to the jobs list.

• The current implementation of the DDL generation mode is not valid for the following cases:
  • Access paths that have virtual fields
  • SPN access path
  • QRY access path
  • Multi-member files

  Workaround for Virtual Fields, SPN, and QRY Access Paths: If the earlier generation mode is *DDS, revert to it and regenerate the access path. You need not regenerate the functions that use this access path. If you want to have an SQL type database, regenerate the access path using *SQL generation mode. The functions using this access path must be regenerated.

  Workaround for Multi-Member Files: If you want to have more than one member for the access paths, revert to *DDS generation mode.

Note: If you want to change an access path, which is previously defined as *DDS with a MAXMBR compiler override, to *DDL, you must revert to *DDS generation mode and must remove the compiler override, and then change back to *DDL generation mode.