SIGNON TABLE

SIGNON TABLE allows you to efficiently process multiple requests against a single ASF table.

Access mode:The syntax below is invalid when the access switch is set to IDMS.

Syntax:

►►─── SIGnon TABle ─┬─────┬─┬─ asf-table-name ─┬──────────────────────────────►
                    └─ = ─┘ └─ view-id ────────┘

 ►─┬─────────────────────────────────────┬────────────────────────────────────►
   └─ CATalog ─┬─────┬─ dictionary-name ─┘
               └─ = ─┘

 ►─┬──────────────────────────────────────┬───────────────────────────────────►
   └─ LOCation ─┬─────┬─ dictionary-node ─┘
                └─ = ─┘

 ►─┬──────────────────────────────┬───────────────────────────────────────────►
   └─ OWNer ─┬─────┬─ owner-name ─┘
             └─ = ─┘

 ►─┬──────────────────────────┬───────────────────────────────────────────────►◄
   └─ VIEw ─┬─────┬─ view-id ─┘
            └─ = ─┘

Parameters:

asf-table-name—A 1 to 32-character alphanumeric table name.
view-name—A 1 to 8-character alphanumeric table view ID.

CATALOG= dictionary-name: Specifies the name of the dictionary containing the catalog entry for the named ASF table.
LOCATION= dictionary-node: Specifies the name of the Distributed Database System (DDS) node controlling the named dictionary.
OWNER= owner-name: Specifies the user ID for the owner of the ASF table. If owner-name isn't specified the current user ID is used.
VIEW= view-id: Specifies a user-supplied label identifying the subschema. View-id is a 1 to 8-character label used to qualify entity names.

Example:

This example show a user signon to an ASF table and the CA OLQ response. The ASF table name and owner name are supplied in the signon command:

signon table=employee owner=dmc

OLQ 100021 00  Ready to retrieve data from subschema RU000426
OLQ 100022 00 Schema:    IDMSR          Version:       1
OLQ 100023 00 Database name:    ASFDICT
OLQ 100025 00 Dictionary name:  ASFDICT