You run an SQL script to create database objects for the index. Depending on what kind of collation key index you are creating (single or multiple tag per record, or authority or bib), you will run an SQL script to create database objects necessary for the index to work. Before you run the script, you need to make changes to the script for your specific table name. You need to change the table name in the script to the name of the table you are creating for your database.
You complete all the steps in this task using your SQL query tool. Make sure to watch for errors as you run your query.
To create database objects for the index
1 | Open your SQL query tool. |
2 | Connect to your Horizon database. |
3 | From your Horizon installation CD, copy and paste the three SQL text files in the Utils directory to your hard drive. |
4 | In your SQL query tool, open one of the SQL text files: |
If you are creating this type of index |
Open this file |
Single tag authority index |
SingleTagAuthColKeyIndexTemplate.SQL |
Single tag bib index |
SingleTagBibColKeyIndexTemplate.SQL |
Multiple tag bib index |
MultiTagBibColKeyIndexTemplate.SQL |
This is the query that will create the necessary database objects for your new index.
5 | Search for all instances of the dollar sign ( $ ) character and replace them with the name of your new table. (For example, if you are creating a vernacular titles browse index, you may want to name your table vn_title.) |
Note: In this step, you are putting your table name in the script, so when you run it, your database will create the new table, including the columns, triggers, and a stored procedure for the new index. You may also want to make a note of this table name because you will need to use this table name in subsequent tasks.
6 | Execute the query. |
7 | Run a query to verify that you created the new index table. |
For example, run this query:
select * from vn_title
© 1998-2017 Sirsi Corporation