dspCompose
Create all tt Tables and tx Views for the Integrate Process
Before performing this task, create a looped template and process in Integrate. Refer to Configure Process Template Loops for a BDC Script Template with Looping Enabled or Configure Process Template Loops for a GUI Script Template with Looping Enabled in Integrate for more information.
Create the tt tables and tx views for the each loop -- header and detail data -- manually or by using the Auto Generate functionality in Integrate. Refer to Generate Database Objects Automatically for more information.
Tables and views may be created in cMass_Data or any database that has a supporting component and data source registered in the DSP®.
If using auto-generated tables, add these columns to each tt table. If manually generating the tables, include these columns:
NOTE: ID column must be set as the PrimaryKey of the tt Table.
Column Name |
Data Type |
Value |
RequestID NOTE: Place this column underneath the ID and ParentID columns. |
int |
NULL |
PostError |
int |
NULL DEFAULT (2) |
PostMessage |
nvarchar (max) |
NULL DEFAULT '' |
boaStatus |
int |
NULL |
ValidationErrorMessage |
nvarchar (max) |
NULL |
Severity |
int |
NULL |
Reject |
bit |
NULL DEFAULT (0) |
RejectReason |
nvarchar (max) |
NULL |
RejectedBy |
nvarchar (50) |
NULL |
LockReject |
bit |
NULL |
Continue with Create rt Tables from the tt Tables.