EXPAND – LIST related objects

Whether to generate LIST statements for any database elements that might be required by a SELECTed database element.

NO
No, this is the default.
YES
It LISTs all items that are required by the object to work correctly. For example, an Application that is part of a Group needs the Group Definition; if it is an event triggered application it needs the ETT rule, any workstations, calendars or periods are also needed.

The following items are expanded by EXPAND(YES):

  • When an Application is SELECTed, it will LIST any ETT rule that references it, any Group Definition it is part of, any Calendar it references, any Period or Variable table referenced in a Run Cycle or Rule, and any Operator Instruction, Workstation or Special Resource referenced by an Operation.
  • When an Event Trigger is SELECTed, it will LIST the Application it will trigger, and the Special Resource if this is a Resource trigger.
  • When a Period is SELECTed, it will LIST any Variable Table it may reference.
  • When a Workstation is SELECTed, it will LIST any Virtual Workstation Destinations it may have.
FULL
LISTs the items covered by YES but will also LIST extra items not required to make the individual object work, but are referenced by it. The extra items include:
  • Applications referenced as external predecessors.
  • Members of application groups.

When you use OPTIONS EXPAND, any SELECT statements generated by a LIST statement with SELECT(Y) contains also a SELECT(Y) keyword. This means that any items identified by the LIST statement for the EXPAND generate a SELECT request. Using automatic EXPAND and SELECT together can result in Batch Loader being generated for all related objects.

Note:
  1. Applications LISTed by the EXPAND option use the keyword VALID(=) only to LIST the versions valid on the running day. The DATE option can be used to influence this.
  2. When OPTIONS EXPAND(YES|FULL) is set, DUPAUTO(NO) is also automatically set.