This statement updates the CATID list.
Scope of validity
DBH administration
Function
It is possible to specify a CATID list. This list limits the internal search for files to the CATIDs specified in this list. It can have a positive effect on the performance of the system, since it is no longer necessary to include all CATIDs in the search. However, performance is, of course, also dependent on the length of the specified list. When specifying a CATID list, note that a maximum of 50 CATIDs are evaluated.
The DBH takes the CATID list from a file. You can use the MODIFY-CATID-LIST statement to cause the DBH to take a new CATID list or to stop evaluating an existing CATID list. The modification takes effect the next time a file is opened in the DBH.
If the DBH has already been assigned a file with a CATID list in the start procedure by means of the ADD-FILE-LINK command, this list takes effect at the startup of the DBH.
The CATID of the default pubset must be contained in the CATID list. If this CATID is not in the list, the DBH adds it to the list. In addition, a warning is issued.
The file that contains the CATID list must be a SAM file and can, for example, be created with the file editor EDT (see the manual “ EDT (BS2000) Statements”). The defined record length must be variable. There is a CATID without colons or blanks in each row. The CATID can be between 1 and 4 characters in length. After the descriptions of the operands below you will find an example of a CATID list created with EDT.
MODIFY-CATID-LIST |
FILE-NAME = *STD / *NONE / <filename 1..54> |
Operands
FILE-NAME =
Name of the file that contains the CATID list
FILE-NAME = *STD
By default, the CATID file assigned to the DBH at the time of the administration statement with the link name SESAMCID is used.
FILE-NAME = *NONE
No CATID list is transferred. Any existing CATID list in the DBH is deleted. The DBH searches for all CATIDs. This is what happens in the versions up to and including version 3.0.
FILE-NAME = <filename 1..54>
Name of the file that contains the new CATID list. If a CATID list is already active, the file specified here must be in the same pubset as the file of the active list.
The administration statement is rejected if the CATIDs of the currently open database files are not contained in the new CATID list specified.
Example
CATID list created using the EDT file editor:
2OGB 2OGE B321 3OAM 3OLR C245 L324 LO21 2KL3 PL34 PO54 P567 P123 P425 OL43
Administration command in ISP format and at the CALL DML interface
The UPD,CID-LIST administration command corresponds to the MODIFY-CATID-LIST administration statement here.
UPD,C[ID-LIST],file
file ::= {NONE|STD|FILE=filename}
filename must comply with BS2000 conventions. In INFORM-PROGRAM administration you must adhere to the permissible length for filename (see section “Administration using INFORM-PROGRAM”).