Commands and Syntax › SIGNON

SIGNON

SIGNON indicates to CA OLQ that a named subschema is to be used to perform retrievals. Associating a view-id with a subschema allows access to multiple subschemas during a retrieval.

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

When you enter SIGNON during a session in progress, CA OLQ releases all database currencies previously established and automatically signs you on to the new database view.

Note: Control key settings and session options maintain their values across subschema signons.

Syntax:

►►─── SIGnon ─┬─ SUBschema ─┬─┬─────┬─ subschema-name ────────────────────────►
              └─ SS ────────┘ └─ = ─┘

 ►─┬────────────────────────────────────────────────┬─────────────────────────►
   └─ SCHema ─┬─────┬─ schema-name ─┬─────────────┬─┘
              └─ = ─┘               └─ (version) ─┘

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

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

 ►─┬──────────────────────────────────┬───────────────────────────────────────►
   └─ DBName ─┬─────┬─ database-name ─┘
              └─ = ─┘

 ►─┬──────────────────────────────────┬───────────────────────────────────────►
   └─ DBNOde ─┬─────┬─ database-node ─┘
              └─ = ─┘

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

Parameters:

SUBSCHEMA= subschema-name

Identifies the subschema for the current CA OLQ session. The named subschema must exist as a compiled description in the data dictionary and as a load module in either the dictionary load area or in the load (core-image) library.

SCHEMA= schema-name (version)

Specifies the schema associated with the subschema:

• schema-name—The schema associated with the named subschema. Schema-name defaults to the schema under which the subschema was last compiled.
• (version)—The version number, in the range 1 through 9999, of the named schema. Version defaults to the highest version number existing for that schema. If specified, version must be enclosed in parentheses.

DICTNAME= dictionary-name

Specifies the dictionary from which CA OLQ takes record and set definitions.

Note: To determine which dictionaries and databases are available, use the DCMT DISPLAY DBNAME TABLE command of DC/UCF.

See the CA IDMS System Tasks and Operator Commands Guide. for details on the DCMT DISPLAY DBNAME TABLE command.

DICTNODE= dictionary-node

Specifies the Distributed Database System (DDS) node controlling the named dictionary.

DBNAME= database-name

Specifies the database from which CA OLQ retrieves data. DBNAME can identify a user database or a database dictionary.

DBNODE= database-node

Specifies the DDS node that controls the named database.

VIEW= view-id

Specifies an ID by which the subschema can be referred in retrieval commands. VIEW=view-id is required for retrieval from multiple subschemas.

Examples:

Default values for dictionary name, dictionary node, database name, and database node can be set with the DCUF SET DBNAME command, initiation of a CA OLQ session through the transfer control facility, or with the SET command.

Signon subschema

This example shows a user signon to a subschema and the OLQ response. A subschema (EMPSS01) and dictionary name (DOCUNET) are provided in the SIGNON command:

signon dic=docunet ss=empss01

OLQ 100021 00  Ready to retrieve data from subschema EMPSS01
OLQ 100022 00  Schema:    EMPSCHM          Version:     100
OLQ 100025 00  Dictionary name:  DOCUNET

Assigning a view ID to the subschema

This example shows a user signon to CA OLQ and the OLQ response. A subschema (EMPSS01) and subschema view ID (EMP1), and dictionary name (TSTDICT) are provided in the SIGNON command:

 signon ss=empss01 view=emp1 dic=tstdict dbname=data1!
  signon ss=empss01 view=emp2 dic=tstdict dbname=data2

  SIGNON SS=EMPSS01 VIEW=EMP1 DIC=TSTDICT
  OLQ 100021 00  Ready to retrieve data from subschema EMPSS01
  OLQ 100022 00  Schema:    EMPSCHM          Version:     100
  OLQ 100023 00  Database name:    DATA1
  OLQ 100025 00  Dictionary name:  TSTDICT
  OLQ 100027 00  View Id:   EMP1
  SIGNON SS=EMPSS01 VIEW=EMP2 DIC=TSTDICT
  OLQ 100021 00  Ready to retrieve data from subschema EMPSS01
  OLQ 100022 00  Schema:    EMPSCHM          Version:     100
  OLQ 100023 00  Database name:    DATA2
  OLQ 100025 00  Dictionary name:  TSTDICT
  OLQ 100027 00  View Id:   EMP2