Sun Microsystems 5.1.3 Using the select Method, To call a method in the Collaboration Editor Java

Page 50

Chapter 5

Section 5.2

Using VSAM OTDs

Using Tables

5.2.1Using 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, you can specify the following types of result sets:

ƒTYPE_FORWARD_ONLY

ƒTYPE_SCROLL_INSENSITIVE

ƒTYPE_SCROLL_SENSITIVE

You can also specify the following result sets with a type of concurrency:

ƒCONCUR_READ_ONLY

ƒCONCUR_UPDATABLE

To perform an update, insert or delete operation, the type of the result set returned by the select method must be CONCUR_UPDATABLE.

Instead of specifying the type of result set and concurrency in the select method, you can also use the following methods:

ƒsetConcurrencytoUpdatable

ƒsetConcurrentlytoReadOnly

ƒsetScrollTypetoForwardOnly

ƒsetScrollTypetoScrollSensitive

ƒsetScrollTypetoInsensitive

Note: Because of driver limitations, before you can do any modifications (insert, update, or delete) to a table, the table must be under CICS control on the mainframe.

To call a method in the Collaboration Editor (Java)

1Open the eGate Enterprise Designer’s Collaboration Editor (Java) for the desired Collaboration Definition.

2In the editor, navigate to the Business Rules Designer.

3Right-click on the desired node (right or left pane) where you want to call the method.

A pop-up Method selection menu appears, showing the methods available for the node.

4Select the desired method.

A Method box appears in the center pane of the Business Rules Designer. This box represents the chosen method.

Note: Using the commit method is optional for all update operations because the Collaboration automatically commits the current transaction when it is done.

VSAM eWay Adapter User’s Guide

50

Sun Microsystems, Inc.

Page 49 Page 51
Image 50
Page 49 Page 51
Contents EWAY Adapter for Vsam USER’S Guide Part Number Version Contents Setting Properties of the Vsam eWay Transaction Support Levels Between Different VersionsActivity Input and Output Creating an Environment Configuring the eWaysDelete Operations Prepared Statement Batch OperationsCreating the Collaboration Definitions Java Create the Collaboration Business RulesAbout Vsam What’s in This ChapterEWay Operation About the Vsam eWayWhat’s New in This Release New for VersionAbout This Document Vsam eWay JavadocIntended Audience Related DocumentsScope Text ConventionsSun Microsystems, Inc. Web Site Documentation FeedbackInstalling the Vsam eWay Installing the Vsam eWayInstalling the Vsam eWay on an eGate supported system Extracting the Sample Projects and Javadocs Installing Third-Party ProductsAfter Installation Copying JAR files to the eDesigner LibrarySteps to extract the Sample Projects include Ican 5.0 Project Migration ProceduresInstall Java Caps Export the ProjectInstalling Enterprise Manager eWay Plug-Ins Deploy the ProjectTo View the eWay Alert Codes Viewing Alert CodesTo add plug-ins from the Enterprise Manager Alert Codes for the Vsam eWay Alert Code\Description Description Details User ActionsAduncommitted Creating and Configuring a Vsam eWay Configuring the eWay Connectivity Map PropertiesTo configure the eWay properties Connectivity Map with ComponentsTransaction Support Levels Between Different Versions Outbound eWay PropertiesConfiguring the eWay Environment Properties To Configure the Environment PropertiesVsam eWay Environment Configuration EWay Connectivity Map PropertiesConnectivity Map Outbound non-Transactional eWay Properties Outbound eWay-JDBC Connector SettingsConnectivity Map Outbound CP eWay Properties Inbound Vsam eWay Properties Inbound Vsam eWay-Parameter SettingsEWay Environment Properties Outbound Vsam CP eWay PropertiesIs Vsam Connection Pool Datasource Jdbc Connector SettingsVsam CP eWay-JDBC Connector Settings ##method-name-2#param Method-name-1#param#param-2#.........param #param-2#........paramConnection Retry Settings Vsam CP eWay-Connection Retry SettingsIs Vsam non-Transactional Vsam non-Transactional eWay-JDBC Connector SettingsOutbound Vsam non-Transactional eWay Properties Connection Pool DatasourceMethod-name-1#param Vsam non-Transactional eWay-Connection Retry Settings Vsam non-Transactional eWay-Connection Retry Settings About the Database OTD Wizard Creating a New Vsam OTDSelect Wizard Type Connect To DatabaseSteps Required to Select Database Objects Include Select Database ObjectsRequired Database Connection Fields include Select Tables/Views/Aliases Steps Required to Select Table and Views IncludeSelect Tables/Views/Aliases Database Wizard All Schemes Selected Tables/Views/Aliases window with a table selected Add Prepared Statement Table/View ColumnsSteps Required to Add Prepared Statements Include Prepared StatementPrepared SQL Statement Specify the OTD Name Steps Required to Specify the OTD NameReview Selections Steps Required to Review Your OTD SelectionsResulting OTD Database Wizard SummarySteps to Edit an Existing Vsam OTD Steps to Edit the OTD from the Enterprise Designer IncludeVsam eWay Adapter User’s Guide Sun Microsystems, Inc User-defined OTD Using TablesOverview Using the select Method To call a method in the Collaboration Editor JavaInsert Operations Update OperationsSelect Operations Delete OperationsTo use a prepared statement in a Collaboration Java Using ViewsUsing Prepared Statements Vsam eWay Database Operations Bpel Activity Input and OutputVsam Operations EInsight Operation Activity Input Activity OutputVsam eWay Database Operations JCD Query Select Operation To perform a query operation on a tableInsert Operation OtdVSAM1.getCICSEMP.insertRowUpdate Operation Delete OperationPrepared Statement Batch OperationsChapter Section Using Vsam Operations Implementing the Vsam eWay Sample Projects About the Vsam eWay Sample ProjectsSample output JCD files include Operations Used in the Vsam Sample ProjectsSample input files include Sample output Bpel files includeAssigning Operations in Bpel About the eInsight Engine and eGate ComponentsAssigning Operations in JCD Running the Sample Projects Running the SQL ScriptImporting a Sample Project Building and Deploying the prjVSAMBPEL Sample ProjectSteps required to create a Vsam Database OTD include Creating a ProjectCreating the OTDs Steps required to create inbound and outbound DTD OTDs Creating the Business ProcessCreating the Business Process Flow Steps to create a business process flow includeBusiness Process Activity Configuring the bpInsert Modeling ElementsBusiness Process Activities BpInsert Business Process Steps required to configure the bpInsert business processBpInsert Business Rule # BpInsert Business Rule # Configuring the bpUpdate Modeling Elements BpUpdate Business Process Steps required to configure the bpUpdate business processConfiguring the bpDelete Modeling Elements Steps required to configure the bpDelete business process BpDelete Business ProcessConfiguring the bpTableSelect Modeling Elements BpTableSelect Business ProcessBpTableSelect Business Rule # BpSelectTable Business Rule # Configuring the bpPsSelect Modeling Elements Steps required to configure the bpPsSelect business processBpPsSelect Business Rule # Case 1 Scope Business Rule # Activities within Case 2 Scope Steps required to create the Connectivity Map Creating the Connectivity MapPopulating the Connectivity Map To Select a Vsam Business Process Binding the eWay ComponentsTo Select a Vsam External System Steps required to bind eWay components togetherCreating an Environment Steps required to create an EnvironmentConfiguring the eWays Environment Editor envVSAMProjFileClientIN eWay Property Settings Configuring the eWay PropertiesSteps required to configure the eWay properties FileClientOUT eWay Property SettingsSection Property Name Required Values Configuring the Environment Explorer PropertiesFile eWay Environment Properties Steps required to create the Deployment Profile Configuring the Integration ServerCreating the Deployment Profile Creating and Starting the Domain Steps required to create and start the domainBuild the Project Building and Deploying the ProjectRunning the Sample Project Steps required to run the sample ProjectBuilding and Deploying the prjVSAMJCD Sample Project Steps required to create a Vsam Database OTD Creating a Connectivity Map Steps required to create a new Connectivity MapCreating the Collaboration Definitions Java Steps required to select a Vsam External SystemSteps required to create the jcdDelete Collaboration JcdDelete CollaborationJcdInsert Collaboration Steps required to create the jcdInsert CollaborationSteps required to create the jcdPsSelect Collaboration JcdPsSelect CollaborationJcdTableSelect Collaboration Steps required to create the jcdTableSelect CollaborationCreate the Collaboration Business Rules JcdUpdate CollaborationSteps required to create the jcdUpdate Collaboration Creating the jcdDelete Business RulesCreating the jcdInsert Business Rules Sample code from the jcdInsert IncludesCreating the jcdPsSelect Business Rules JcdPsSelect Sample code from the jcdPsSelect IncludesCreating the jcdTableSelect Business Rules JcdTableSelect Sample code from the jcdTableSelect IncludesCreating the jcdUpdate Business Rules JcdUpdate Binding the eWay Components106 107 108 109 110 111 Running the Sample 113 Index 115

5.1.3 specifications

Sun Microsystems 5.1.3 represents a significant version in the evolution of Sun's software products, particularly in the area of network operating systems and development tools. Released during a time when Sun was a leading enterprise in the field of computing, 5.1.3 brought a host of new features, enhancements, and technologies that catered to the demands of users looking for robust and reliable IT infrastructure.

One of the defining characteristics of Sun Microsystems 5.1.3 was its enhanced scalability. The operating system was designed to handle large amounts of data processing and support numerous simultaneous users. This feature made it particularly attractive for businesses operating in resource-intensive environments such as finance, telecommunications, and large-scale enterprise applications.

A significant focus for 5.1.3 was its improved networking capabilities. The release integrated advanced networking protocols, allowing for better interoperability between systems. This feature enabled seamless communication across diverse hardware platforms, thus enhancing productivity and collaboration among users.

In terms of software development, Sun Microsystems 5.1.3 included an updated toolset that made application development more accessible. Its support for various programming languages, including C, C++, and Java, facilitated a versatile development environment. The included Sun C/C++ Compiler was particularly noteworthy, providing developers with optimized performance and debugging features.

Security features were also a priority in 5.1.3, addressing growing concerns over data protection and system vulnerabilities. The system implemented advanced user authentication, role-based access controls, and encrypted communications, thereby bolstering the integrity of user data and enhancing overall system security.

Additionally, Sun Microsystems 5.1.3 incorporated reliable file system technologies like the Sun File System (UFS), which offered improved performance and data integrity. This file system was particularly effective for enterprises that required high availability and data protection due to its robust recovery options.

Overall, Sun Microsystems 5.1.3 showcased a blend of advanced technologies, user-oriented features, and robust performance characteristics that positioned it as a compelling choice for enterprises seeking reliable and efficient computing solutions. It illustrated Sun's continuous commitment to innovation, ensuring users were equipped with the cutting-edge tools necessary to thrive in an increasingly digital world.
Top Page Image Contents