Running the SQL Script

The data used for both the Java Collaboration Definition-based and Business Process Manager sample projects are contained within a table called db_employee. You create this table by running the SQL statement DB2_Sample_script.sql, that is included in the sample Project. Note that you must use a database tool to run the script.

The SQL statement designed for the sample projects, is as follows:

drop table db_employee
go
create table db_employee (
  EMP_NO int,
  LAST_NAME varchar(30),
  FIRST_NAME varchar(30),
  RATE float,
  LAST_UPDATE datetime)
go

The sample Projects provided with the Sun Adapter for DB2 use input files to pass predefined data or conditions into the Collaboration or Business Process, which then transform the database contents, and deliver the ResultSet.