Commands (YCLRMDL - YDLTOBJTBL) › YCRTJOBLE (Create Job List Entry) Command › Notes

Notes

• If the object and its auxiliaries already exist on the target job list, the status is set to that which is defined on the command. However, note that in certain cases the command will not be able to convert. For example, if the object is currently being generated, then it would not be appropriate to adjust its status. If unable to convert an existing job list entry, an exception message is sent.
• Model objects can either be identified by object name (OBJNAM) or by object surrogate key number (OBJSGT). If the OBJNAM parameter is used, the processing program must convert to surrogate key number internally. Thus, it will normally be more efficient to use the surrogate number if this value is available. The surrogate number for an object can be obtained using the Retrieve Model Object command (YRTVMDLOBJ).
• When you to try to place a *DDL-based access path on to a job list for regeneration and/or compilation, and the access path has either of the four DDL limitations, the entry is not added to the job list. The access path source is not generated.
• 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.