Database type to attribute type mapping

Use attribute types to define query tables in Business Process Choreographer, when you run queries on the query tables, and to access values of a query result.

The following table describes the database types and their mapping to attribute types:

Table 1. Database type to attribute type mapping
Database type	Attribute type
A binary type with 16 bytes. This is the type used for IDs such as TKIID on TASK of the Business Process Choreographer tables.	ID
A character based type. The length depends on the column in the database table that is referenced by the attribute of the query table.	STRING
An integer database type, such as integer, short, or long.	NUMBER
A timestamp database type.	TIMESTAMP
A decimal type, such as float or double.	DECIMAL
A type that is convertible to a Boolean value, such as a number. 1 is interpreted as `true`, and all other numbers as `false`.	BOOLEAN

Supplemental query tables typically refer to existing database tables and views, such that table or view creation is not necessary.

Example

Consider a table in a DB2 environment, CUSTOM.ADDITIONAL_INFO, which is to be represented in Business Process Choreographer as a supplemental query table. The following SQL statement creates the database table:

CREATE TABLE CUSTOM.ADDITIONAL_INFO
(
  PIID       CHAR(16) FOR BIT DATA,
  INFO       VARCHAR(220),
  COUNT      INTEGER
);

The following mapping of database column types to query table attribute types is used for a supplemental query table for the CUSTOM.ADDITIONAL_INFO table.

Table 2. Database types to attribute types mapping example
Database column and type	Query table attribute and type
PIID CHAR(16) FOR BIT DATA	PIID (ID)
INFO VARCHAR(220)	INFO (STRING)
COUNT INTEGER	COUNT (NUMBER)