With SESAM/SQL-Server, it is possible to restrict internal file searches to certain CATIDs. To do this, you enter the required CATIDs in a file in list form. You can then assign this file to the DBH using the ADD-FILE-LINK command and the link name SESAMCID.
The CATID list is evaluated the first time a file is accessed. Any changes to the file take effect when the DBH is restarted or the administration statement MODIFY-CATID-LIST is issued. The CATID list is output using the administration statement SHOW-CATID-LIST (see the “Database Operation” manual).
To create a CATID list, you must use a SAM file with variable record length. Each record may contain only one CATID which is 1 to 4 characters in length. Only the characters A ... Z and 0 ... 9 are permitted (no colons or spaces). A maximum of 50 CATIDs can be evaluated. No wildcards may be specified.
SESAM/SQL does not check that the contents of the CATID file are correct. If the file contains syntactically incorrect entries or CATIDs that are not known to the BS2000 system then an error message is output to SYSLST. If the CATID file is empty then only the default pubset is used.
The CATID of the default pubset for the user ID must always be present in the list. If the user does not specify the CATID of the default pubset then it is automatically entered by SESAM/SQL.
If a new file is to be created, SESAM/SQL uses the following procedure to check whether this file already exists:
SESAM/SQL searches the file for all the CATIDs in the CATID list. If the file is found for one of the CATIDs then it is not newly created but used as it is.
If the CATID of the file that is to be created is not in the CATID list, an error message is output.
If the CATID of the file that is to be created is present in the CATID list and the file is not present for any CATID in the CATID list then it is newly created.
If the file searched for cannot be assigned unambiguously, a message to this effect is issued.
You should assign the utility monitor the same CATID list as the DBH to ensure that the same data is accessed in all cases.
You assign the CATID list to the utility monitor using the ADD-FILE-LINK command and the link name SESAMCID. The CATID list is evaluated the first time a file is accessed. Changes in the CATID list do not take effect until the utility monitor is restarted. You use the administration statement MODIFY-CATID-LIST to edit the DBH's CATID list. This command does not affect the CATID list that was assigned to the utility monitor.