Run The Copy Workflow Process Templates DB Process

After you have a "copy workflow process templates" DB process in the target database, you should add a table rule to its primary instruction to define which workflow process template(s) to copy from the demonstration database. For example, if you want to copy a single workflow process template called CI_​DAILY, you would have the following table rule:

  • Table: CI_​WF_​PROC_​TMPL (WF Process Template)
  • Override Condition:#CI_​WF_​PROC_​TMPL.WF_​PROC_​TMPL_​CD = 'CI_​DAILY'

If you do not introduce this table rule to the primary instruction of the DB process, ALL workflow process templates in the demonstration database will be copied to the target database (and this may be exactly what you want to do).

Note: Tables rules are WHERE clauses. A table rule is simply the contents of a WHERE clause except the tables names are prefixed with #. This means that you can have table rules that contain LIKE conditions, subqueries, etc.

At this point, you're ready to submit the background process identified on your "copy workflow process templates" DB process. This background process highlights the differences between the workflow process templates in the demonstration database and the target database (the target database is the environment in which you submit the background process).

Note: The background process you submit is typically named the same as the DB process that contains the rules. If you used the CL-COPDB background process to transfer the "copy workflow process templates" DB process from the demo database, it will have also configured a batch control and linked it to the "copy workflow process templates" DB process. This batch control has the same name as its related DB process (this is just a naming convention, it's not a rule). This means that you'd submit a batch control called CI_​COPWF in order to execute the CI_​COPWF DB process.

When you submit the CI_​COPWF background process, you must supply it with an environment reference that points to the source database (i.e., the demonstration database).

When the CI_​COPWF process runs, it simply highlights differences between the workflow process templates in your source database and the target database. It creates a root object in the target database for every workflow process template that is not the same in the two environments (actually, it only concerns itself with workflow process templates that match the criteria on the table rule described above).

Note: Auto approval. When you submit CI_​COPWF, you can indicate that all root objects should be marked as approved (thus saving yourself the step of manually approving them).

After you've approved the root object(s) associated with the workflow process template(s) that you want copied, submit the CL-APPCH batch process to cause your target database to be changed. You must supply the CL-APPCH process with two parameters:

  • The DB process of the "copy workflow process templates" DB process (i.e., CI_​COPWF)
  • The environment reference that identifies the source database (i.e., the demonstration database)