Sun Microsystems 5.1.3 manual

SUN SEEBEY OND eWAY™ ADAPTER FOR VSAM USER’S GUIDE Release 5.1.3[...]

VSAM eWay Adapter User’s Guide 2 Sun Micros ystems, Inc. Copyright © 2007 Sun Microsystems, Inc., 4150 Network Circle, Sa nta Clara, California 95054, U.S.A. All rights reserved. Sun Microsystems, Inc. has intellectual property rights relating to te chnology embodied in the product that is described in this document. In particular, and without l[...]

Contents VSAM eWay Adapter User’s Guide 3 Sun Micros ystems, 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 Audie nce 10 Text Conventions 10 Related Documents 10 Sun Microsystems, Inc. Web Site 11 Doc[...]

Contents VSAM eWay Adapter User’s Guide 4 Sun Micros ystems, Inc. Chapter 3 Setting Properties of the VSAM eWay 20 Creating and Configur ing a VSAM eWay 20 Configuring the eWay Connectivity Map Properties 20 Transaction Support Levels Between Different Ve rsions 22 Configuring the eWay Environment Properties 23 eWay Connectivity Map Properties 24[...]

Contents VSAM eWay Adapter User’s Guide 5 Sun Micros ystems, Inc. Delete Operations 51 Using Views 52 Using Prepared Statements 52 Chapter 6 Using VSAM Operations 53 VSAM eWay Database Operations (BPEL) 53 Activity Inpu t and Outp ut 53 VSAM eWay Database Operations (JCD) 55 The Tab le 55 The Quer y (Selec t) Operation 56 The Insert Operation 57 [...]

Contents VSAM eWay Adapter User’s Guide 6 Sun Micros ystems, Inc. Configuring the Integrat ion Server 89 Creating the Deployment Pr ofile 89 Creating and Star ting the Domain 90 Building and Deploying the Project 91 Running the Samp le Project 91 Building and Deploying the prjV SAM_JCD Sample Project 92 Creating a Project 92 Creating the OTDs 92 [...]

VSAM eWay Adapter User’s Guide 7 Sun Micros ystems, Inc. Chapter 1 Introducing the VSAM eW a y W elcome to the Sun SeeBeyond eWay™ Adapter for VSAM User’ s Guide . This document includes information about in stalling, configuring, and us ing the Sun Java Com posite Application Platform Suite VSAM eW ay™ Adapter , referr ed to as the VSAM eW[...]

Chapter 1 Section 1.2 Introducing the VSAM eWay About the VSAM eWay VSAM eWay Adapter User’s Guide 8 Sun Micros ystems, Inc.  Maintains information about this data, which is stor ed or referenced in a catalog (catalog management ).  Supports Entry-sequenced Da ta Set (ESDS) and Key-se quenced Data Set (KSDS) files. The VSAM eW ay allows you[...]

Chapter 1 Section 1.4 Introducing the VSAM eWay About This Document VSAM eWay Adapter User’s Guide 9 Sun Micros ystems, Inc.  Support for Runtime LDAP Configuration: eW ay configuration properties now support LDAP key values.  Connection Retry Support: Allow s you to specify the number of attempts to reconnect, and the interval between re t[...]

Chapter 1 Section 1.5 Introducing the VSAM eWay Relat ed Documen ts VSAM eWay Adapter User’s Guide 10 Sun Micros ystems, Inc. Composite Application Platform Suite Installe r . T o access the full Javadoc, extract the Javadoc to an easily accessible folder , and double-click the index.html file. 1.4.1 Scope This user ’s guide provides a descript[...]

Chapter 1 Section 1.6 Introducing the VSAM eWay Sun Microsys tems, Inc. Web S ite VSAM eWay Adapter User’s Guide 11 Sun Micros ystems, Inc. 1.6 Sun Microsystems, Inc. W eb Site The Sun Micr osystems web site is your best source for up-to-the-minute product news and technical support inform ation. The site’s URL is: http://www .sun.com 1.7 Docum[...]

VSAM eWay Adapter User’s Guide 12 Sun Micros ystems, Inc. Chapter 2 Inst alling the VSAM eW a y This chapter explains how to inst all the VSAM eW ay . What ’ s in This Chapter  Installing the VSAM eW ay on page 12  ICAN 5.0 Project Migration Procedures on page 15  Installing Enterprise Manager eW ay Plug-Ins on page 16 2.1 Inst alling [...]

Chapter 2 Section 2.1 Installing the VSAM eWay Installing the VSAM eWay VSAM eWay Adapter User’s Guide 13 Sun Micros ystems, Inc. 2.1.1 Installing the VSAM eW a y on an eGate supported system Follow the dire c tions for installing the Sun Java Composite Applica tion Platform Suite in the Sun Java Composite Application Plat form Suite Installation[...]

Chapter 2 Section 2.1 Installing the VSAM eWay Installing the VSAM eWay VSAM eWay Adapter User’s Guide 14 Sun Micros ystems, Inc. 7 When prom pted, restart the IDE (I ntegrated Development Envir onment) to complete the installation. Cop ying JAR f iles to the eDesigner Librar y The VSAM eW ay SAR file no longer inc lud es the W ebSphere Informati[...]

Chapter 2 Section 2.2 Installing the VSAM eWay ICAN 5. 0 Project Migration Procedures VSAM eWay Adapter User’s Guide 15 Sun Micros ystems, Inc. Steps to extract the Sample P rojec ts include: 1 Click the Documentation tab of the Sun Java Composi te Application Platform Suite Installer , the n click the Add-ons tab. 2 Click the VSAM eW ay Adapter [...]

Chapter 2 Section 2.3 Installing the VSAM eWay Installing Enterprise Manager eWay Plu g-Ins VSAM eWay Adapter User’s Guide 16 Sun Micros ystems, Inc. 2 Browse to and select your expo rted Project file. 3 Click Import . A warning message, “Missing APIs from T arget Repository ,” may appear at this time. This oc curs because various product API[...]

Chapter 2 Section 2.3 Installing the VSAM eWay Installing Enterprise Manager eWay Plu g-Ins VSAM eWay Adapter User’s Guide 17 Sun Micros ystems, Inc. Enterprise Manager r equires an eW ay specif ic “plug-in” for each eW ay you install. These plug-ins enable the Enterpris e Manager to target specific alert codes for each eW ay type, as well as[...]

Chapter 2 Section 2.3 Installing the VSAM eWay Installing Enterprise Manager eWay Plu g-Ins VSAM eWay Adapter User’s Guide 18 Sun Micros ystems, Inc. A From the Install New Alert Codes section, browse to and select t he eW ay alert properties file for the application plug-i n that you added. The alert pr operties files are located in the ale rtco[...]

Chapter 2 Section 2.3 Installing the VSAM eWay Installing Enterprise Manager eWay Plu g-Ins VSAM eWay Adapter User’s Guide 19 Sun Micros ystems, Inc. For information on Managing and Moni toring alert codes and logs, as well as how to view the alert generated by the project component during runtime, s ee the Sun SeeBeyond eGate ™ Integrator Syst[...]

VSAM eWay Adapter User’s Guide 20 Sun Micros ystems, Inc. Chapter 3 Sett ing P roper t ies of the VSAM eW a y This chapter explains how to set the properties of the VSAM eW ay . What ’ s in This Chapter  Creating and Configuring a VSAM eW ay on page 20  Configuring the eW ay Connectivity Map Properties on page 20  Configuring the eW ay[...]

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 Micros ystems, Inc.  VSAM CP eW ay  Outbound VSAM non-T ransactional eW ay T o configure the eW a y propert ies: 1 On the Enterprise Designer ’s Connectivity Map, double-click the VSAM eW ay icon[...]

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 Micros ystems, Inc. Figure 3 Outbound eW ay Proper ties 3.2.1 T ransac t ion Support Le vels Betw een Different V ersions The types of transaction suppo rt levels used in Java CAPS 5.1.0 may be different[...]

Chapter 3 Section 3.3 Setting Properties of the VSAM eWay Configuring the eWay Environment Properties VSAM eWay Adapter User’s Guide 23 Sun Micros ystems, Inc. 3.3 Configur ing the eW a y En vironment P ropert ies The eW ay Environment Configuration properties contain parame ters that define how the eW ay connects to and interacts with other eGat[...]

Chapter 3 Section 3.4 Setting Properties of the VSAM eWay eWay Connectivity Map Properties VSAM eWay Adapter User’s Guide 24 Sun Micros ystems, Inc. Figure 4 VSAM eW ay Environment Configuration 4 Click on any folder to display the de fault configurat ion properties for that sectio n. 5 Click on any property field to make it editable. After modif[...]

Chapter 3 Section 3.4 Setting Properties of the VSAM eWay eWay Connectivity Map Properties VSAM eWay Adapter User’s Guide 25 Sun Micros ystems, Inc. 3.4.1 Connect ivit y Map (Outbound) CP eW a y P ropert ies The Outbound eW ay Properties include ou tbound parameters used by the external database. 3.4.2 Connect ivit y Map Outbound non- T ransact i[...]

Chapter 3 Section 3.5 Setting Properties of the VSAM eWay eWay Environment Properties VSAM eWay Adapter User’s Guide 26 Sun Micros ystems, Inc. 3.5 eW a y En vironment P ropert ies eW ay External System properties must be configur ed from within the Envir onment. Until you have successfully configured all eW ays for your Java CAPS pr oject, your [...]

Chapter 3 Section 3.5 Setting Properties of the VSAM eWay eWay Environment Properties VSAM eWay Adapter User’s Guide 27 Sun Micros ystems, Inc. JDBC Connector Sett ings Details for the VSAM CP eW ay JDBC Connecto r Settings used by th e external database are detailed in T able 6. T able 6 VSAM CP eW ay—JDBC Connector Settings Name Descript ion [...]

Chapter 3 Section 3.5 Setting Properties of the VSAM eWay eWay Environment Properties VSAM eWay Adapter User’s Guide 28 Sun Micros ystems, Inc. Driv erProper ties The Connection P ool DataSource implementation may need to ex ecute additional methods to assure a successful run. The additional methods will need to be identified in the Driv er Prope[...]

Chapter 3 Section 3.5 Setting Properties of the VSAM eWay eWay Environment Properties VSAM eWay Adapter User’s Guide 29 Sun Micros ystems, Inc. Connect ion Re tr y Sett ings Details for the VSAM CP eW ay Connection R etry Settings used by the external database are detailed in T able 7. MinP oolSize S pecifies the minimum number of physical connec[...]

Chapter 3 Section 3.5 Setting Properties of the VSAM eWay eWay Environment Properties VSAM eWay Adapter User’s Guide 30 Sun Micros ystems, Inc. 3.5.3 Outbound VSAM non- T ransact ional eW a y P roper t ies The (Outbound) VSAM non-T ransactional eW ay includes the following configuration sections:  JDBC Connector Settings  Connection Retry S[...]

Chapter 3 Section 3.5 Setting Properties of the VSAM eWay eWay Environment Properties VSAM eWay Adapter User’s Guide 31 Sun Micros ystems, Inc. Driv erProper ties The Connection P ool DataSource implementation may need to ex ecute additional methods to assure a successful run. The additional methods will need to be identified in the Driv er Prope[...]

Chapter 3 Section 3.5 Setting Properties of the VSAM eWay eWay Environment Properties VSAM eWay Adapter User’s Guide 32 Sun Micros ystems, Inc. Connect ion Re tr y Sett ings Details for the VSAM non-T ransactional eW ay Connection Retry Settings use d by the external database ar e detailed in T a ble 9. MinP oolSize S pecifies the minimum number [...]

Chapter 3 Section 3.5 Setting Properties of the VSAM eWay eWay Environment Properties VSAM eWay Adapter User’s Guide 33 Sun Micros ystems, Inc. ConnectionRetryInterval Specifi es the milliseconds of pause before each attempt to reaccess the database. Thi s setting is used in conjunction with the 'Connection Retries' setting. F or exampl[...]

VSAM eWay Adapter User’s Guide 34 Sun Micros ystems, Inc. Chapter 4 Using the VSAM eW a y Dat abase Wizard This chapter describes how to use the VSAM eW ay Database wizard to build Object T ype Definitions (OTDs). What ’ s in This Chapter  About the Database OTD W izard on page 34  Creating a New VSAM OTD on page 34  Resulting OTD on p[...]

Chapter 4 Section 4.2 Using the VSAM eWay Database Wizard Creating a New VSAM OTD VSAM eWay Adapter User’s Guide 35 Sun Micros ystems, Inc.  Select Database Objects on page 36  Select T ables/V iews/Aliases on page 37  Add Prepared Statement on page 41  Specify the OTD Name on page 44  Review Selections on page 45 4.2.1 Select Wiza[...]

Chapter 4 Section 4.2 Using the VSAM eWay Database Wizard Creating a New VSAM OTD VSAM eWay Adapter User’s Guide 36 Sun Micros ystems, Inc. R equired Data base Conne ct ion Fields include:  Host name – the database service host name.  Port ID – the dat abase service connection port ID/number .  Database name – the name of the VSAM [...]

Chapter 4 Section 4.2 Using the VSAM eWay Database Wizard Creating a New VSAM OTD VSAM eWay Adapter User’s Guide 37 Sun Micros ystems, Inc. Figure 7 Select Database Objects 4.2.4 Select T ables/Views/Aliases Select the types of tables or views r equired in the OTD. Note: Aliases are not supported in the curr ent release of the VSAM eWay . Steps R[...]

Chapter 4 Section 4.2 Using the VSAM eWay Database Wizard Creating a New VSAM OTD VSAM eWay Adapter User’s Guide 38 Sun Micros ystems, Inc. Figure 8 Select T ables/Views/Aliases 2 In the Add T ables window , select if your selection criteria will include table data, view only data, both, and/or system tables. 3 From the T able/V iew Name drop dow[...]

Chapter 4 Section 4.2 Using the VSAM eWay Database Wizard Creating a New VSAM OTD VSAM eWay Adapter User’s Guide 39 Sun Micros ystems, Inc. Figure 9 Database Wizard - All Schemes 4 Select the table of choice and click OK . The table selected is add ed to the Selected T ables/V iews/Aliases section. See Figur e 10.[...]

Chapter 4 Section 4.2 Using the VSAM eWay Database Wizard Creating a New VSAM OTD VSAM eWay Adapter User’s Guide 40 Sun Micros ystems, Inc. Figure 10 Selected T ables/V iews/Aliases window with a table selected 5 In the Selected T ables /V iews/Aliases sect ion, review the table(s) you have selecte d. T o make changes to the selected T able or V [...]

Chapter 4 Section 4.2 Using the VSAM eWay Database Wizard Creating a New VSAM OTD VSAM eWay Adapter User’s Guide 41 Sun Micros ystems, Inc. Figure 11 T able/View Columns 7 Click Advanced to change the data type, per cisio n/length, or scale. Once you have finished your table choices, click OK . In general, you will not need to make any changes. S[...]

Chapter 4 Section 4.2 Using the VSAM eWay Database Wizard Creating a New VSAM OTD VSAM eWay Adapter User’s Guide 42 Sun Micros ystems, Inc. Steps R equired to Add P repared Statemen ts Include: Note: When using a Prepar ed Statement, the ‘ResultsA vailable()’ method will always return true. Although this method is available, you should not us[...]

Chapter 4 Section 4.2 Using the VSAM eWay Database Wizard Creating a New VSAM OTD VSAM eWay Adapter User’s Guide 43 Sun Micros ystems, Inc. Figure 14 P repared SQL Statement 3 On the Add Prepared Statement window , the name you assigned to the Prepared Statement appears. T o edit the parameters, click Edit Parameters . Y ou can change the datatyp[...]

Chapter 4 Section 4.2 Using the VSAM eWay Database Wizard Creating a New VSAM OTD VSAM eWay Adapter User’s Guide 44 Sun Micros ystems, Inc. Figure 16 ResultSet Columns 6 Click Add to add a new ResultSet column. Both the Name and T ype ar e editable. 7 Click OK to r eturn to the Add Prepar ed Statements window . 4.2.6 Specify the O TD Name Specify[...]

Chapter 4 Section 4.2 Using the VSAM eWay Database Wizard Creating a New VSAM OTD VSAM eWay Adapter User’s Guide 45 Sun Micros ystems, Inc. Figure 17 Naming an O TD 2 Click Next . 4.2.7 R evie w Selec t ions Review the selections made for the new OTD. Steps R equired to R eview Y our O TD Select ions: 1 V iew the summary of the OTD. If you find y[...]

Chapter 4 Section 4.3 Using the VSAM eWay Database Wizard Resulting OTD VSAM eWay Adapter User’s Guide 46 Sun Micros ystems, Inc. Figure 18 Database Wizard - Summary 4.3 R esulting O TD The resulting VSAM OTD appears on the Ente rprise Designer ’s canvas, in the OTD Editor wind ow . Se e Figure 19. In the example, a node in the OTD has be en ex[...]

Chapter 4 Section 4.4 Using the VSAM eWay Database Wizard St eps to Edit an Existing VS AM OTD VSAM eWay Adapter User’s Guide 47 Sun Micros ystems, Inc. Figure 19 O TD Editor in Enterprise Designer 4.4 Steps to Edit an Exist ing VSAM O TD Y ou can edit any database OTD you cre ate directly from the Enterprise Designer Pr oject Explorer . Steps to[...]

Chapter 4 Section 4.4 Using the VSAM eWay Database Wizard St eps to Edit an Existing VS AM OTD VSAM eWay Adapter User’s Guide 48 Sun Micros ystems, Inc. 5 Step through each of the wizard steps and click Finish to save your changes. Note: Y ou must verify during project activation or at runtime that no errors ar e ge nerated after editing an OTD. [...]

VSAM eWay Adapter User’s Guide 49 Sun Micros ystems, Inc. Chapter 5 Using VSAM O TDs This chapter describes operations you can perform using VSAM Object T ype Definitions (OTDs) in eGate. What ’ s in This Chapter  Overview on page 49  Using T ables on page 49  Using V iews on page 52  Using Prepared Statements on page 52 5.1 Ov er v[...]

Chapter 5 Section 5.2 Using VS AM OTDs Using Tables VSAM eWay Adapter User’s Guide 50 Sun Micros ystems, Inc. 5.2.1 Using the select Method The select method returns r esult sets accordin g to a group of predefined defaults. However , you can change these defa ults, if desir ed. In using the select method, you can specify the following types of r[...]

Chapter 5 Section 5.2 Using VS AM OTDs Using Tables VSAM eWay Adapter User’s Guide 51 Sun Micros ystems, Inc. 5.2.2 Select Operat ions T o 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 Te x t node instructs the Business Pr oces[...]

Chapter 5 Section 5.3 Using VS AM OTDs Using Views VSAM eWay Adapter User’s Guide 52 Sun Micro systems, Inc. 5.3 Using Views V iews are used to look at data from selected columns within selected tables. V iew OTDs are r ead-only . For select operations, see “Select Operations” on page 51 . 5.4 Using P repared Statements Y ou can perform table[...]

VSAM eWay Adapter User’s Guide 53 Sun Microsytems, Inc. Chapter 6 Using VSAM Operat ions The database operations used in the VSAM eW ay ar e used to access the VSAM database. Database operations ar e either accessed thr ough Activities in BPEL, or throug h methods called from a JCD Collaboration. What ’ s in This Chapter  VSAM eW ay Database[...]

Chapter 6 Section 6.1 Using VSAM Operations VSAM eWay Database O perations (BPEL) VSAM eWay Adapter User’s Guide 54 Sun Microsytems, Inc. Figure 20 Input and Output Between Activities The following table lists the expected Inpu t and Output of each database operation Activity . T able 10 VSAM Operations eInsight Operation Acti vit y Input Activ i[...]

Chapter 6 Section 6.2 Using VSAM Operations VSAM eW ay Database Opera tions (JCD) VSAM eWay Adapter User’s Guide 55 Sun Microsytems, Inc. 6.2 VSAM eW a y Dat abase Operat ions ( JCD) The same database operations ar e also used in the JCD, but appear as methods to call from the Collaboration. T ables and V iews ar e manipulated through OTDs. Metho[...]

Chapter 6 Section 6.2 Using VSAM Operations VSAM eW ay Database Opera tions (JCD) VSAM eWay Adapter User’s Guide 56 Sun Microsytems, Inc.  SetScrollT ypetoScrollSensitive  SetScr ollT ypetoInsensitive The Quer y (Select) Operat ion T o per form a quer y operat ion on a tabl e: 1 Execute the select() method with the “ where ” clause spec[...]

Chapter 6 Section 6.2 Using VSAM Operations VSAM eW ay Database Opera tions (JCD) VSAM eWay Adapter User’s Guide 57 Sun Microsytems, Inc. } } The Inser t Operat ion T o per form an inser t operat ion on a tabl e: 1 Execute the insert() method. Assign a field. 2 Insert the row by call ing insertRow() This example inserts an employee r ecord: packa[...]

Chapter 6 Section 6.2 Using VSAM Operations VSAM eW ay Database Opera tions (JCD) VSAM eWay Adapter User’s Guide 58 Sun Microsytems, Inc. FileClient_1.setText( "Done Insert." ); FileClient_1.write(); } } The Update Operation T o per form an update operat ion on a tabl e: 1 Execute the update() method. 2 Using a while loop together with [...]

Chapter 6 Section 6.2 Using VSAM Operations VSAM eW ay Database Opera tions (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 com.stc.codegen.util.TypeConverter typeConvert[...]

Chapter 6 Section 6.2 Using VSAM Operations VSAM eW ay Database Opera tions (JCD) VSAM eWay Adapter User’s Guide 60 Sun Microsytems, Inc. getPrepStatement().getPreparedStatementTest().addBatch(); getPrepStatement().getPreparedStatementTest().executeBatch();[...]

VSAM eWay Adapter User’s Guide 61 Sun Micros ystems, Inc. Chapter 7 Implement ing the VSAM eW a y Sample P rojec ts This chapter pr ovides an introduction t o the VSAM eW ay components, and information on how these components ar e created and implement ed in a Sun Java Composite Application Platform Suite Project. Sample Pr ojects are designed to[...]

Chapter 7 Section 7.1 Implementing the VSAM eWay Sample Proj ects About the VSAM eW ay Sample Projects VSAM eWay Adapter User’s Guide 62 Sun Micros ystems, Inc.  Insert employee r ecords data into the CICSEMP table.  Update an employee r ecord in the CICSEMP table.  Delete an employee r ecord fr om the CICSEMP table. In addition to sampl[...]

Chapter 7 Section 7.1 Implementing the VSAM eWay Sample Proj ects About the VSAM eW ay Sample Projects VSAM eWay Adapter User’s Guide 63 Sun Micros ystems, Inc. Assigning Operat ions in JCD Database operations ar e listed as methods in the JCD. Perform the following steps to access these method s: 1 Cre ate a Collaboration that contains a databa [...]

Chapter 7 Section 7.2 Implementing the VSAM eWay Sam ple Projects Running the Sample Projects VSAM eWay Adapter User’s Guide 64 Sun Micros ystems, Inc. 7.2 Running the Sample P rojects The following steps ar e requir ed to run the sample pr ojects that are containe d in the VSAMeW ayDocs.sar file. 1 Run the SQL script. This cr eates the tables an[...]

Chapter 7 Section 7.4 Implementing the VSAM eWay Sample Projects Importing a Sample Project VSAM eWay Adapter User’s Guide 65 Sun Micros ystems, Inc. 7.4 Import ing a Sample P roject Sample eW ay Projects are included as part of the installation CD-ROM package. T o import a sample eW ay Project to the Enterprise Designer do the following: 1 Extra[...]

Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Buildin g and Depl oying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 66 Sun Micros ystems, Inc. 7.5.1 Creat ing a P rojec t The first step is to cr eate a new Project in the Enterprise Designer . 1 Start the Enterprise Designer . 2 From the Project Explor er tree,[...]

Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Buildin g and Depl oying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 67 Sun Micros ystems, Inc. 8 Click Add , the Add Prepar ed Statement wind ow appears. Enter the following:  Prepar ed Statement Name: Select_ps  SQL Statement: select * from CICSEMP where E[...]

Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Buildin g and Depl oying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 68 Sun Micros ystems, Inc. 2 Cre ate four additional business proc e sses and rename them as follows:  bpUpdate  bpDelete  bpPsSelect  bpT ableSelect 3 Add the following activities to[...]

Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Buildin g and Depl oying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 69 Sun Micros ystems, Inc. Note: Review the eInsight Business Process Manager User ’ s Guide for a more detailed description of the steps required to co nnect and add business rules to a modeli[...]

Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Buildin g and Depl oying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 70 Sun Micros ystems, Inc. Figure 23 bpInser t Business Rule # 2 3 Configure the business rule between otdInputDTD_Emp.unmarshal Activity and the Insert (Scope element), as seen in Figure 24. Fig[...]

Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Buildin g and Depl oying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 71 Sun Micros ystems, Inc. Figure 25 bpInser t Business Rule # 4 5 Configure the business rule in the While s tatement that connects from the otdVSAM.CICSEMPInsert Activity , as seen in Figure 26[...]

Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Buildin g and Depl oying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 72 Sun Micros ystems, Inc. Figure 26 bpInser t Business Rule # 5 6 Configure the business rule fr om the Insert (Scope element) to the FileClient.write Activity , as seen in Figur e 27. Figure 27[...]

Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Buildin g and Depl oying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 73 Sun Micros ystems, Inc. Note: The where clause in the business rule r ead s the trigger value as a placeholder for input. This permits you to mo dify the query to select a sp ecific r ecord. A[...]

Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Buildin g and Depl oying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 74 Sun Micros ystems, Inc. Figure 30 bpUpdate Business Rule # 2 3 Configure the business rul e between the otdVSAM.CICSEMPUpdate Activity and the FileClient.write Activity , as seen in Figure 31.[...]

Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Buildin g and Depl oying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 75 Sun Micros ystems, Inc. Note: Review the eInsight Business Process Manager User ’ s Guide for a more detailed description of the steps required to co nnect and add business rules to a modeli[...]

Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Buildin g and Depl oying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 76 Sun Micros ystems, Inc. 3 Configure the business rule between the otdVSAM.CICSEMPDelete Activity and the FileClient.write Activity , as seen in Figure 35. Figure 35 bpDelete Business Rule # 3 [...]

Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Buildin g and Depl oying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 77 Sun Micros ystems, Inc. Figure 37 bpT ableSelect Business Ru le # 1 2 Configure the business rule between the FileClient.write Activity and otdVSAM.CICSEMPSelectAll Activity as seen in Figur e[...]

Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Buildin g and Depl oying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 78 Sun Micros ystems, Inc. Figure 39 bpSelectT able Business Rule # 3 4 Configure the business rule between the otdInputDTD_Emp.marshal Activity and the FileClient.write Activity as se en in Figu[...]

Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Buildin g and Depl oying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 79 Sun Micros ystems, Inc. 5 Configure the business rule between the FileClient.write Activity and the FileClient.write Activity as seen in Figure 41. Figure 41 bpT ableSelect Business Ru le # 5 [...]

Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Buildin g and Depl oying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 80 Sun Micros ystems, Inc. Figure 43 bpPsSele ct Business Rule # 1 2 Configure the business rule between FileClient.write Activity and otdVSAM.Select_psPSSelectAll Activity as seen in Figur e 44.[...]

Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Buildin g and Depl oying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 81 Sun Micros ystems, Inc. Figure 46 Case 1 Scope Business Rule # 3 5 Configure the business rule between otdInputDTD_Emp.marshal Activity and FileClient.write Activity in the Scope elem ent, as [...]

Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Buildin g and Depl oying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 82 Sun Micros ystems, Inc. 6 Configure Case 2 of the Deci sion branch ing activity . This requir es adding business rules betwe en the otdInputDTD_Emp.marshal and the FileClient.write Activities [...]

Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Buildin g and Depl oying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 83 Sun Micros ystems, Inc. Figure 50 bpSelectT able Business Rule # 6 7.5.4 Creat ing the Connect ivit y Map The Connectivity Map pr ovides a canvas fo r assembling and configuring a Proje ct’s[...]

Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Buildin g and Depl oying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 84 Sun Micros ystems, Inc. Each Connectivity Map in the prjVSAM_BPEL sample Pr oject requir es the following components:  File External Application (2)  VSAM External Application  Busine[...]

Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Buildin g and Depl oying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 85 Sun Micros ystems, Inc. Figure 51 Connectivity Map - Associating (Binding) the Project’ s Components 5 Minimize the bpDelete Binding dialog box by clickin g the chevrons in the upper- right [...]

Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Buildin g and Depl oying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 86 Sun Micros ystems, Inc. 5 Right-click envVSAMProj and select New > File External System . Name the External System esFileClient . Click OK . esFileClient is ad ded to the Environment Editor[...]

Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Buildin g and Depl oying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 87 Sun Micros ystems, Inc. Figure 53 eW ays in the cmDelete Connectivity Map Configur ing the eW ay P ropert ies Steps required to configure the eW a y proper t ies: 1 Double-click the FileClient[...]

Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Buildin g and Depl oying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 88 Sun Micros ystems, Inc. Configur ing the Environment Explorer P ropert ies Steps required to configure the En vironment Explorer pr opert ies: 1 From the Environment Explorer tr ee, right-clic[...]

Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Buildin g and Depl oying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 89 Sun Micros ystems, Inc. Configur ing the Integrat ion Ser ver Y ou must set your SeeBeyond Integration Se rver Passwor d property before deploying your Project. 1 From the Envir onment Explore[...]

Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Buildin g and Depl oying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 90 Sun Micros ystems, Inc. Figure 54 Deployment Profile 7.5.8 C re a ti ng a nd St arti n g t h e D o ma i n T o build and deploy your Project, you mu st first create a domain. A domain is an ins[...]

Chapter 7 Section 7.5 Implementing the VSAM eWay Sample Projects Buildin g and Depl oying the prjVSAM_BPEL Sample Project VSAM eWay Adapter User’s Guide 91 Sun Micros ystems, Inc. 5 Make any necessary changes to the Create Domain dialog box and click Create . The new domain is added to the Domain Mana ger . Sele ct the domain and click the Start [...]

Chapter 7 Section 7.6 Implementing the VSAM eWay Sample Projects Build ing and De ploying the prjV SAM_JC D Sample Project VSAM eWay Adapter User’s Guide 92 Sun Micros ystems, Inc. Having no content in these files caus es the operation to read all records. 2 V erify the output data by viewing the sample output files. See “About the VSAM eW ay S[...]

Chapter 7 Section 7.6 Implementing the VSAM eWay Sample Projects Build ing and De ploying the prjV SAM_JC D Sample Project VSAM eWay Adapter User’s Guide 93 Sun Micros ystems, Inc.  VSAM Database OTD  Inbound DTD OTD  Outbound DTD OTD Steps required to create a VSAM Database O TD: 1 Right-click your new Project in the Enter prise Designe[...]

Chapter 7 Section 7.6 Implementing the VSAM eWay Sample Projects Build ing and De ploying the prjV SAM_JC D Sample Project VSAM eWay Adapter User’s Guide 94 Sun Micros ystems, Inc. Steps required to create inbound and outbound D TD O TDs include: 1 Right-click your new Project in the Enter prise Designer ’s Project Explor er , and select New &g[...]

Chapter 7 Section 7.6 Implementing the VSAM eWay Sample Projects Build ing and De ploying the prjV SAM_JC D Sample Project VSAM eWay Adapter User’s Guide 95 Sun Micros ystems, Inc.  VSAM External Application  Service Any eW ay added to the Connectivity Map is associated with an External System. T o establish a connection to VSAM, first sele[...]

Chapter 7 Section 7.6 Implementing the VSAM eWay Sample Projects Build ing and De ploying the prjV SAM_JC D Sample Project VSAM eWay Adapter User’s Guide 96 Sun Micros ystems, Inc. jcdDelete Collaborat ion Steps required to create the jcdDelete Collaboration: 1 From the Pr oject Explorer , right-c lick the sample Project and select Ne w > Coll[...]

Chapter 7 Section 7.6 Implementing the VSAM eWay Sample Projects Build ing and De ploying the prjV SAM_JC D Sample Project VSAM eWay Adapter User’s Guide 97 Sun Micros ystems, Inc. jcdP sSelect Collaborat ion Steps required to create the jcdP sSelect Collaborat ion: 1 From the Pr oject Explorer , right-c lick the sample Project and select Ne w &g[...]

Chapter 7 Section 7.6 Implementing the VSAM eWay Sample Projects Build ing and De ploying the prjV SAM_JC D Sample Project VSAM eWay Adapter User’s Guide 98 Sun Micros ystems, Inc. 6 Click the Up One Level button t wice to return to the Re pository . Double-click Sun SeeBeyond > eW ays > File > FileClient . The Selected OTDs field now li[...]

Chapter 7 Section 7.6 Implementing the VSAM eWay Sample Projects Build ing and De ploying the prjV SAM_JC D Sample Project VSAM eWay Adapter User’s Guide 99 Sun Micros ystems, Inc. Figure 55 jcdDelete Business Rules Creat ing the jcdIns er t Business Rules The jcdInsert Collaboration implements the Input W eb Service Operation to r ead the T rigg[...]

Chapter 7 Section 7.6 Implementing the VSAM eWay Sample Projects Build ing and De ploying the prjV SAM_JC D Sample Project VSAM eWay Adapter User’s Guide 100 Sun Microsys tems, Inc. public com.stc.codegen.util.TypeConverter typeConverter; public void receive( com.stc.connector.appconn.file.FileTextMessage input, dtd.otdInputDTD_622919076.Emp otdI[...]

Chapter 7 Section 7.6 Implementing the VSAM eWay Sample Projects Build ing and De ploying the prjV SAM_JC D Sample Project VSAM eWay Adapter User’s Guide 101 Sun Microsys tems, Inc. statement query) into the otdInputDTD_CICSEMP OTD and selects all availa ble recor ds from the database. The Collab oration also writes a message to JCD_PsSelect_outp[...]

Chapter 7 Section 7.6 Implementing the VSAM eWay Sample Projects Build ing and De ploying the prjV SAM_JC D Sample Project VSAM eWay Adapter User’s Guide 102 Sun Microsys tems, Inc. FileClient_1.setText( "Selecting record(s) from CICSEMP table via Prepared Statement select .." ); Copies the database resultset into the otdInputDTD_DBE[...]

Chapter 7 Section 7.6 Implementing the VSAM eWay Sample Projects Build ing and De ploying the prjV SAM_JC D Sample Project VSAM eWay Adapter User’s Guide 103 Sun Microsys tems, Inc. meet the criteria EMPID=49 . The Collaboration also writes a message to JCD_T ableSelect_output0.dat to confirm whe n recor ds are se lected, or when no recor ds are [...]

Chapter 7 Section 7.6 Implementing the VSAM eWay Sample Projects Build ing and De ploying the prjV SAM_JC D Sample Project VSAM eWay Adapter User’s Guide 104 Sun Microsys tems, Inc. Copies the database resultset into the otdInputDTD_CICSEMP (XML OTD) and selects all available records from the database that meet the criteria EMPID=49. Checking [...]

Chapter 7 Section 7.6 Implementing the VSAM eWay Sample Projects Build ing and De ploying the prjV SAM_JC D Sample Project VSAM eWay Adapter User’s Guide 105 Sun Microsys tems, Inc. Figure 59 jcdUpdate 7.6.6 Binding the eW a y Components The final step in cr eating a Connectivity Map is binding th e eW ay components together . Steps required to b[...]

Chapter 7 Section 7.6 Implementing the VSAM eWay Sample Projects Build ing and De ploying the prjV SAM_JC D Sample Project VSAM eWay Adapter User’s Guide 106 Sun Microsys tems, Inc. Figure 60 Connectivity Map - Associating (Binding) the Project’ s Components 7 Minimize the jcdDelete Binding dialog box by clicking the chevr ons in the upper- rig[...]

Chapter 7 Section 7.6 Implementing the VSAM eWay Sample Projects Build ing and De ploying the prjV SAM_JC D Sample Project VSAM eWay Adapter User’s Guide 107 Sun Microsys tems, Inc. 5 Right-click envVSAMProj and select New > File External System . Name the External System esFileClient . Click OK . esFileClient is ad ded to the Environment Edit[...]

Chapter 7 Section 7.6 Implementing the VSAM eWay Sample Projects Build ing and De ploying the prjV SAM_JC D Sample Project VSAM eWay Adapter User’s Guide 108 Sun Microsys tems, Inc. Figure 62 eW ays in the cmDelete Connectivity Map Configur ing the eW ay P ropert ies Steps required to configure the eW a y proper t ies: 1 Double-click the FileClie[...]

Chapter 7 Section 7.6 Implementing the VSAM eWay Sample Projects Build ing and De ploying the prjV SAM_JC D Sample Project VSAM eWay Adapter User’s Guide 109 Sun Microsys tems, Inc. Configur ing the Environment Explorer P ropert ies Steps required to configure the En vironment Explorer pr opert ies: 1 From the Environment Explorer tr ee, right-cl[...]

Chapter 7 Section 7.6 Implementing the VSAM eWay Sample Projects Build ing and De ploying the prjV SAM_JC D Sample Project VSAM eWay Adapter User’s Guide 110 Sun Microsys tems, Inc. Configur ing the Integrat ion Ser ver Y ou must set your SeeBeyond Integration Se rver Passwor d property before deploying your Project. 1 From the Envir onment Explo[...]

Chapter 7 Section 7.6 Implementing the VSAM eWay Sample Projects Build ing and De ploying the prjV SAM_JC D Sample Project VSAM eWay Adapter User’s Guide 111 Sun Microsys tems, Inc. Figure 63 Deployment Profile 7.6.10 C re a ti ng a nd St arti n g t h e D o ma i n T o build and deploy your Project, you mu st first create a domain. A domain is an [...]

Chapter 7 Section 7.6 Implementing the VSAM eWay Sample Projects Build ing and De ploying the prjV SAM_JC D Sample Project VSAM eWay Adapter User’s Guide 112 Sun Microsys tems, Inc. 5 Make any necessary changes to the Create Domain dialog box and click Create . The new domain is added to the Domain Mana ger . Sele ct the domain and click the Star[...]

Chapter 7 Section 7.6 Implementing the VSAM eWay Sample Projects Build ing and De ploying the prjV SAM_JC D Sample Project VSAM eWay Adapter User’s Guide 113 Sun Microsys tems, Inc. 2 V erify the output data by viewing the sample output files. See About the VSAM eW ay Sample Projects on page 61 for more details on the types of output files used i[...]

Index VSAM eWay Adapter User’s Guide 114 Sun Microsys tems, Inc. Index A activity input and output 53 Add Prepared Statements 42 alert codes, viewing 17 Automap 89 , 110 B binding dialog box 85 , 106 BPEL operations 53 Delete 53 Insert 53 ReceiveOne 53 SelectAll 53 SelectMultipl e 53 SelectOne 53 Update 53 C Collaboration editor 95 configuring VS[...]

Index VSAM eWay Adapter User’s Guide 115 Sun Microsys tems, Inc. O operations 53 OTD, editing existing 47 outbound eWay properties 25 P prepared statement batch operations 59 executing 59 prepared statements, using 52 Project importing 65 properties ConnectionRetries 29 , 32 ConnectionRetryInterval 30 , 33 DatabaseName 27 , 30 Delimiter 28 , 31 D[...]