You run an SQL script to create database objects necessary for your multi-source index. 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 MultiSrcCollationKeyIndexTemplate.txt file in the Utils directory to your hard drive. |
4 | In your SQL query tool, open the SQL text file. |
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 collation key uniform title index, you may want to name your table “ck_uniform_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 ck_uniform_title
© 1998-2017 Sirsi Corporation