Configuring a virtual table

Edit online

Configure a virtual table for the IMS metadata that you want to access.

Procedure

To configure a virtual table, complete the following steps:
  1. On the navigation menu, click Manage accel loader > Create virtual table.
    The Create virtual table page opens.
  2. In the Virtual table configuration section, provide the following information:
    Name
    Enter a unique name.
    Note: The name can contain a maximum of 50 characters. The name must begin with an uppercase letter followed by zero or more characters (uppercase alphanumeric or underscore).
    Metadata library
    Select the target library where the virtual table metadata needs to be stored.
    Note: The target libraries are specified in the started task JCL of the server.
    Convert VAR* field to True VAR* fields
    This is an optional field. The True VAR fields have data fields with a length of 2 bytes that precede the data.
    Array handling
    Select one of the following options:
    • Flatten array as a single fixed table at runtime (Y) - Select the radio button to support both OCCURS and OCCURS DEPENDING ON statements.
    • Return array as separate table at runtime (N) - Select the radio button to support both OCCURS and OCCURS DEPENDING ON statements. A sub-table is generated for each array, which supports SQL READ access only.
  3. Click Next.