Purpose
Specifies the name of the subschema to be accessed for database records and logical records.
Syntax
Col 2 ▼ ►►─── INput ─┬────────────────────────────────────────────┬───────────────────► └─ record-size ─┬─ F ◄ ─┬───┬──────────────┬─┘ ├─ V ───┤ └─ block-size ─┘ └─ U ───┘ ►─┬──PS ◄ ─┬───────────────────┬─────┬───┬─────────────────────┬─────────────►◄ │ └─ ( device-type ) ─┘ │ │ ┌─────────────────┐ │ ├─ IS ───┬───────────────────┬─────┤ └─▼─ input-options ─┴─┘ │ └─ ( device-type ) ─┘ │ ├─ CARD ───────────────────────────┤ ├─ VS ─┬──────────────────┬────────┤ │ └─ ( ─┬─ KS ─┬─ ) ─┘ │ │ ├─ ES ─┤ │ │ └─ RS ─┘ │ │ ┌──────────────────────────────┐ │ └─▼─┬─ UM ( module-name ) ──────┬┴─┘ └─ DB ─┬───────────────────┬┘ └ ( database-code ) ┘
Expansion of Input-options
►►─┬─ SS = subschema-name ─┬───────────────┬──┬───────────┬──┬───────────────►◄ │ └─ schema-name ─┘ └─ version ─┘ │ └─ PW = password ─────────────────────────────────────────┘
Syntax Rules
Except as described below, the syntax rules presented under INPUT Parameters apply to CA IDMS/DB database record access. Special syntax rules for CA IDMS/DB database record access follow:
Specifies the number of bytes CA Culprit reserves for the input buffer. Record-size is an integer in the range 1 through 32,760; the default is 1000 for a CA IDMS/DB database.
Depending on whether the PATH parameter specifies database or logical records, the minimum size of the input buffer is calculated as follows:
Specifies the name of an input user module. CULLDCLI is the name of the CA Culprit module for access to CA IDMS/DB. CA Culprit automatically supplies this name on the Input Parameter Listing.
Specifies that CA Culprit is to access database or logical records. Database-code is a 1-character alphanumeric value that indicates the database to be accessed, as follows:
|
Code |
What it does |
|---|---|
|
D |
(default) Specifies CA IDMS/DB database record access. |
|
I |
Specifies IMS (DL/I) database access. Note: For more information about accessing an IMS database, see the CA Culprit IMS Supplement. |
|
R |
Specifies RDMS database access. Note: For more information about accessing an RDMS database, see the CA Culprit RDMS Supplement. |
|
T |
Specifies TIS (formerly called TOTAL) database access. Note: For more information about accessing a TIS database, see the CA Culprit/TOTAL Supplement. |
Represents coding options that can be specified on an INPUT parameter that accesses database or logical records. See explanation of expanded syntax below.
Identifies the subschema view to be accessed.
A 1- to 8-character alphanumeric value that identifies the name of the subschema to be accessed. This value is required for database access.
A 1- to 8-character value that identifies the schema when subschema-name is associated with more than one schema in the data dictionary. This value may be required depending on the schema name option selected at installation; if the SCHMREQ option specifies N (the default), the user can omit the schema name.
Note: For more information about CA Culprit installation options, see the CA IDMS Installation Guide for your operating system guide.
Identifies the particular version of the schema to be accessed. The default is the highest existing version number for the schema specified.
Identifies a 1- to 8-character alphanumeric password that may be required by a user input module or a database access module.
If the password contains special characters (that is, anything other than letters, numbers, or hyphens), it must be enclosed in single quotation marks.
The value can also be expressed as a hexadecimal literal; for example, PW=X'0102030405'. Password does not appear on any CA Culprit listings.
When CA Culprit accesses database records, it copies the password into the PROGRAM-NAME field of the CA IDMS/DB communications block. Schema-defined database procedures or CA Culprit exit routines can use the PROGRAM-NAME field to validate security and other installation-dependent functions.
Note: For more information about the CA IDMS/DB communications block, see the CA IDMS DML Reference Guide for COBOL.
Examples
Sample INPUT parameters for accessing database or logical records are shown and described below.
Example 1
INPUT DB SS=EMPSS01,EMPSCHM,100
The INPUT parameter identifies CA IDMS/DB database records as the source of input for the CA Culprit run. The string of records returned to the input buffer must have a length less than or equal to 1000 bytes, which is the amount of space CA Culprit allocates for the input buffer by default. Because the subschema view (EMPSS01) is associated with more than one schema, a schema (EMPSCHM) is specified as well as a version number of the schema.
Example 2
INPUT 218 DB SS=EMPSS01 PATHAA DEPARTMENT EMPLOYEE
CA Culprit accesses database records that are defined in the EMPSS01 subschema. The size specified for the input buffer is the sum of the following items:
Example 3
IN 210 DB SS=EMPLR PATHBB DEPT-EMPLOYEE-LR
In this example of the INPUT DB parameter, the input to the CA Culprit run is the DEPT-EMPLOYEE-LR logical record. The size specified for the input buffer is the sum of the following items:
|
Copyright © 2014 CA.
All rights reserved.
|
|