Thank you for your feedback.
Form temporarily unavailable. Please try again or contact to submit your comments.
  • London
  • Kingston
  • Jakarta
  • Istanbul
  • Helsinki
  • Geneva
  • Store

Append two tables

Append two tables

You can use the Union table operation to append two tables of the same format.

About this task

Appending two tables adds the second table at the end of the first table and places the results in the additional, target table. If necessary, you can specify one of the source tables as the target table.


  1. On the Identification or Connectivity Sections form, select Union table from the Operation list.
  2. Fill in the fields, as appropriate.
    Field Description
    First table Specify the name of the first source table.
    Second table Specify the name of the second source table.
    Target table Specify the name of the table into which the results are placed.


The following configuration is an example of the Union table operation.
Field Value
Hierarchy Applications > Application Servers
CI Type WebSphere EAR
Pattern J2EE EAR on Linux
Section Oracle JDBC connectivity
Step number and Name 5. Union JDBCProviders with JDBCProviders2

What to do next

Finalize a pattern