Application and Database Design Guide

10.0
- 10.5 HotFix 1
- 10.5
- 10.2 HotFix 1
- 10.2
- 10.1
- 10.0 HotFix 1

Back Next

Generating keys for Simple Search

Before you implement a simple search, the keys required by the search must be generated:

Identify the data that you need to search. For example, you might need to search employee records in a database table EMPLOYEE stored in columns NAME and ADDRESS.

Generate SSA-NAME3 keys for data in these columns. Ensure that separate calls are made to

ssan3_get_keys

for each column.

Save the SSA-NAME3 keys along with a reference to the EMPLOYEE record. In the previous example, the keys for NAME, and ADDRESS should be stored in a single database table. An optional type indicator may be stored in this table to contain information about the type of entity such as

Person_Name

or Address and the index was generated from.

Simple Search Application Design

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal