Page 3 - Contents; Chapter 1; Introducing the VSAM eWay; Chapter 2; Installing the VSAM eWay
Contents VSAM eWay Adapter User’s Guide 3 Sun Microsystems, Inc. Contents Chapter 1 Introducing the VSAM eWay 7 About VSAM 7 About the VSAM eWay 8 eWay Operation 8 What’s New in This Release 8 About This Document 9 VSAM eWay Javadoc 9 Scope 10 Intended Audience 10 Text Conventions 10 Related Documen...
Page 4 - Chapter 3; Setting Properties of the VSAM eWay; Chapter 4; Using the VSAM eWay Database Wizard; Chapter 5; Using VSAM OTDs
Contents VSAM eWay Adapter User’s Guide 4 Sun Microsystems, Inc. Chapter 3 Setting Properties of the VSAM eWay 20 Creating and Configuring a VSAM eWay 20 Configuring the eWay Connectivity Map Properties 20 Transaction Support Levels Between Different Versions 22 Configuring the eWay Environment Prop...
Page 5 - Chapter 6; Using VSAM Operations; Chapter 7; Implementing the VSAM eWay Sample Projects
Contents VSAM eWay Adapter User’s Guide 5 Sun Microsystems, Inc. Delete Operations 51 Using Views 52 Using Prepared Statements 52 Chapter 6 Using VSAM Operations 53 VSAM eWay Database Operations (BPEL) 53 Activity Input and Output 53 VSAM eWay Database Operations (JCD) 55 The Table 55 The Query (Sel...
Page 6 - Building and Deploying the prjVSAM_JCD Sample Project; Index
Contents VSAM eWay Adapter User’s Guide 6 Sun Microsystems, Inc. Configuring the Integration Server 89 Creating the Deployment Profile 89 Creating and Starting the Domain 90 Building and Deploying the Project 91 Running the Sample Project 91 Building and Deploying the prjVSAM_JCD Sample Project 92 C...
Page 7 - Sun SeeBeyond eWayTM Adapter for VSAM User’s Guide; What’s in This Chapter; About VSAM
VSAM eWay Adapter User’s Guide 7 Sun Microsystems, Inc. Chapter 1 Introducing the VSAM eWay Welcome to the Sun SeeBeyond eWay™ Adapter for VSAM User’s Guide . This document includes information about installing, configuring, and using the Sun Java Composite Application Platform Suite VSAM eWay™ Adap...
Page 8 - About the VSAM eWay; eWay Operation; Sun SeeBeyond eGateTM Integrator User’s Guide.; What’s New in This Release; This is a maintenance release. No new features.
Chapter 1 Section 1.2 Introducing the VSAM eWay About the VSAM eWay VSAM eWay Adapter User’s Guide 8 Sun Microsystems, Inc. Maintains information about this data, which is stored or referenced in a catalog (catalog management). Supports Entry-sequenced Data Set (ESDS) and Key-sequenced Data Set ...
Page 9 - Sun SeeBeyond eGateTM Integrator; About This Document
Chapter 1 Section 1.4 Introducing the VSAM eWay About This Document VSAM eWay Adapter User’s Guide 9 Sun Microsystems, Inc. Support for Runtime LDAP Configuration: eWay configuration properties now support LDAP key values. Connection Retry Support: Allows you to specify the number of attempts to...
Page 10 - Scope; Related Documents; Sun SeeBeyond eGate; Table 1; Blue bold; Text Conventions; Blue underlined
Chapter 1 Section 1.5 Introducing the VSAM eWay Related Documents VSAM eWay Adapter User’s Guide 10 Sun Microsystems, Inc. Composite Application Platform Suite Installer. To access the full Javadoc, extract the Javadoc to an easily accessible folder, and double-click the index.html file. 1.4.1 Scope...
Page 11 - Documentation Feedback
Chapter 1 Section 1.6 Introducing the VSAM eWay Sun Microsystems, Inc. Web Site VSAM eWay Adapter User’s Guide 11 Sun Microsystems, Inc. 1.6 Sun Microsystems, Inc. Web Site The Sun Microsystems web site is your best source for up-to-the-minute product news and technical support information. The site...
Page 12 - Documentation
VSAM eWay Adapter User’s Guide 12 Sun Microsystems, Inc. Chapter 2 Installing the VSAM eWay This chapter explains how to install the VSAM eWay. What’s in This Chapter Installing the VSAM eWay on page 12 ICAN 5.0 Project Migration Procedures on page 15 Installing Enterprise Manager eWay Plug-In...
Page 13 - Installing the VSAM; Sun Java Composite
Chapter 2 Section 2.1 Installing the VSAM eWay Installing the VSAM eWay VSAM eWay Adapter User’s Guide 13 Sun Microsystems, Inc. 2.1.1 Installing the VSAM eWay on an eGate supported system Follow the directions for installing the Sun Java Composite Application Platform Suite in the Sun Java Composit...
Page 14 - Copying JAR files to the eDesigner Library; IBM WebSphere; After Installation; eGate Integrator User’s Guide; Extracting the Sample Projects and Javadocs; Steps to extract the Javadoc include:
Chapter 2 Section 2.1 Installing the VSAM eWay Installing the VSAM eWay VSAM eWay Adapter User’s Guide 14 Sun Microsystems, Inc. 7 When prompted, restart the IDE (Integrated Development Environment) to complete the installation. Copying JAR files to the eDesigner Library The VSAM eWay SAR file no lo...
Page 15 - Steps to extract the Sample Projects include:; ICAN 5.0 Project Migration Procedures; Export the Project
Chapter 2 Section 2.2 Installing the VSAM eWay ICAN 5.0 Project Migration Procedures VSAM eWay Adapter User’s Guide 15 Sun Microsystems, Inc. Steps to extract the Sample Projects include: 1 Click the Documentation tab of the Sun Java Composite Application Platform Suite Installer, then click the Add...
Page 16 - Deploy the Project; “checked in”; Installing Enterprise Manager eWay Plug-Ins
Chapter 2 Section 2.3 Installing the VSAM eWay Installing Enterprise Manager eWay Plug-Ins VSAM eWay Adapter User’s Guide 16 Sun Microsystems, Inc. 2 Browse to and select your exported Project file. 3 Click Import . A warning message, “Missing APIs from Target Repository ,” may appear at this time. ...
Page 17 - Sun SeeBeyond eGate Integrator System Administration; To add plug-ins from the Enterprise Manager; Viewing Alert Codes; To View the eWay Alert Codes
Chapter 2 Section 2.3 Installing the VSAM eWay Installing Enterprise Manager eWay Plug-Ins VSAM eWay Adapter User’s Guide 17 Sun Microsystems, Inc. Enterprise Manager requires an eWay specific “plug-in” for each eWay you install. These plug-ins enable the Enterprise Manager to target specific alert ...
Page 18 - From the; Install New Alert Codes; section, browse to and select the eWay alert; alertcodes; folder of your Sun Java Composite Application; Deploy; Alert Codes for the VSAM eWay
Chapter 2 Section 2.3 Installing the VSAM eWay Installing Enterprise Manager eWay Plug-Ins VSAM eWay Adapter User’s Guide 18 Sun Microsystems, Inc. A From the Install New Alert Codes section, browse to and select the eWay alert properties file for the application plug-in that you added. The alert pr...
Page 19 - Sun
Chapter 2 Section 2.3 Installing the VSAM eWay Installing Enterprise Manager eWay Plug-Ins VSAM eWay Adapter User’s Guide 19 Sun Microsystems, Inc. For information on Managing and Monitoring alert codes and logs, as well as how to view the alert generated by the project component during runtime, see...
Page 20 - This chapter explains how to set the properties of the VSAM eWay.; Creating and Configuring a VSAM eWay; Connectivity Map; : These parameters most commonly apply to a specific; Environment Explorer; : These parameters are commonly global, applying to all; Collaboration or Business Process; : VSAM eWay properties may also be set from; Configuring the eWay Connectivity Map Properties; Transaction support levels provided by the VSAM eWay include:
VSAM eWay Adapter User’s Guide 20 Sun Microsystems, Inc. Chapter 3 Setting Properties of the VSAM eWay This chapter explains how to set the properties of the VSAM eWay. What’s in This Chapter Creating and Configuring a VSAM eWay on page 20 Configuring the eWay Connectivity Map Properties on page...
Page 21 - To configure the eWay properties:; Connectivity Map with Components; OK; Template window
Chapter 3 Section 3.2 Setting Properties of the VSAM eWay Configuring the eWay Connectivity Map Properties VSAM eWay Adapter User’s Guide 21 Sun Microsystems, Inc. VSAM CP eWay Outbound VSAM non-Transactional eWay To configure the eWay properties: 1 On the Enterprise Designer ’s Connectivity Map...
Page 22 - Figure 3; Outbound eWay Properties; Transaction Support Levels Between Different Versions
Chapter 3 Section 3.2 Setting Properties of the VSAM eWay Configuring the eWay Connectivity Map Properties VSAM eWay Adapter User’s Guide 22 Sun Microsystems, Inc. Figure 3 Outbound eWay Properties 3.2.1 Transaction Support Levels Between Different Versions The types of transaction support levels us...
Page 23 - Configuring the eWay Environment Properties; Available External System properties include:; To Configure the Environment Properties:; In Enterprise Explorer, click the Environment Explorer tab.
Chapter 3 Section 3.3 Setting Properties of the VSAM eWay Configuring the eWay Environment Properties VSAM eWay Adapter User’s Guide 23 Sun Microsystems, Inc. 3.3 Configuring the eWay Environment Properties The eWay Environment Configuration properties contain parameters that define how the eWay con...
Page 24 - Figure 4; VSAM eWay Environment Configuration; to save the changes.; eWay Connectivity Map Properties; Outbound eWa; Outbound non-Transactional eWay; Connectivity Map Outbound non-Transactional eWay Properties
Chapter 3 Section 3.4 Setting Properties of the VSAM eWay eWay Connectivity Map Properties VSAM eWay Adapter User’s Guide 24 Sun Microsystems, Inc. Figure 4 VSAM eWay Environment Configuration 4 Click on any folder to display the default configuration properties for that section. 5 Click on any prop...
Page 25 - Connectivity Map (Outbound) CP eWay Properties; Table 3; Outbound eWay—JDBC Connector Settings; Table 4
Chapter 3 Section 3.4 Setting Properties of the VSAM eWay eWay Connectivity Map Properties VSAM eWay Adapter User’s Guide 25 Sun Microsystems, Inc. 3.4.1 Connectivity Map (Outbound) CP eWay Properties The Outbound eWay Properties include outbound parameters used by the external database. 3.4.2 Conne...
Page 26 - eWay Environment Properties; Property Categories Configured in the Logical Host Environment; Inbound VSAM eWay Properties; Parameter Settings; Table 5; Inbound VSAM eWay—Parameter Settings
Chapter 3 Section 3.5 Setting Properties of the VSAM eWay eWay Environment Properties VSAM eWay Adapter User’s Guide 26 Sun Microsystems, Inc. 3.5 eWay Environment Properties eWay External System properties must be configured from within the Environment. Until you have successfully configured all eW...
Page 27 - Table 6; VSAM CP eWay—JDBC Connector Settings
Chapter 3 Section 3.5 Setting Properties of the VSAM eWay eWay Environment Properties VSAM eWay Adapter User’s Guide 27 Sun Microsystems, Inc. JDBC Connector Settings Details for the VSAM CP eWay JDBC Connector Settings used by the external database are detailed in Table 6. Table 6 VSAM CP eWay—JDBC...
Page 28 - VSAM CP eWay—JDBC Connector Settings (Continued)
Chapter 3 Section 3.5 Setting Properties of the VSAM eWay eWay Environment Properties VSAM eWay Adapter User’s Guide 28 Sun Microsystems, Inc. DriverProperties The Connection Pool DataSource implementation may need to execute additional methods to assure a successful run. The additional methods will...
Page 29 - Connection Retry Settings; Table 7; VSAM CP eWay—Connection Retry Settings
Chapter 3 Section 3.5 Setting Properties of the VSAM eWay eWay Environment Properties VSAM eWay Adapter User’s Guide 29 Sun Microsystems, Inc. Connection Retry Settings Details for the VSAM CP eWay Connection Retry Settings used by the external database are detailed in Table 7. MinPoolSize Specifies...
Page 30 - Outbound VSAM non-Transactional eWay Properties; Table 8; VSAM non-Transactional eWay—JDBC Connector Settings; VSAM CP eWay—Connection Retry Settings (Continued)
Chapter 3 Section 3.5 Setting Properties of the VSAM eWay eWay Environment Properties VSAM eWay Adapter User’s Guide 30 Sun Microsystems, Inc. 3.5.3 Outbound VSAM non-Transactional eWay Properties The (Outbound) VSAM non-Transactional eWay includes the following configuration sections: JDBC Connec...
Page 31 - VSAM non-Transactional eWay—JDBC Connector Settings (Continued)
Chapter 3 Section 3.5 Setting Properties of the VSAM eWay eWay Environment Properties VSAM eWay Adapter User’s Guide 31 Sun Microsystems, Inc. DriverProperties The Connection Pool DataSource implementation may need to execute additional methods to assure a successful run. The additional methods will...
Page 32 - Table 9; VSAM non-Transactional eWay—Connection Retry Settings
Chapter 3 Section 3.5 Setting Properties of the VSAM eWay eWay Environment Properties VSAM eWay Adapter User’s Guide 32 Sun Microsystems, Inc. Connection Retry Settings Details for the VSAM non-Transactional eWay Connection Retry Settings used by the external database are detailed in Table 9. MinPoo...
Page 34 - About the Database OTD Wizard
VSAM eWay Adapter User’s Guide 34 Sun Microsystems, Inc. Chapter 4 Using the VSAM eWay Database Wizard This chapter describes how to use the VSAM eWay Database wizard to build Object Type Definitions (OTDs). What’s in This Chapter About the Database OTD Wizard on page 34 Creating a New VSAM OTD ...
Page 35 - Select Database Objects; Steps Required to Select the VSAM Database OTD Wizard Include:; On the Project Explorer tree, right click the Project and select; Definition; from the shortcut menu. The; Select Wizard Type; displaying the available; OTD; From the New Object Type Definition Wizard window, select the; VSAM Database; and click; Next; OTD Wizard Selection; Connect To Database
Chapter 4 Section 4.2 Using the VSAM eWay Database Wizard Creating a New VSAM OTD VSAM eWay Adapter User’s Guide 35 Sun Microsystems, Inc. Select Database Objects on page 36 Select Tables/Views/Aliases on page 37 Add Prepared Statement on page 41 Specify the OTD Name on page 44 Review Sele...
Page 36 - Required Database Connection Fields include:; Database Connection Information; Steps Required to Select Database Objects Include:; Views are read-only and are for informational purposes only.
Chapter 4 Section 4.2 Using the VSAM eWay Database Wizard Creating a New VSAM OTD VSAM eWay Adapter User’s Guide 36 Sun Microsystems, Inc. Required Database Connection Fields include: Host name – the database service host name. Port ID – the database service connection port ID/number. Database...
Page 37 - Figure 7; Steps Required to Select Table and Views Include:; In the; Add
Chapter 4 Section 4.2 Using the VSAM eWay Database Wizard Creating a New VSAM OTD VSAM eWay Adapter User’s Guide 37 Sun Microsystems, Inc. Figure 7 Select Database Objects 4.2.4 Select Tables/Views/Aliases Select the types of tables or views required in the OTD. Note: Aliases are not supported in th...
Page 38 - Figure 8; Add Tables; window, select if your selection criteria will include table data,; Search
Chapter 4 Section 4.2 Using the VSAM eWay Database Wizard Creating a New VSAM OTD VSAM eWay Adapter User’s Guide 38 Sun Microsystems, Inc. Figure 8 Select Tables/Views/Aliases 2 In the Add Tables window, select if your selection criteria will include table data, view only data, both, and/or system t...
Page 39 - Figure 9; Database Wizard - All Schemes; The table selected is added to the
Chapter 4 Section 4.2 Using the VSAM eWay Database Wizard Creating a New VSAM OTD VSAM eWay Adapter User’s Guide 39 Sun Microsystems, Inc. Figure 9 Database Wizard - All Schemes 4 Select the table of choice and click OK . The table selected is added to the Selected Tables/Views/Aliases section. See ...
Page 40 - Selected Tables/Views/Aliases window with a table selected; Change; The data type is usually listed as; Other; when the driver cannot detect the data type.
Chapter 4 Section 4.2 Using the VSAM eWay Database Wizard Creating a New VSAM OTD VSAM eWay Adapter User’s Guide 40 Sun Microsystems, Inc. Figure 10 Selected Tables/Views/Aliases window with a table selected 5 In the Selected Tables/Views/Aliases section, review the table(s) you have selected. To ma...
Page 41 - Advanced; finished your table choices, click; . In general, you will not need to make any; Add Prepared Statement; Add a Prepared Statement object to your OTD.
Chapter 4 Section 4.2 Using the VSAM eWay Database Wizard Creating a New VSAM OTD VSAM eWay Adapter User’s Guide 41 Sun Microsystems, Inc. Figure 11 Table/View Columns 7 Click Advanced to change the data type, percision/length, or scale. Once you have finished your table choices, click OK . In gener...
Page 42 - Steps Required to Add Prepared Statements Include:; On the; Add Prepared Statements; Prepared Statement; Save As; giving the
Chapter 4 Section 4.2 Using the VSAM eWay Database Wizard Creating a New VSAM OTD VSAM eWay Adapter User’s Guide 42 Sun Microsystems, Inc. Steps Required to Add Prepared Statements Include: Note: When using a Prepared Statement, the ‘ResultsAvailable()’ method will always return true. Although this ...
Page 43 - Prepared SQL Statement
Chapter 4 Section 4.2 Using the VSAM eWay Database Wizard Creating a New VSAM OTD VSAM eWay Adapter User’s Guide 43 Sun Microsystems, Inc. Figure 14 Prepared SQL Statement 3 On the Add Prepared Statement window, the name you assigned to the Prepared Statement appears. To edit the parameters, click E...
Page 44 - ResultSet Columns; Specify the OTD Name; Steps Required to Specify the OTD Name:
Chapter 4 Section 4.2 Using the VSAM eWay Database Wizard Creating a New VSAM OTD VSAM eWay Adapter User’s Guide 44 Sun Microsystems, Inc. Figure 16 ResultSet Columns 6 Click Add to add a new ResultSet column. Both the Name and Type are editable. 7 Click OK to return to the Add Prepared Statements w...
Page 45 - Naming an OTD; Review Selections; Steps Required to Review Your OTD Selections:
Chapter 4 Section 4.2 Using the VSAM eWay Database Wizard Creating a New VSAM OTD VSAM eWay Adapter User’s Guide 45 Sun Microsystems, Inc. Figure 17 Naming an OTD 2 Click Next . 4.2.7 Review Selections Review the selections made for the new OTD. Steps Required to Review Your OTD Selections: 1 View t...
Page 46 - Database Wizard - Summary; Resulting OTD
Chapter 4 Section 4.3 Using the VSAM eWay Database Wizard Resulting OTD VSAM eWay Adapter User’s Guide 46 Sun Microsystems, Inc. Figure 18 Database Wizard - Summary 4.3 Resulting OTD The resulting VSAM OTD appears on the Enterprise Designer ’s canvas, in the OTD Editor window. See Figure 19. In the ...
Page 47 - OTD Editor in Enterprise Designer; Steps to Edit an Existing VSAM OTD; Steps to Edit the OTD from the Enterprise Designer Include:; The Version Control - Check Out window appears.; Check Out; From the Project Explorer, right-click the OTD again and select; Edit; The VSAMDatabase Connection Information wizard appears.; “Connect To Database” on
Chapter 4 Section 4.4 Using the VSAM eWay Database Wizard Steps to Edit an Existing VSAM OTD VSAM eWay Adapter User’s Guide 47 Sun Microsystems, Inc. Figure 19 OTD Editor in Enterprise Designer 4.4 Steps to Edit an Existing VSAM OTD You can edit any database OTD you create directly from the Enterpri...
Page 48 - Step through each of the wizard steps and click; Finish; to save your changes.
Chapter 4 Section 4.4 Using the VSAM eWay Database Wizard Steps to Edit an Existing VSAM OTD VSAM eWay Adapter User’s Guide 48 Sun Microsystems, Inc. 5 Step through each of the wizard steps and click Finish to save your changes. Note: You must verify during project activation or at runtime that no e...
Page 49 - Overview; You can use VSAM OTD methods with:; eGate; Using Tables
VSAM eWay Adapter User’s Guide 49 Sun Microsystems, Inc. Chapter 5 Using VSAM OTDs This chapter describes operations you can perform using VSAM Object Type Definitions (OTDs) in eGate. What’s in This Chapter Overview on page 49 Using Tables on page 49 Using Views on page 52 Using Prepared St...
Page 50 - Using the select Method; To call a method in the Collaboration Editor (Java); Using the
Chapter 5 Section 5.2 Using VSAM OTDs Using Tables VSAM eWay Adapter User’s Guide 50 Sun Microsystems, Inc. 5.2.1 Using the select Method The select method returns result sets according to a group of predefined defaults. However, you can change these defaults, if desired. In using the select method,...
Page 51 - Select Operations; To perform a select operation on a table; Insert Operations; To perform an insert operation on a table; Update Operations; To perform an update operation on a table; Delete Operations; To perform a delete operation on a table
Chapter 5 Section 5.2 Using VSAM OTDs Using Tables VSAM eWay Adapter User’s Guide 51 Sun Microsystems, Inc. 5.2.2 Select Operations To perform a select operation on a table 1 From the Collaboration Editor (Java), call the select method with the where clause specified, if necessary. The text from the...
Page 52 - Using Views; “Select Operations” on page 51; Using Prepared Statements; When using a Prepared Statement, the; To use a prepared statement in a Collaboration (Java)
Chapter 5 Section 5.3 Using VSAM OTDs Using Views VSAM eWay Adapter User’s Guide 52 Sun Microsystems, Inc. 5.3 Using Views Views are used to look at data from selected columns within selected tables. View OTDs are read-only. For select operations, see “Select Operations” on page 51 . 5.4 Using Prepa...
Page 53 - Activity Input and Output; otdVSAM.CICSEMPDelete
VSAM eWay Adapter User’s Guide 53 Sun Microsytems, Inc. Chapter 6 Using VSAM Operations The database operations used in the VSAM eWay are used to access the VSAM database. Database operations are either accessed through Activities in BPEL, or through methods called from a JCD Collaboration. What’s i...
Page 54 - Input and Output Between Activities
Chapter 6 Section 6.1 Using VSAM Operations VSAM eWay Database Operations (BPEL) VSAM eWay Adapter User’s Guide 54 Sun Microsytems, Inc. Figure 20 Input and Output Between Activities The following table lists the expected Input and Output of each database operation Activity. Table 10 VSAM Operations...
Page 55 - String; The Table; SetConcurrencytoUpdatable
Chapter 6 Section 6.2 Using VSAM Operations VSAM eWay Database Operations (JCD) VSAM eWay Adapter User’s Guide 55 Sun Microsytems, Inc. 6.2 VSAM eWay Database Operations (JCD) The same database operations are also used in the JCD, but appear as methods to call from the Collaboration. Tables and View...
Page 56 - To perform a query operation on a table:
Chapter 6 Section 6.2 Using VSAM Operations VSAM eWay Database Operations (JCD) VSAM eWay Adapter User’s Guide 56 Sun Microsytems, Inc. SetScrollTypetoScrollSensitive SetScrollTypetoInsensitive The Query (Select) Operation To perform a query operation on a table: 1 Execute the select() method wi...
Page 57 - The Insert Operation; To perform an insert operation on a table:; Execute the
Chapter 6 Section 6.2 Using VSAM Operations VSAM eWay Database Operations (JCD) VSAM eWay Adapter User’s Guide 57 Sun Microsytems, Inc. } } The Insert Operation To perform an insert operation on a table: 1 Execute the insert() method. Assign a field. 2 Insert the row by calling insertRow() This exam...
Page 58 - The Update Operation; To perform an update operation on a table:; The Delete Operation; To perform a delete operation on a table:
Chapter 6 Section 6.2 Using VSAM Operations VSAM eWay Database Operations (JCD) VSAM eWay Adapter User’s Guide 58 Sun Microsytems, Inc. FileClient_1.setText( "Done Insert." ); FileClient_1.write(); }} The Update Operation To perform an update operation on a table: 1 Execute the update() meth...
Page 59 - To execute a prepared statement, set the input parameters and call; Batch Operations; method for each SQL operation and then the
Chapter 6 Section 6.2 Using VSAM Operations VSAM eWay Database Operations (JCD) VSAM eWay Adapter User’s Guide 59 Sun Microsytems, Inc. public com.stc.codegen.logger.Logger logger; public com.stc.codegen.alerter.Alerter alerter; public com.stc.codegen.util.CollaborationContext collabContext; public ...
Page 61 - eGate Tutorial; About the VSAM eWay Sample Projects
VSAM eWay Adapter User’s Guide 61 Sun Microsystems, Inc. Chapter 7 Implementing the VSAM eWay Sample Projects This chapter provides an introduction to the VSAM eWay components, and information on how these components are created and implemented in a Sun Java Composite Application Platform Suite Proj...
Page 62 - Sample input files include:; Operations Used in the VSAM Sample Projects
Chapter 7 Section 7.1 Implementing the VSAM eWay Sample Projects About the VSAM eWay Sample Projects VSAM eWay Adapter User’s Guide 62 Sun Microsystems, Inc. Insert employee records data into the CICSEMP table. Update an employee record in the CICSEMP table. Delete an employee record from the ...
Page 63 - Assigning Operations in JCD; Select Method to; Assigning Operations in BPEL; receive; About the eInsight Engine and eGate Components
Chapter 7 Section 7.1 Implementing the VSAM eWay Sample Projects About the VSAM eWay Sample Projects VSAM eWay Adapter User’s Guide 63 Sun Microsystems, Inc. Assigning Operations in JCD Database operations are listed as methods in the JCD. Perform the following steps to access these methods: 1 Creat...
Page 64 - Running the Sample Projects; JCD
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...
Page 65 - Importing a Sample Project; file contains the various sample Project ZIP files.; Import Project; Import Manager; Close; after successfully importing the sample Project.
Chapter 7 Section 7.4 Implementing the VSAM eWay Sample Projects Importing a Sample Project VSAM eWay Adapter User’s Guide 65 Sun Microsystems, Inc. 7.4 Importing a Sample Project Sample eWay Projects are included as part of the installation CD-ROM package. To import a sample eWay Project to the Ent...
Page 66 - Creating a Project; Steps required to create a VSAM Database OTD include:
Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Building and Deploying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 66 Sun Microsystems, Inc. 7.5.1 Creating a Project The first step is to create a new Project in the Enterprise Designer. 1 Start the Enterprise Desig...
Page 67 - In our example, the SQL statement includes the; Steps required to create inbound and outbound DTD OTDs:; Creating the Business Process; Creating the Business Process Flow; Steps to create a business process flow include:
Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Building and Deploying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 67 Sun Microsystems, Inc. 8 Click Add , the Add Prepared Statement window appears. Enter the following: Prepared Statement Name: Select_ps SQL St...
Page 68 - bpUpdate; Configuring the bpInsert Modeling Elements; Business Process Activities
Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Building and Deploying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 68 Sun Microsystems, Inc. 2 Create four additional business processes and rename them as follows: bpUpdate bpDelete bpPsSelect bpTableSelect ...
Page 69 - bpInsert Business Process; Steps required to configure the bpInsert business process:; Configure the business rule between
Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Building and Deploying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 69 Sun Microsystems, Inc. Note: Review the eInsight Business Process Manager User’s Guide for a more detailed description of the steps required to co...
Page 70 - bpInsert Business Rule # 2; Insert; bpInsert Business Rule # 3; While; statement that connects to the; otdVSAM.CICSEMPInsert
Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Building and Deploying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 70 Sun Microsystems, Inc. Figure 23 bpInsert Business Rule # 2 3 Configure the business rule between otdInputDTD_Emp.unmarshal Activity and the Inser...
Page 71 - bpInsert Business Rule # 4; statement that connects from the
Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Building and Deploying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 71 Sun Microsystems, Inc. Figure 25 bpInsert Business Rule # 4 5 Configure the business rule in the While statement that connects from the otdVSAM.CI...
Page 72 - bpInsert Business Rule # 5; bpInsert Business Rule # 6; Configuring the bpUpdate Modeling Elements
Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Building and Deploying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 72 Sun Microsystems, Inc. Figure 26 bpInsert Business Rule # 5 6 Configure the business rule from the Insert (Scope element) to the FileClient.write ...
Page 73 - bpUpdate Business Process; Steps required to configure the bpUpdate business process:; otdVSAM.CICSEMPUpdate
Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Building and Deploying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 73 Sun Microsystems, Inc. Note: The where clause in the business rule reads the trigger value as a placeholder for input. This permits you to modify ...
Page 74 - bpUpdate Business Rule # 2; Activity and; Configuring the bpDelete Modeling Elements
Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Building and Deploying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 74 Sun Microsystems, Inc. Figure 30 bpUpdate Business Rule # 2 3 Configure the business rule between the otdVSAM.CICSEMPUpdate Activity and the FileC...
Page 75 - bpDelete Business Process; Steps required to configure the bpDelete business process:; bpDelete Business Rule # 2
Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Building and Deploying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 75 Sun Microsystems, Inc. Note: Review the eInsight Business Process Manager User’s Guide for a more detailed description of the steps required to co...
Page 76 - Configure the business rule between the; Configuring the bpTableSelect Modeling Elements; bpTableSelect Business Process; Steps required to configure the bpTableSelect business process:
Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Building and Deploying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 76 Sun Microsystems, Inc. 3 Configure the business rule between the otdVSAM.CICSEMPDelete Activity and the FileClient.write Activity, as seen in Figu...
Page 77 - bpTableSelect Business Rule # 1; bpTableSelect Business Rule # 2; otdVSAM.CICSEMPSelectAll
Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Building and Deploying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 77 Sun Microsystems, Inc. Figure 37 bpTableSelect Business Rule # 1 2 Configure the business rule between the FileClient.write Activity and otdVSAM.C...
Page 78 - bpSelectTable Business Rule # 3
Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Building and Deploying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 78 Sun Microsystems, Inc. Figure 39 bpSelectTable Business Rule # 3 4 Configure the business rule between the otdInputDTD_Emp.marshal Activity and th...
Page 79 - bpTableSelect Business Rule # 5; Configuring the bpPsSelect Modeling Elements; bpPsSelect Business Process; Steps required to configure the bpPsSelect business process:
Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Building and Deploying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 79 Sun Microsystems, Inc. 5 Configure the business rule between the FileClient.write Activity and the FileClient.write Activity as seen in Figure 41....
Page 80 - bpPsSelect Business Rule # 1
Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Building and Deploying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 80 Sun Microsystems, Inc. Figure 43 bpPsSelect Business Rule # 1 2 Configure the business rule between FileClient.write Activity and otdVSAM.Select_p...
Page 81 - Case 1 Scope Business Rule # 3
Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Building and Deploying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 81 Sun Microsystems, Inc. Figure 46 Case 1 Scope Business Rule # 3 5 Configure the business rule between otdInputDTD_Emp.marshal Activity and FileCli...
Page 82 - Activities within Case 2 Scope
Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Building and Deploying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 82 Sun Microsystems, Inc. 6 Configure Case 2 of the Decision branching activity. This requires adding business rules between the otdInputDTD_Emp.mars...
Page 83 - bpSelectTable Business Rule # 6; Creating the Connectivity Map; Steps required to create the Connectivity Map:; Populat; ing; the Connectivity Map
Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Building and Deploying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 83 Sun Microsystems, Inc. Figure 50 bpSelectTable Business Rule # 6 7.5.4 Creating the Connectivity Map The Connectivity Map provides a canvas for as...
Page 84 - To Select a VSAM External System; Binding the eWay Components; Steps required to bind eWay components together:
Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Building and Deploying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 84 Sun Microsystems, Inc. Each Connectivity Map in the prjVSAM_BPEL sample Project requires the following components: File External Application (2)...
Page 85 - Connectivity Map - Associating (Binding) the Project’s Components; Creating an Environment; Steps required to create an Environment:
Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Building and Deploying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 85 Sun Microsystems, Inc. Figure 51 Connectivity Map - Associating (Binding) the Project’s Components 5 Minimize the bpDelete Binding dialog box by c...
Page 86 - Environment Editor - envVSAMProj; Configuring the eWays
Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Building and Deploying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 86 Sun Microsystems, Inc. 5 Right-click envVSAMProj and select New > File External System . Name the External System esFileClient . Click OK . esF...
Page 87 - eWays in the cmDelete Connectivity Map; Configuring the eWay Properties; Steps required to configure the eWay properties:; modify
Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Building and Deploying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 87 Sun Microsystems, Inc. Figure 53 eWays in the cmDelete Connectivity Map Configuring the eWay Properties Steps required to configure the eWay prope...
Page 88 - Configuring the Environment Explorer Properties; File eWay Environment Properties
Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Building and Deploying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 88 Sun Microsystems, Inc. Configuring the Environment Explorer Properties Steps required to configure the Environment Explorer properties: 1 From the...
Page 89 - Configuring the Integration Server; Sun SeeBeyond JavaTM Composite; Creating the Deployment Profile; Steps required to create the Deployment Profile:
Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Building and Deploying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 89 Sun Microsystems, Inc. Configuring the Integration Server You must set your SeeBeyond Integration Server Password property before deploying your P...
Page 90 - Deployment Profile; Creating and Starting the Domain; Steps required to create and start the domain:; Navigate to your; Domain Manager; green check mark indicates that the domain is running.; Yes
Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Building and Deploying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 90 Sun Microsystems, Inc. Figure 54 Deployment Profile 7.5.8 Creating and Starting the Domain To build and deploy your Project, you must first create...
Page 91 - Building and Deploying the Project; Build the Project; Running the Sample Project; Steps required to run the sample Project:
Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Building and Deploying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 91 Sun Microsystems, Inc. 5 Make any necessary changes to the Create Domain dialog box and click Create . The new domain is added to the Domain Manag...
Page 92 - New; Creating the OTDs
Chapter 7 Section 7.6 Implementing the VSAM eWay Sample Projects Building and Deploying the prjVSAM_JCD Sample Project VSAM eWay Adapter User’s Guide 92 Sun Microsystems, Inc. Having no content in these files causes the operation to read all records. 2 Verify the output data by viewing the sample ou...
Page 93 - Steps required to create a VSAM Database OTD:; In this example, the SQL statement includes the
Chapter 7 Section 7.6 Implementing the VSAM eWay Sample Projects Building and Deploying the prjVSAM_JCD Sample Project VSAM eWay Adapter User’s Guide 93 Sun Microsystems, Inc. VSAM Database OTD Inbound DTD OTD Outbound DTD OTD Steps required to create a VSAM Database OTD: 1 Right-click your ne...
Page 94 - Steps required to create inbound and outbound DTD OTDs include:; Creating a Connectivity Map; Steps required to create a new Connectivity Map:
Chapter 7 Section 7.6 Implementing the VSAM eWay Sample Projects Building and Deploying the prjVSAM_JCD Sample Project VSAM eWay Adapter User’s Guide 94 Sun Microsystems, Inc. Steps required to create inbound and outbound DTD OTDs include: 1 Right-click your new Project in the Enterprise Designer ’s...
Page 95 - Steps required to select a VSAM External System:; Creating the Collaboration Definitions (Java); Collaboration Definition Wizard
Chapter 7 Section 7.6 Implementing the VSAM eWay Sample Projects Building and Deploying the prjVSAM_JCD Sample Project VSAM eWay Adapter User’s Guide 95 Sun Microsystems, Inc. VSAM External Application Service Any eWay added to the Connectivity Map is associated with an External System. To estab...
Page 96 - jcdDelete Collaboration; Steps required to create the jcdDelete Collaboration:; jcdInsert Collaboration; Steps required to create the jcdInsert Collaboration:
Chapter 7 Section 7.6 Implementing the VSAM eWay Sample Projects Building and Deploying the prjVSAM_JCD Sample Project VSAM eWay Adapter User’s Guide 96 Sun Microsystems, Inc. jcdDelete Collaboration Steps required to create the jcdDelete Collaboration: 1 From the Project Explorer, right-click the s...
Page 97 - jcdPsSelect Collaboration; Steps required to create the jcdPsSelect Collaboration:; jcdTableSelect Collaboration; Steps required to create the jcdTableSelect Collaboration:
Chapter 7 Section 7.6 Implementing the VSAM eWay Sample Projects Building and Deploying the prjVSAM_JCD Sample Project VSAM eWay Adapter User’s Guide 97 Sun Microsystems, Inc. jcdPsSelect Collaboration Steps required to create the jcdPsSelect Collaboration: 1 From the Project Explorer, right-click t...
Page 98 - jcdUpdate Collaboration; Steps required to create the jcdUpdate Collaboration:; Create the Collaboration Business Rules; Creating the jcdDelete Business Rules
Chapter 7 Section 7.6 Implementing the VSAM eWay Sample Projects Building and Deploying the prjVSAM_JCD Sample Project VSAM eWay Adapter User’s Guide 98 Sun Microsystems, Inc. 6 Click the Up One Level button twice to return to the Repository. Double-click Sun SeeBeyond > eWays > File > File...
Page 99 - jcdDelete Business Rules; Creating the jcdInsert Business Rules; jcdInsert; jcdInsert Business Rules; Sample code from the jcdInsert Includes:
Chapter 7 Section 7.6 Implementing the VSAM eWay Sample Projects Building and Deploying the prjVSAM_JCD Sample Project VSAM eWay Adapter User’s Guide 99 Sun Microsystems, Inc. Figure 55 jcdDelete Business Rules Creating the jcdInsert Business Rules The jcdInsert Collaboration implements the Input We...
Page 100 - Creating the jcdPsSelect Business Rules; The; jcdPsSelect
Chapter 7 Section 7.6 Implementing the VSAM eWay Sample Projects Building and Deploying the prjVSAM_JCD Sample Project VSAM eWay Adapter User’s Guide 100 Sun Microsystems, Inc. public com.stc.codegen.util.TypeConverter typeConverter; public void receive( com.stc.connector.appconn.file.FileTextMessag...
Page 101 - statement query) into the; Sample code from the jcdPsSelect Includes:
Chapter 7 Section 7.6 Implementing the VSAM eWay Sample Projects Building and Deploying the prjVSAM_JCD Sample Project VSAM eWay Adapter User’s Guide 101 Sun Microsystems, Inc. statement query) into the otdInputDTD_CICSEMP OTD and selects all available records from the database. The Collaboration al...
Page 102 - Creating the jcdTableSelect Business Rules; jcdTableSelect; the; TriggerTableSelect.in; file. It then copies the database resultset into the
Chapter 7 Section 7.6 Implementing the VSAM eWay Sample Projects Building and Deploying the prjVSAM_JCD Sample Project VSAM eWay Adapter User’s Guide 102 Sun Microsystems, Inc. FileClient_1.setText( "Selecting record(s) from CICSEMP table via Prepared Statement select .." ); \\ Copies the da...
Page 103 - meet the criteria; Sample code from the jcdTableSelect Includes:
Chapter 7 Section 7.6 Implementing the VSAM eWay Sample Projects Building and Deploying the prjVSAM_JCD Sample Project VSAM eWay Adapter User’s Guide 103 Sun Microsystems, Inc. meet the criteria EMPID=49 . The Collaboration also writes a message to JCD_TableSelect_output0.dat to confirm when records...
Page 104 - Creating the jcdUpdate Business Rules; . file and then update arecord under a specific criteria. The; jcdUpdate
Chapter 7 Section 7.6 Implementing the VSAM eWay Sample Projects Building and Deploying the prjVSAM_JCD Sample Project VSAM eWay Adapter User’s Guide 104 Sun Microsystems, Inc. \\ Copies the database resultset into the otdInputDTD_CICSEMP (XML OTD) and selects all available records from the database...
Page 112 - eGate Integrator; Running the Sample
Chapter 7 Section 7.6 Implementing the VSAM eWay Sample Projects Building and Deploying the prjVSAM_JCD Sample Project VSAM eWay Adapter User’s Guide 112 Sun Microsystems, Inc. 5 Make any necessary changes to the Create Domain dialog box and click Create . The new domain is added to the Domain Manag...
Page 113 - Verify the output data by viewing the sample output files. See; About the VSAM; on page 61 for more details on the types of output files used
Chapter 7 Section 7.6 Implementing the VSAM eWay Sample Projects Building and Deploying the prjVSAM_JCD Sample Project VSAM eWay Adapter User’s Guide 113 Sun Microsystems, Inc. 2 Verify the output data by viewing the sample output files. See About the VSAM eWay Sample Projects on page 61 for more de...