Join Query

The query activity submits a join query to a join set on a TIBCO Patterns server to retrieve a record set.

General

The General tab has the following fields:

Join Query Configuration Fields

Field

Module Property?

Description

Name

No

The name of the activity within the process. The default value is join_query.

Patterns Connection

Yes

The path to the shared configuration resource which contains the Patterns Connection information. See Activities Connection.

Show Tables

No

The Show Tables button displays information on existing tables, thesauri, character maps, and learn models that may be useful during query design.

Description

Provide a short description for the Join Query activity.

Input

The Input tab has the following fields:

Join Query Input Fields

Input Item

Description

ParentTableName

Name of the parent table to join.

ChildTable

One per child in the join.

ChildTable/Name

Name of the child table.

ChildTable/Alias

Alias of the child table. Child table aliases are all-or-nothing. Aliases are required if a child table is used more than once. If present, child aliases must be unique.

SingleParentMode

Set to true() if a parent record can have at most one match result.

Set to false() if the parent record can have multiple match results.

AllowOrphans

Set to true() to allow match results with missing parent records.

AllowPartials

Set to true() to allow match results with missing child records.

GpuIndexing

Set to false() to disable GPU harnessing for the query even if the table was created with GPU support. Set to true() to attempt to use GPU harnessing for the query; this fails if the table was not created with GPU harnessing.

GpuCallParallelism

The number of GPU channels to use when processing the query. The Patterns Server calculates a default value; setting this may improve performance in some situations, but usually degrades performance.

TableBlocksPerGpuCall

The number of memory blocks to use per GPU unit. The Patterns Server calculates a default value; setting this may improve performance in some situations, but usually degrades performance.

For information on other inputs, see Query Input Fields.

Output

See Query Output.