Verb: Access/TCL

Command Verb: Access/TCL
Applicable release versions: AP
Category TCL (746)
Description searches every file in the Pick file system for the existence of one or more strings of characters in any attribute and optionally creates and saves a list. If an md name is provided, only that account is searched.

It scans each item in each file looking for a string match in any attribute. If a match is found, it displays the item-id, and the attribute containing the matching string. Any number of unique strings may be specified. The search is successful if any one string matches any portion of the attribute.

This process prompts with the following messages:

enter the output file name?

Enter the name of the file where the found items will be saved (it must already exist). As items are found, "control" items are added to the "output file", using sequentially-assigned numeric item-ids beginning with 1.

enter the search string?

Enter the string(s) without any enclosing delimiters. The system will repeatedly ask for additional "strings". A "?" (question mark) may be used for a "wildcard" character in the string. Up to 15 different strings can be specified.

The "?" (question mark) character may be used for a "wildcard" search character. To locate a string which contains a "?", enter as "??" (two question marks). After the last string has been entered, a <return> at the "...string?" prompt advances to the next prompt.

START LEVEL 0-Mds, 1-Master Dictionary, 2-File Dictionary, 3-Data File?

This tells the process at which "level" of the file system to begin the search. "search-system" has hierarchial level control. The four levels are:

MDS, MD, Dict File, Data File.

Any range can be specified. A data file search can also be specified to search system-wide horizontally

Enter the "level" to begin the search.

| 0 |
| MDS |
| System |
| Master Dict |
+-------------+ +-------------+
| 1 | | 1 |
| MD | | MD |
| Account | | Account |
| Master Dict | | Master Dict |
+-------------+ +-------------+
+---------+ +-----------+ +-------------+ +----------+
| 2 | | 2 | | 2 | | 2 |
| File | | File | | File | | File |
| Dict | | Dict | | Dict | | Dict |
+---------| |-----------| |-------------| |----------|
| 3 | | 3 | | 3 | | 3 |
| File | | File | | File | | File |
| Data | | Data | | Data | | Data |
+---------+ +-----------+ +-------------+ +----------+

Next, the system asks either:

STOP LEVEL 0-Mds, 1-Master Dictionary, 2-File Dictionary, 3-Data File?


LATERAL LEVEL 0-Mds, 1-Master Dictionary, 2-File Dictionary, 3-Data File?

This is the level to continue the search to. The routine can either traverse a single branch of the hierarchy (such as a single account and all its files), or it can traverse "laterally" across the branches (such as all the data files ONLY of all the accounts). The STOP/LATERAL level must be equal to or lower than the START level.

Output is an item of the format:

001 mds (account name)
002 dict, data file name
003 item-id
004 attribute number in which text was found
005 attribute text
006 the search string
Syntax search-system {destination.file} {(options)}
Options ? Displays on-line usage information about the process.

a Displays all items searched, including items in which the string was not found.

c Clears output file prior to execution.

m Checks for multiple occurrences.

p Directs output to system printer, via the Spooler.

s Suppresses display on crt.