Set Where Syntax

Using Set, Clear and EOF Statements › Set Statements › Set Statement Conventions › The Set Where Statement › Set Where Syntax

Set Where Syntax

├── SET WHEre ─ ¤ ─┬──────────────┬─ ¤ ─ . ────────────────────────────────────┤
                   ├─┤ CCID ├─────┤
                   ├─┤ GENERATE ├─┤
                   ├─┤ ARCHIVE ├──┤
                   ├─┤ SPEC ├─────┤
                   └─┤ PRO ├──────┘

Expansion of CCID

                                                     ┌─ , ────┐
├── CCId ─┬──────────────────────┬─┬───────────┬─ ( ─▼─ ccid ─┴─ ) ────────────┤
          └─ OF ─┬─ CURrent ◄ ─┬─┘ ├─ EQual ◄ ─┤
                 ├─ ALL ───────┤   └─ = ───────┘
                 └─ RETrieve ──┘

Expansion of GENERATE

├── GENerate ─┬─ FAIled ───────────┬───────────────────────────────────────────┤
              ├─┤ DATE ├───────────┤
              ├─┤ FROM ├───────────┤
              ├─┤ THROUGH ├────────┤
              └─┤ FROM - THROUGH ├─┘

Expansion of ARCHIVE

├──┬─┤ DATE ├───────────┬──────────────────────────────────────────────────────┤
   ├─┤ FROM ├───────────┤
   ├─┤ THROUGH ├────────┤
   └─┤ FROM - THROUGH ├─┘

Expansion of DATE

├── DATe ─┬─ EQ ─┬─ date ─┬────────────────────────┬───────────────────────────┤
          └─ = ──┘        └─ TIMe ─┬─ EQ ─┬─ time ─┘
                                   └─ = ──┘

Expansion of FROM

├── FROm ─ DATe ─┬─ EQ ─┬─ date ─┬────────────────────────┬────────────────────┤
                 └─ = ──┘        └─ TIMe ─┬─ EQ ─┬─ time ─┘
                                          └─ = ──┘

Expansion of THROUGH

├──┬─ THRough ─┬─ DATe ─┬─ EQ ─┬─ date ─┬────────────────────────┬─────────────┤
   └─ THRu ────┘        └─ = ──┘        └─ TIMe ─┬─ EQ ─┬─ time ─┘
                                                 └─ = ──┘

Expansion of SPEC

├──┬─ TEXt ─┬─ text-spec ───────────────────────────────────────┬─┬────────────┤
   │        │     ┌─ , ─────────┐           ┌─ , ─────────┐     │ │
   │        └─ ( ─▼─ text-spec ─┴─┬─ AND ─┬─▼─ text-spec ─┴─ ) ─┘ │
   │                              └─ OR ──┘                       │
   └─ ACM ─┬─ comp-spec ───────────────────────────────────────┬──┘
           │     ┌─ , ─────────┐           ┌─ , ─────────┐     │
           └─ ( ─▼─ comp-spec ─┴─┬─ AND ─┬─▼─ comp-spec ─┴─ ) ─┘
                                 └─ OR ──┘

Expansion of PRO

                                  ┌─ , ──────────┐
├── PROcessor GROup ─┬─ EQ ─┬─ ( ─▼─ group name ─┴─ ) ─────────────────────────┤
                     └─ = ──┘

SET WHERE CCID: The SET WHERE statement applies to each element action that uses-but does not contain all or part of-a WHERE clause, and remains in effect until the system encounters another SET WHERE statement or a CLEAR statement, or processing ends. There are two forms of WHERE CCID SCL:

WHERE CCID ccid-Limits processing to only those elements that match one of the CCIDs coded.

WHERE CCID OF ccid-Also limits the processing to those elements that match one of the supplied CCIDs. With this SCL, however, you can indicate where you want CA Endevor SCM to look for the CCID(s):

CURRENT-Tells CA Endevor SCM to look through the CCID fields in the MCF (Master Control File) to find a specified CCID(s). This is the default.
ALL-Tells CA Endevor SCM to search both the Master Control File and the SOURCE DELTA levels for a specified CCID(s). If you have ACM, CA Endevor SCM also searches the COMPONENT LIST DELTA levels for the specified CCID(s).
RETRIEVE-Tells CA Endevor SCM to use the CCID in the Master Control File's RETRIEVE CCID field.

You can use a name-mask with the CCID.

If you need to select elements identified under more than one CCID, you can specify multiple CCIDs by enclosing the CCIDs with parentheses and separating them with commas. The CCIDs may extend over multiple lines if necessary.

The examples below illustrate the two forms of WHERE CCID SCL.

Example 1: WHERE CCID EQ PROJ00*
Example 2: WHERE CCID OF CURRENT (PROJ001, PROJ002, PROJ004)
Example 3: WHERE CCID OF ALL (PROJ00*)

SET WHERE GENERATE

WHERE GENERATE SCL allows you to set a generation date and, optionally, time as a selection criterion. There are five possible forms for this clause:

WHERE GENERATE FAILED-Tells CA Endevor SCM to list only those elements for which the generate processor failed.
WHERE GENERATE DATE mm/dd/yy TIME hh:mm-Tells CA Endevor SCM to select only those elements with this generate date, and optionally, this time stamp.
WHERE GENERATE FROM DATE mm/dd/yy TIME hh:mm-Tells CA Endevor SCM to select all elements with a generate date and, optionally, a time stamp on or after the specified date and time stamps.
WHERE GENERATE THROUGH DATE mm/dd/yy TIME hh:mm-Tells CA Endevor SCM to select all elements with a generate date and, optionally, a time stamp earlier than and including the specified date and time stamp.
WHERE GENERATE FROM DATE mm/dd/yy TIME hh:mm THROUGH DATE mm/dd/yy TIME hh:mm-Tells CA Endevor SCM to select only those elements with a generate date, and optionally, time stamps within the specified range.

The date(s) must be in mm/dd/yy format (leading zeros are not required). The time(s) must be in hh:mm format. If you enter a time in this clause, you must enter a date.

SET WHERE ARCHIVE

WHERE ARCHIVE SCL allows you to set an archive date and, optionally, time as a selection criteria. There are four possible forms for this clause:

WHERE ARCHIVE DATE mm/dd/yy TIME hh:mm-Tells CA Endevor SCM to select only those elements with this archive date, and optionally, this time stamp.
WHERE ARCHIVE FROM DATE mm/dd/yy TIME hh:mm-Tells CA Endevor SCM to select all elements with an archive date and, optionally, a time stamp on or after the specified date and time stamps.
WHERE ARCHIVE THROUGH DATE mm/dd/yy TIME hh:mm-Tells CA Endevor SCM to select all elements with an archive date and, optionally, a time stamp earlier than and including the specified date and time stamp.
WHERE ARCHIVE FROM DATE mm/dd/yy TIME hh:mm THROUGH DATE mm/dd/yy TIME hh:mm-Tells CA Endevor SCM to select only those elements with an archive date and, optionally, a time stamp within the specified range.

The date(s) must be in mm/dd/yy format (leading zeros are not required). The time(s) must be in hh:mm format. If you enter a time in this clause, you must enter a date.

SET WHERE TEXT

WHERE TEXT SCL limits a list to elements that contain (or do not contain) one or more specified 1- to 70-character text strings.

For example:

This example tells CA Endevor SCM to list all elements containing the text string "WO9- LINKAGE":
```
WHERE TEXT 'WO9-LINKAGE'
```
This example tells CA Endevor SCM to list all elements that contain the text strings "COPY COPY005" and "COPY COPY010" between columns 8 and 40 of the element source:
```
WHERE TEXT ('COPY COPY005' COLUMN 8 40 AND 'COPY COPY010' COLUMN 8 40)
```
This example tells CA Endevor SCM to list all elements that do not contain the text string "REMARKS" between columns 8 and 15 of the element source:
```
WHERE TEXT DOES NOT CONTAIN 'REMARKS' COLU.MN 8 15
```
This example tells CA Endevor SCM to list all elements that contain either the text string "M605SUB" or the text string "M607SUB" and do not contain the text string "M606SUB":
```
WHERE TEXT (('M605SUB' OR 'M607SUB')AND DOES NOT CONTAIN 'M606SUB')
```

Note: The WHERE TEXT EQUAL clause cannot be used withthe WHERE ACM clauses.

SET WHERE ACM

WHERE ACM SCL limits a list to component lists containing (or not containing) the designated component name. Wildcards are acceptable in the component name specification.

There are four clauses:

WHERE INPUT COMPONENT tells CA Endevor SCM to list only input components matching your entry. This is the default.
WHERE RELATED INPUT COMPONENT-tells CA Endevor SCM to list only related input components matching your entry.
WHERE OUTPUT COMPONENT tells CA Endevor SCM to list only output components matching your criteria.
WHERE RELATED OUTPUT COMPONENT-tells CA Endevor SCM to list only related output components matching your entry.
WHERE PROCESSOR COMPONENT tells CA Endevor SCM to list only processor components matching the criteria.
WHERE ALL COMPONENT tells CA Endevor SCM to list for matches within all three types of components.

Additional selection criteria for the component includes the following clauses.

THROUGH (THRU) comp-name-tells CA Endevor SCM to list elements within a specific range of component names. The range begins with the component name coded in the WHERE COMPONENTS clause, and encompasses all components up to and including the component specified in this clause. Wildcards are acceptable in the component name specification.
VERSION version-tells CA Endevor SCM to list elements containing components with a specific 1- to 99-character version number. The version number of the component may differ from the version number of the element with which it is associated.
LEVEL level tells-CA Endevor SCM to list elements containing components with a specific 0- to 99-character level number. The level number of the component can differ from the level number of the element with which it is associated.
ENVIRONMENT env name-tells CA Endevor SCM to list elements with components located in the specified environment. If you provide an environment name, you must also provide the following information:
- SYSTEM-1 to 8 characters
- SUBSYSTEM-1 to 8 characters
- TYPE-1 to 8 characters
- STAGE NUMBER-either 1 or 2
FILE (DDNAME) ddname-tells CA Endevor SCM to list elements whose:
- Input components originated from the specified DDname
- Output components were written to the specified DDname
- Components were produced by a processor step specified by and associated with the designated DDname
DSNAME data set name-tells CA Endevor SCM to list elements whose:
- Input components originated from the specified data set
- Output components were written to the specified data set
- Components were produced by a processor step specified by and associated with the designated data set

WHERE ACM comp spec {AND/OR} comp spec

This clause allows you to provide compound component selection criteria, using the same options as described above.

Note: The WHERE ACM clauses cannot be used with the WHERE TEXT clause.

WHERE PROCESSOR GROUP

WHERE PROCESSOR GROUP SCL allows you to select elements according to a specified processor group. You can use a name-mask when specifying the processor group name.

If you need to select elements identified under more than one processor group, you can specify multiple distinct processor group selectors by enclosing the processor groups with parentheses and separating them with commas. The processor groups may extend over multiple lines if necessary.

The examples below illustrate the use of this clause.

Example 1: WHERE PROCESSOR GROUP (COBVS, COBII)
Example 2: WHERE PROCESSOR GROUP (COBV)