Sun Microsystems 5.1.3 manual Using Views, Using Prepared Statements

Page 52

Chapter 5

Section 5.3

Using VSAM OTDs

Using Views

5.3Using 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.4Using Prepared Statements

You can perform table operations with prepared statements with the same method nodes you use for the regular table operations, that is, select, update, insert, and delete SQL operations.

Prepared statements allow you to create any valid SQL statements that comply with ANSI standards. Using this feature, you can execute select statements such as joins and union, insert, update and delete operations. You can also include database operations such as to_date, to manipulate input or output values. Parameter markers are also supported.

Any prepared statement you create shows up in the Collaboration Editor (Java) on the OTD where it was created, as a node with the name you assigned to it. You can implement the statement by dragging its node onto the method box for the action (the desired select, update, insert, or delete operation) in which you want the statement to be used.

Note: When using a Prepared Statement, the ResultsAvailable() method will always return true. Although this method is available, you should not use it with a ‘while’ loop. Doing so would result in an infinite loop at runtime and will stop all of the system’s CPU. If it is used, it should only be used with the ‘if’ statement.

To use a prepared statement in a Collaboration (Java)

1Using the Enterprise Designer and VSAM OTD wizard, create an OTD that contains a prepared statement. See “Add Prepared Statement” on page 41 for details.

2Create the desired Collaboration Definition (Java) using this OTD.

The Collaboration Editor (Java) displays the OTD with a Prepared Statement node. In the OTD structure, you can see both the input parameter and the result set represented as nodes.

3You can assign a Literal value or the input from another OTD to the parameter.

4To run the prepared statement, select the executeQuery method from the Prepared Statement node.

5To view the result set after the query is finished, create a while rule. For the condition, create a next method from the result set node ($Statement1Results in the example). You can continue creating your business logic by adding more Business Rules, if desired.

VSAM eWay Adapter User’s Guide

52

Sun Microsystems, Inc.

Page 51 Page 53
Image 52
Page 51 Page 53
Contents EWAY Adapter for Vsam USER’S Guide Part Number Version Contents Setting Properties of the Vsam eWay Transaction Support Levels Between Different VersionsCreating an Environment Configuring the eWays Delete OperationsActivity Input and Output Prepared Statement Batch OperationsCreating the Collaboration Definitions Java Create the Collaboration Business RulesAbout Vsam What’s in This ChapterAbout the Vsam eWay What’s New in This ReleaseEWay Operation New for VersionAbout This Document Vsam eWay JavadocRelated Documents ScopeIntended Audience Text ConventionsSun Microsystems, Inc. Web Site Documentation FeedbackInstalling the Vsam eWay Installing the Vsam eWayInstalling the Vsam eWay on an eGate supported system Installing Third-Party Products After InstallationExtracting the Sample Projects and Javadocs Copying JAR files to the eDesigner LibraryIcan 5.0 Project Migration Procedures Install Java CapsSteps to extract the Sample Projects include Export the ProjectInstalling Enterprise Manager eWay Plug-Ins Deploy the ProjectTo add plug-ins from the Enterprise Manager Viewing Alert CodesTo View the eWay Alert Codes 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 CP eWay Properties Outbound eWay-JDBC Connector SettingsConnectivity Map Outbound non-Transactional eWay Properties Inbound Vsam eWay-Parameter Settings EWay Environment PropertiesInbound Vsam eWay Properties Outbound Vsam CP eWay PropertiesVsam CP eWay-JDBC Connector Settings Jdbc Connector SettingsIs Vsam Connection Pool Datasource Method-name-1#param #param-2#.........param##method-name-2#param #param-2#........paramConnection Retry Settings Vsam CP eWay-Connection Retry SettingsVsam non-Transactional eWay-JDBC Connector Settings Outbound Vsam non-Transactional eWay PropertiesIs Vsam non-Transactional 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 DatabaseRequired Database Connection Fields include Select Database ObjectsSteps Required to Select Database Objects 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 Overview Using TablesUser-defined OTD Using the select Method To call a method in the Collaboration Editor JavaUpdate Operations Select OperationsInsert Operations Delete OperationsUsing Prepared Statements Using ViewsTo use a prepared statement in a Collaboration Java 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 ProjectsOperations Used in the Vsam Sample Projects Sample input files includeSample output JCD files include Sample output Bpel files includeAssigning Operations in JCD About the eInsight Engine and eGate ComponentsAssigning Operations in Bpel Running the Sample Projects Running the SQL ScriptImporting a Sample Project Building and Deploying the prjVSAMBPEL Sample ProjectCreating the OTDs Creating a ProjectSteps required to create a Vsam Database OTD include Creating the Business Process Creating the Business Process FlowSteps required to create inbound and outbound DTD OTDs Steps to create a business process flow includeBusiness Process Activities Configuring the bpInsert Modeling ElementsBusiness Process Activity 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 Populating the Connectivity Map Creating the Connectivity MapSteps required to create the Connectivity Map Binding the eWay Components To Select a Vsam External SystemTo Select a Vsam Business Process Steps required to bind eWay components togetherCreating an Environment Steps required to create an EnvironmentConfiguring the eWays Environment Editor envVSAMProjConfiguring the eWay Properties Steps required to configure the eWay propertiesFileClientIN eWay Property Settings FileClientOUT eWay Property SettingsFile eWay Environment Properties Configuring the Environment Explorer PropertiesSection Property Name Required Values Creating the Deployment Profile Configuring the Integration ServerSteps required to create the Deployment Profile Creating and Starting the Domain Steps required to create and start the domainBuilding and Deploying the Project Running the Sample ProjectBuild the 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 SystemJcdDelete Collaboration JcdInsert CollaborationSteps required to create the jcdDelete Collaboration Steps required to create the jcdInsert CollaborationJcdPsSelect Collaboration JcdTableSelect CollaborationSteps required to create the jcdPsSelect Collaboration Steps required to create the jcdTableSelect CollaborationJcdUpdate Collaboration Steps required to create the jcdUpdate CollaborationCreate the Collaboration Business Rules 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