WebSphere Message Brokers
File: tsba_creatingeventtablecolumns
Writer: Karen Cameron

Task topic

This build: July 31, 2007 21:41:00

Creating event table columns

Create the event table columns in the Siebel event table by using the event wizard in the Siebel application.

You must be familiar with the tools found in the Siebel application to create the event table.
An event table must be created in the Siebel application event component to track the events that occur in the Siebel enterprise information system.
  1. Create an IBM® project and lock your project, according to the Siebel instructions. Except for event triggers, you must complete all Siebel customization under the new project.
  2. If you are installing multiple connectors, create multiple tables with different names.
  3. Using the new object wizard, create a standalone table named CX_IBM2_Events.
  4. Create columns in your new table with the following names:
    • Column Name/User Name
    • Type
    • Length
    • Physical type
    • Required
    • Nullable
    • Status

The example below shows some typical column titles and along with their associated information.

Table 1. Event table column example
Column name/ user name Type Length Physical type Required Nullable Status
DESCRIP TION Data (public) 255 Varchar No Yes Active
EVENT_ ID Data (public) 30 Varchar Yes N/A Active
EVENT_ TIME STAMP Data (public) 7 Date Time Yes N/A Active
EVENT_ TYPE Data (public) 20 Varchar Yes N/A Active
OBJECT_ KEY Data (public) 255 Varchar Yes N/A Active
OBJECT_ NAME Data (public) 255 Varchar Yes N/A Active
PRIORITY Data (public) 10 Number No Yes Active
STATUS Data (public) 20 Number Yes N/A Active
XID Data (public) 255 Varchar No N/A Active
Create a business component in the event table.
Notices | Trademarks | Downloads | Library | Support | Feedback

Copyright IBM Corporation 1999, 2007Copyright IBM Corporation 1999, 2007. All Rights Reserved.
This build: July 31, 2007 21:41:00

tsba_creatingeventtablecolumns This topic's URL is: