Siebel Database Upgrade Guide for DB2 for z/OS > Planning for a Dev to Test to Production Using Siebel Migration >

About Siebel Rules Expression Designer

Environments: Development, production test, production.

Platforms: Windows, UNIX, IBM z/OS.

Use Siebel Rules Expression Designer to create the following transformation rule file and input file for your migration:

• Migration rule file. A migration rule file (.rul) contains data transformation rules that are executed during an export. On the target environment, the exported data file will contain the transformed data values.

  A rule file consists of a list of tables along with the columns for which a default value is specified. Only direct substitutions are allowed for a column. The column can be of any datatype.

  For a rule file, you can specify a WHERE clause which applies the transformation only to the records which satisfy the WHERE clause criteria. The WHERE clause can have filters only with the values.

  For Update Actions, the following are the transformation rules for rule file:

  • Supports only the equal (=) relational operator.
  • Supports only the AND logical operator.
  • You can add a WHERE clause to filter the data and apply the transformation rule only to those records matching the WHERE clause.
  • Supports multiple rules. Each rule will be delimited by the semicolon character.
  • If you use more than one field, then use an AND logical operator.
• Input file. An input (.inp) file is an input file for the selective export of data. Only the tables mentioned in the input file are exported. Record level filters can be applied based on the columns. In addition, a single WHERE clause is supported for every table in the Input file. A WHERE clause can consist of any number of columns combined using OR or AND operators.

  For Conditions, the following are the filter rules for input files:

  • Supports any relational operator that a database query would support. For example, = is equal, != or <> is not equal, > is for less than.
  • Only the AND logical operator is supported.

After the migration rules are created, use Siebel Rules Expression Designer to validate the new rules.

Related Topics:

Creating Migration Rules