Filter
Top Products
Chapter 7 Section 7.2
Implementing the VSAM eWay Sample Projects Running the Sample Projects
VSAM eWay Adapter User’s Guide 64 Sun Microsystems, Inc.
7.2 Running the Sample Projects
The following steps are required to run the sample projects that are contained in the
VSAMeWayDocs.sar file.
1 Run the SQL script.
This creates the tables and records required by the sample Project.
2 Import the sample Projects.
3 Build, deploy, and run the sample Projects.
You must do the following before you can run an imported sample Project:
Create an Environment
Configure the eWays
Create a Deployment Profile
Create and start a domain
Deploy the Project
4 Check the output.
7.3 Running the SQL Script
The data used for both the JCD and BPEL sample Projects are contained within a table
called CICSEMP. You create this table by using the SQL statement
VSAM_sample_script.sql, that is included in the sample Project. Note that you must
use a database tool to run the script.
Following is the SQL statement designed for the sample Projects.
drop table CICSEMP
go
create table CICSEMP (
ENAME CHAR(20),
PHONE INTEGER(4),
MAILID CHAR(6),
SALARY DECIMAL(7,2),
JOBID FLOAT(4),
EMPID INTEGER(4),
DEPTID SMALLINT(2),
DEPARTMENT CHAR(15))
go
The sample Projects provided with the VSAM eWay use input files to pass predefined
data or conditions into the Collaboration or BPEL business process, which then
transforms the database contents, and delivers the result set.