Parameter statement descriptions
IDMSRSTC utility processing is controlled by the following input parameter statements:
|
Statement |
Description |
|---|---|
|
SIGNON |
Initiates IDMSRSTC processing |
|
SCHEMA |
Identifies the old and new schemas to be compared |
|
SIGNOFF |
Terminates IDMSRSTC processing |
Coding considerations
You must code the IDMSRSTC input parameter statements in uppercase between columns 1 and 72, inclusive. Each statement must end with a period.
SIGNON statement
Must be the first parameter statement you submit to IDMSRSTC.
SCHEMA statement
You can include any number of SCHEMA statements.
SIGNOFF statement
The SIGNOFF statement must be the last parameter statement.
SIGNON statement
The SIGNON statement initiates IDMSRSTC processing and optionally specifies a user identifier and password.
Syntax
►►─── SIGnon ─────────────────────────────────────────────────────────────────► ►─┬───────────────────────────────────────────────────────────────────┬──────► └─ USEr name ─┬─ is ─┬─ user-id ─── PASsword ─┬─ is ─┬─ password ───┘ └─ = ──┘ └─ = ──┘ ►─── . ──────────────────────────────────────────────────────────────────────►
Parameters
Identifies a user defined in the user catalog. The specified user must have the authority to access the schemas named in the IDMSRSTC run.
If no USER ID is specified, USER ID is the user known to the execution environment. If SIGNON OVERRIDE is not allowed in the dictionary, USER ID, if specified, must be the same as that known to the execution environment.
IS and = are synonyms and can be used interchangeably.
Specifies the password associated with the user identified in the USER parameter. If the password contains embedded blanks, you must enclose it in site-standard quotation marks.
You must include the PASSWORD parameter if the user specified in the USER parameter is associated with a password in the dictionary, unless the USER ID is the same as the user known to the execution environment. In this case, the password is ignored.
IS and = are synonyms and can be used interchangeably.
SCHEMA statement
The SCHEMA statement identifies an old schema and a new schema to be compared by IDMSRSTC. For each SCHEMA statement you submit, IDMSRSTC generates a set of IDMSRSTT macro statements. Each set of macro statements begins with IDMSRSTT BUFSIZE and ends with END.
Syntax
►─── OLD SCHema name is old-schema-name ─────────────────────────────────────► ►─┬───────────────────────────────────┬──────────────────────────────────────► └─ Version is ─┬─ version-number ─┬─┘ ├─ HIGhest ────────┤ └─ LOWest ─────────┘ ►─── NEW SCHema name is new-schema-name ─────────────────────────────────────► ►─┬───────────────────────────────────┬──────────────────────────────────────► └─ Version is ─┬─ version-number ─┬─┘ ├─ HIGhest ────────┤ └─ LOWest ─────────┘ ►─── . ──────────────────────────────────────────────────────────────────────►
Parameters
Specifies the name of a schema that describes the database before restructuring.
Old-schema-name must identify a schema defined in the data dictionary.
Qualifies the old or new schema name with a version number.
If you omit the VERSION parameter for the old or new schema, IDMSRSTC uses the dictionary default version number for existing entities.
Explicitly specifies the schema version number.
Directs IDMSRSTC to use the highest version number assigned to the named schema.
Directs IDMSRSTC to use the lowest version number assigned to the named schema.
Specifies the name of a schema that describes the database after restructuring. New-schema-name must identify a schema defined in the data dictionary.
SIGNOFF statement
The SIGNOFF statement terminates IDMSRSTC processing.
SIGNOFF, BYE, and LOGOFF are synonyms and can be used interchangeably.
Syntax
►─┬─ SIGNOFF ─┬─ . ──────────────────────────────────────────────────────────►◄ ├─ BYE ─────┤ └─ LOGOFF ──┘
|
Copyright © 2014 CA.
All rights reserved.
|
|