SSA-NAME3 API Reference Guide

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

Back Next

Combining multiple fields into one key

Build keys based on more then one SSA-NAME3 field for example Person_Name plus Code, Person_Name plus Address_Part1. Up to five fields may be combined into one composite key.

This produces a more selective key that speeds up searches at the cost of a higher number of keys.

FIELD=Field1,Field2 [...,Field5]

The input record can be specified using scatter gather or delimited format. To specify using the scatter gather format use the

LAYOUT= control

For example:

ssan3_get_keys

testpops

ausv102

FIELD=Person_Name,Address_Part1 Key_Level=standard,limited -

LAYOUT=Person_Name,0,10,Person_Name,11,13,Address_Part1,25,10

John Smith James Madison10 Rudd st

Composite Keys

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal

0 COMMENTS

We’d like to hear from you! Log in to comment.

Rename Saved Search

Table of Contents

SSA-NAME3 API Reference Guide

SSA-NAME3 API Reference Guide

Combining multiple fields into one key

Combining multiple fields into one key