Lookup Table - General

FieldDescription

Lookup Name

Name of the lookup table.

Case sensitive

Defines whether the sort will be case sensitive.

Suppress messages during creation

Suppresses the message Loading lookup array… when the command executes. Selecting this option also suppresses the warning message stating the number of duplicate keys found.

Set initial size

Optional: Initial size of the lookup table in rows. If not specified, Production Reporting uses a value of 100.

Set growth size

Optional: Amount by which to increase the array when it becomes full. If not specified, Production Reporting uses 25% of the value defined in the Set initial size field.

Related Topics

Creating Lookup Tables