manualshive.com logo in svg

Oracle Application Server 10.1.3.4, User Manual

Share
Download
Oracle Application Server 10.1.3.4 User Manual Download Page 159

Supported SQL Syntax and SQL Enhancements

D-1

D

Supported SQL Syntax and SQL

Enhancements

OracleAS Adapter for IMS/DB provides basic support for standard ANSI '92 SQL 
along with a number of enhancements, all of which can be used when specifying 
adapter interactions.

This appendix contains the following sections:

■

Supported SQL Statements

■

Supported Operators

■

Supported Functions

■

SQL Enhancements

Supported SQL Statements

OracleAS Adapter for IMS/DB supports 

SELECT

, 

DELETE

, 

INSERT

, and 

UPDATE

 

statements, when specified in interactions.

Supported Operators

OracleAS Adapter for IMS/DB enables the use of the following operators in SQL 
statements:

■

Arithmetic Operators

■

Comparison Operators

Table D–1

Arithmetic Operators

Operator

+

-

*

/

Table D–2

Comparison Operators

Operator

=

Summary of Contents for Application Server 10.1.3.4

Page 1: ...Oracle Application Server Adapters for IMS DB User s Guide 10g Release 3 10 1 3 4 E13832 01 December 2008 ...

Page 2: ...cquisition Regulation and agency specific supplemental regulations As such the use duplication disclosure modification and adaptation shall be subject to the restrictions and license terms set forth in the applicable Government contract and to the extent applicable by the terms of the Government contract the additional rights set forth in FAR 52 227 19 Commercial Computer Software License December...

Page 3: ......

Page 4: ......

Page 5: ...form 2 2 Installation Worksheet 2 3 Preinstallation Tasks 2 4 Importing the Installation Kit 2 5 Installation Instructions 2 5 Post Installation Instructions 2 8 Post Installation Procedures 2 8 Starting the Daemon 2 10 Setting Up Oracle Connect for Reentrancy 2 10 Setting Up Oracle Connect to Update IMS DB Data 2 11 Updating an Existing Oracle Connect Installation with IMS DB 2 11 Installing Orac...

Page 6: ...4J Integrating OracleAS Adapter for IMS DB with OC4J 3 1 Configuring the J2CA 1 5 IMS DB Adapter 3 2 Using the CCI API to Develop Applications 3 3 Configuring Multiple Adapters 3 4 Updating Configuration Information 3 4 4 Integrating OracleAS Adapters for IMS DB with Oracle BPEL Process Manager Integrating OracleAS Adapters for IMS DB with Oracle BPEL Process Manager 4 1 Configuring Oracle BPEL Pr...

Page 7: ...arting the Daemon 7 1 Task Starting the Daemon 7 2 Shutting Down the Daemon 7 2 Monitoring the Daemon During Run Time 7 2 Daemon Computer Options 7 2 Workspace Options 7 3 Server Options 7 4 Daemon Logs 7 4 The Daemon Log Monitor 7 5 The Workspace Log Monitor 7 5 The Server Log Monitor 7 5 Resolving Communication Errors 7 6 Resolving Specific Errors 7 6 8 Advanced Features of OracleAS Adapter for ...

Page 8: ...ics A 10 Advanced Tab A 11 Adapter Metadata A 13 Adapter Metadata General Properties A 13 Adapter Metadata Interactions A 15 Interaction Advanced Tab A 16 Adapter Metadata Schema Records A 18 Adapter Metadata XML A 20 B Back end Adapter Data Type Support Data Type Mapping B 1 C Advanced Tuning of the Daemon Control C 1 Logging C 3 Security C 5 Workspaces C 7 General C 7 Server Mode C 11 Security C...

Page 9: ...ix Flattening Hierarchical Data Using SQL D 4 Using an Alias D 4 E Globalization Settings Defining the Language and Codepage E 1 Index ...

Page 10: ...x ...

Page 11: ...l is to make Oracle products services and supporting documentation accessible to all users including users that are disabled To that end our documentation includes features that make information available to users of assistive technology This documentation is available in HTML format and contains markup to facilitate access by the disabled community Accessibility standards will continue to evolve ...

Page 12: ...er Assistant contacts Oracle Support Services an Oracle Support Services engineer will handle technical issues and provide customer support according to the Oracle service request process Related Documents For more information see the following documents in the Oracle Other Product One Release 7 0 documentation set or in the Oracle Other Product Two Release 6 1 documentation set Oracle Application...

Page 13: ...dapter for IMS DB includes the following feature Captures and maintains a metadata schema for IMS DB by importing various IMS definition files such as a PSB file DBD files and COBOL copybooks These are transformed into mapping definition for Oracle Connect for IMS DB on the z OS computer Uses an enterprise application integration EAI model Users of a requesting application can model the interactio...

Page 14: ...ication The J2CA 1 5 IMS DB adapter converts the J2CA interaction invocation received from Oracle Application Server to the XML format and passes the XML format to Oracle Connect on the legacy server The daemon listens for the request coming from the J2CA 1 5 IMS DB adapter client and assigns a server process to handle the request The properties of the server process such as connection pooling req...

Page 15: ...Tasks Before installing OracleAS Adapter for IMS DB ensure that your computer meets the following requirements IBM z OS Hardware and Software Requirements IBM z OS Hardware and Software Requirements This section describes the following requirements for installing Oracle Connect on an IBM z OS platform Hardware Requirements Software Requirements Hardware Requirements The following table summarizes ...

Page 16: ...requirement depends on such things as the size of the database and the number of databases accessed Disk Space 3380 and 3390 disks 150 cylinders Table 2 2 Oracle Connect Software Requirements Software Component Requirements Operating System IBM z OS CICS TP Monitor if accessing IMS DB data under CICS V4R1 or higher recommended to use CICS V6R1 or higher CICS EXCI support must be installed and IRCS...

Page 17: ...k space 150 cylinders Memory The minimum requirement is 4MBfor each connection A connection is defined as a connection to a server process or daemon The actual memory requirement depends on such things as the size of the database and the number of databases accessed Installation high level qualifier OCL10134 Volume Unit 3390 SMS only unit where SMS resides Output class A JCL job card An optional c...

Page 18: ...d in the following datasets OCL10134 TRANSMIT KIT OCL10134 TRANSMIT LOAD These datasets are provided in the following directory Oracle_Connect IMSDB_Legacy_Adapter Table 2 5 Installation Checklist Step Comment Outputs tso profile noprefix Ensures that the user name is not used as part of the dataset name allocated in the next steps Allocate dataset HLQ TRANSMIT KIT 130 tracks 3390 format FB record...

Page 19: ...ng steps to install Oracle Connect 1 Run the following command at the TSO prompt RECEIVE INDSNAME nnn TRANSMIT KIT Where nnn represents the high level qualifier you want to assign for the Oracle Connect installation Assign the high level qualifier you specified in step 7 of the preinstallation tasks The default value is OCL10134 2 Enter the following command when prompted for the restore parameter...

Page 20: ...ot specified then enter the unit name for temporary datasets used during the installation procedure ENTER THE VOLUME NAME FOR INSTALLATION TEMP DATASETS This prompt is displayed only if SMS is not used to manage the installation you answered N to the first prompt The volume name for temporary datasets used during the installation procedure ENTER THE OUTPUT CLASS FOR INSTALLATION OUTPUT A Enter the...

Page 21: ...olume name for temporary datasets used during the installation procedure PLEASE CONFIRM YES NO QUIT YES Confirm the entered details ENTER THE OUTPUT CLASS FOR INSTALLATION OUTPUT A Enter the output class for Oracle Connect output Assigning a device which is set on HOLD prevents the loss of log information when the Oracle Connect started tasks finish the default is A DO YOU WANT TO USE THE DEFAULT ...

Page 22: ...IMS DB Adapter Installation Prompts and Responses Screen Response ENTER DBD LIBRARY NAME Enter the IMS DBD Library name for IMS on your system ENTER PSB LIBRARY NAME Enter the IMS PSB Library name for IMS on your system ENTER RES LIBRARY NAME Enter the IMS RES Library name for IMS on your system ENTER PROC LIBRARY NAME Enter the IMS PROC Library name for IMS on your system ENTER PGM LIBRARY NAME E...

Page 23: ...DINI After PARM B L ip_address 2551 START IRPCDINI Where ip_address specifies the IP address of the computer 2551 is the default port for starting the daemon and IRPCDINI is the default daemon configuration The ATTDAEMN and ATTSRVR started tasks need permission to use an Open Edition TCP IP stack The owner must be a user with OMVS segment defined and OMVS UID 0000000000 In the security manager suc...

Page 24: ... 2551 in the TCP IP network services file consult TCP IP documentation Starting the Daemon Activate INSTROOT USERLIB ATTDAEMN as a started task to invoke the daemon For example in the SDSF screen enter the following s ATTDAEMN Where INSTROOT is the high level qualifier where Oracle Connect is installed To submit the daemon as a job uncomment the first two lines of the ATTDAEMN JCL change the PARM ...

Page 25: ...ing JCL IDCSYSIN DD DSN IMSDB DISP NEW DELETE DELETE SPACE TRK 1 UNIT SYSDA DCB BLKSIZE 3200 LRECL 80 RECFM FB Updating an Existing Oracle Connect Installation with IMS DB Verify that you have all the information detailed in the following installation worksheets so you can refer to it during the configuration process In the nnn BUILDKIT SRC library execute the IMSDB member ex IMSDB Note If you int...

Page 26: ...ER RES LIBRARY NAME Enter the IMS RES Library name for IMS on your system ENTER PROC LIBRARY NAME Enter the IMS PROC Library name for IMS on your system ENTER PGM LIBRARY NAME Enter the IMS PGM Library name for IMS on your system ENTER YOUR PSB NAME Enter the name of the PSB file with the name of your IMS database YOUR DBDLIB IS YOUR PSBLIB IS YOUR RESLIB IS YOUR PROCLIB IS YOUR PGMLIB IS YOUR PSB...

Page 27: ...cle Studio with the Wizard SH installation You can install Oracle Studio by using the installation wizard This allows you to easily carry out any standard or custom installation Do the following for the Linux SH installation 1 Install into a directory where you have permission 2 Change the mode to execute mode Type in Chmod x file name 3 Enter the following file name If you are not installing to t...

Page 28: ...nter the name of the computer you want to connect to or click Browse to select the computer from the list of computers that is displayed and which use the default port 2551 4 Specify the username and password of the user who was specified as the administrator when Oracle Connect was installed The Add Machine screen is shown in the following figure Figure 2 1 The Add Machine screen 5 Click Finish N...

Page 29: ... User Access to the IBM z OS Platform Setting Password Access to Oracle Studio Initially any operation performed using Oracle Studio does not require a password You can set a password so that the first operation that involves accessing the server from Oracle Studio requires a password to be entered Perform the following steps to set password access to Oracle Studio 1 From the Start menu select Pro...

Page 30: ...s on that computer from Oracle Studio This user can then authorize other users to make changes or to view the definitions for a selected computer Adding a computer to Oracle Studio is described in Setting Up the IBM z OS Platform in Oracle Studio on page 2 14 1 From the Start menu select Programs Oracle and then select Studio Oracle Studio opens 2 In the Design perspective Configuration view Right...

Page 31: ...computer in Oracle Studio for the selected computer Regular users cannot modify any of the definitions 3 Add users or groups of users by clicking Add User or Add Group for the relevant sections The user or group that is added must be recognized as a valid user or group for the computer Once a name has been added to a section only the user or group who logs on with that user name has the relevant a...

Page 32: ...ollowing figure Figure 2 5 The User Editor pane 5 In the User editor click Add The Add Authenticator screen is displayed as shown in the following figure Figure 2 6 The Add Authenticator screen 6 Select Remote Machine from the Resource Type list 7 Enter the name of the IBM z OS computer defined in Oracle Studio 8 Enter the name and password used to access the computer and confirm the password 9 Cl...

Page 33: ...he node of the computer defined in Setting Up the IBM z OS Platform in Oracle Studio on page 2 14 4 Expand the Bindings folder The binding configurations available on this computer are listed 5 Expand the NAV binding The NAV binding configuration includes folders for data sources and adapters that are located on the computer 6 Right click Data sources and select New data source to open the New dat...

Page 34: ... DBCTL then the following screen is displayed Figure 2 8 The Data Source Connect String screen for IMS DBCTL Where PSB Name Specify the name of the PSB file that contains details of all the IMS DB databases that you want to access Target System Specify the VTAM APPLID of the CICS target system The default value is CICS This parameter is used when updating IMS DB data You can determine this value b...

Page 35: ...eight characters and may span between multiple systems XCF member The Cross System Coupling Facility group member Tpipe prefix The transaction pipe prefix used to associate between the transaction and the transaction pipe it is using The default value is ATTU User name The security facility user identification Group name The security facility group identification imsTrans name The name of the IMS ...

Page 36: ... in the connect string this parameter specifies the VTAM applid of the CICS target system The default value is CICS This parameter is used when updating VSAM data You can determine this value by activating the CEMT transaction on the target CICS system The legend APPLID target_system appears in the bottom right corner of the screen vtamNetname The VTAM NetName in the connect string this parameter ...

Page 37: ...Properties You configure the advanced properties for a data source in the Advanced tab of the data source editor The advanced settings are the same for every data source Advanced settings let you do the following Define the transaction type Edit the syntax name Provide a table owner Determine if a data source is updateable or readable Provide repository information Set the virtual view policy Use ...

Page 38: ...llowing Updateable data Select this if you want to be able to update the data on the data source Read only data Select this to allow users to only view the data on the data source Repository Directory Repository directory Enter the location for the data source repository Repository name Enter the name of a repository for a data source The name is defined as a data source in the binding configurati...

Page 39: ...he Imput Files Applying Filters Selecting Tables Matching DBD to COBOL Import Manipulation Metadata Model Selection Import the Metadata Selecting the Imput Files 1 From the Start menu select Programs Oracle and then select Studio 2 In the Configuration view expand the computer defined in Setting Up the IBM z OS Platform in Oracle Studio 3 Expand Bindings The binding configurations available on thi...

Page 40: ...following figure Figure 2 10 The Metadata Import dialog box 11 Click Finish The Metadata Import wizard opens 12 Click Add in the Import Wizard to add DBD files The Add Resource screen is displayed providing the option of selecting files from the local machine or copying the files from another machine Figure 2 11 The Select Resources screen 13 Click Add The Select Resources screen is displayed whic...

Page 41: ...17 Select the files to import and click Finish to start the transfer 18 Repeat the procedure for COBOL copybooks The format of the COBOL copybooks must be the same For example you cannot import a COBOL copybook that uses the first six columns together with a COBOL copybook that ignores the first six columns In this type of case repeat the import process You can import the metadata from one COBOL c...

Page 42: ...Mode Specify either NOIBMCOMP for byte storage mode or IBMCOMP for word storage mode Ignore after column 72 Ignore columns 73 to 80 in the COBOL copybooks Ignore first 6 columns Ignore the first six columns in the COBOL copybooks Prefix nested column Prefix all nested columns with the previous level heading Replace hyphens in record and field names with underscores _ A hyphen which is an invalid c...

Page 43: ...oks The following procedure continues the Applying Filters step Perform these steps to select the tables 1 From the Select Tables screen select the tables that you want to access To select all tables click Select All To clear all the selected tables click Unselect All The Select Tables screen is shown in the following figure Figure 2 14 Select Tables Screen The import manager identifies the names ...

Page 44: ...cords in the DDM Declaration files that will be imported as tables You can manipulate the general table data in the Import Manipulation Screen Perform the following steps to manipulate the table metadata 1 From the Import Manipulation screen see Import Manipulation Screen figure right click the table record marked with a validation error and select the relevant operation See the table Table Manipu...

Page 45: ... The following operations are available in the Import Manipulation screen Resolving table names where tables with the same name are generated from different files during the import Selecting the physical location for the data Selecting table attributes Manipulating the fields generated from the COBOL as follows Merging sequential fields into one for simple fields Resolving variants by either marki...

Page 46: ...tion Screen The Field Manipulation screen lets you make changes to fields in a selected table You get to the Field Manipulation screen through the Import Manipulation Screen The Field Manipulation screen is shown in the following figure Table 2 13 Table Manipulation Options Option Description Fields Manipulation Customizes the field definitions using the Field Manipulation screen You can also acce...

Page 47: ...4 Field Manipulation Screen Commands Command Description General menu Undo Click to undo the last change made in the Field Manipulation screen Select fixed offset The offset of a field is usually calculated dynamically by the server at runtime according the offset and size of the proceeding column Select this option to override this calculation and specify a fixed offset at design time This can ha...

Page 48: ...d number of rows Enter the amount of rows you want returned in the following field 100 is the default value Define Where Clause Click Add to select a column to use in a Where clause In the table below you can add the operator value and other information Click on the columns to make the selections To remove a Where Clause select the row with the Where Clause you want t remove and then click Remove ...

Page 49: ...t the dimension for the selected array Set field attribute Select a row to set or edit the attributes for the field in the row Select Set field attribute to open the Field Attribute screen Click in the Value column for any of the properties listed and enter a new value or select a value from a drop down list Nullable Not nullable Select Nullable to activate the Nullable column in the Field Manipul...

Page 50: ...ld to the table Delete field Select a row and then select Delete Field or click the Delete Field button to delete the field in the selected row Move up or down Select a row and use the arrows to move it up or down in the list Rename field Select Rename field to make the Name field active Change the name and then click outside of the field Sturctures menu Columnwise Normalization Select Columnwise ...

Page 51: ...t is an array This field must be defined as Group for its data type When you flatten an array field the entries in the array are spread into a new table with each entry in its own field The following screen provides options for flattening Do the following in this screen Select Recursive operation to repeat the flattening process on all levels For example if there are multiple child fields in this ...

Page 52: ...on editor Select one of the following Default values for all tables Select this if you want to configure the same values for all the tables in the import Make the following selections when using this option Generate sequential view Select this to map non relational files to a single table Generate virtual views Select this to have individual tables created for each array in the non relational file...

Page 53: ...ect one of the following true Select true for virtual views to include all the columns in the par ent record This is true for this table only even in the data source is not configured to include all of the parent record columns false Select false so virtual views do not include the columns in the parent record for this table even if the data source is configured to include all of the parent record...

Page 54: ...elect Yes to immediately transfer the metadata from the Windows computer to the z OS platform or No to transfer the metadata later The metadata is imported based on the options selected in the previous steps and it is stored on the IBM z OS platform computer An XML representation of the metadata is generated This XML file can be viewed by expanding the Output node 2 Click Finish After performing t...

Page 55: ...s to and from the IMS DB data Perform the following steps to setup the adapter 1 From the Start menu select Programs Oracle and then select Studio 2 From the Design perspective Configuration view expand the Machines folder 3 In the Configuration view expand the computer defined in Setting Up the IBM z OS Platform in Oracle Studio on page 2 14 4 Expand the Bindings folder 5 Expand the NAV binding 6...

Page 56: ...e following properties are available Generating Outbound Interactions Oracle Connect requires metadata describing the adapter interactions including the structures used to pass information to and from the adapter Note Other adapters that are displayed in the Type list are not supported with the version of Oracle Connect installed at the site Table 2 15 Adapter Properties Property Description Conne...

Page 57: ...s database query a SELECT statement or Database Modification an INSERT UPDATE or DELETE statement 10 Select how you want to generate interactions Automatic or Manual If you select Automatic generation perform the following steps a Click Next The Select Tables screen opens enabling you to add tables from the IMS DB data source that you want to access with the interaction b Click Add to include tabl...

Page 58: ...TE or DELETE Table 2 16 Interaction Definition Parameters Parameter Description passThrough Defines whether the query is passed directly to the back end database for processing or processed by the Query Processor Reuse compiled query Defines whether the query is saved in cache for reuse Encoding Sets the encoding method used to return binary data in text format You can select between the base 64 a...

Page 59: ...ects to receive a response sync send The interaction sends a request and does not expect to receive a response sync receive The interaction expects to receive a response The information for a request is passed in the input record The information for the response from the IMS DB data source is passed in the output record For more information see Adapter Metadata General Properties 2 Click the Advan...

Page 60: ... select Update interaction related records Any changes that need making to the record structures in the schema part of the metadata are done automatically The Context Selection screen is shown in the following figure Figure 2 21 The Context Selection screen 4 Click Finish to implement the modifications made to the interaction definitions Note The interaction records are built based on all the fiel...

Page 61: ... with the EIS The Oracle adapters are deployed as a resource adapter within the OC4J container The contract between the OC4J client application and the resource adapter is defined by the common client interface CCI The contract between the OC4J container and the resource adapter is defined by the service provider interface SPI The SPI API addresses the connection management transaction management ...

Page 62: ... name userName value config property name password value config property name eisName value config property name serverName value config property name workspace value config property name portNumber value config property name persistentConnection value config property name keepAlive value config property name firewallProtocol value config property name connectTimeout value config property name enc...

Page 63: ...erver The user is defined in the Oracle Connect daemon configuration See Also Daemon Security and Workspace Security for details about users allowed to access an Oracle Connect server password optional Specifies a valid password for the user persistentConnection optional Set to true or false When set to true connections can persist across multiple requests or connection context changes It is recom...

Page 64: ...ec queryRecord 4 Invoke the execute method on the interaction to initiate a call to the EIS Pass any data for the interaction as input and output records 5 Once the interactions have been processed close the Interaction and Connection objects Configuring Multiple Adapters Each J2CA 1 5 IMS DB adapter requires an entry in the oc4j ra xml file as described in Configuring the J2CA 1 5 IMS DB Adapter ...

Page 65: ...n and redeployment of existing business processes Each business activity is a self contained self describing and modular application whose interface is defined by the WSDL and the business process is modeled as a Web Service A Web Service is first published and then composed or orchestrated into business flows Publishing a service is implemented by taking a function within an existing application ...

Page 66: ...verify that the metadata of the Oracle Connect server is available in Oracle BPEL Process Manager 1 Open Oracle JDeveloper 2 On the Connections tab expand the Integration Server node to view the list of OC4J servers 3 Expand the node of the OC4J server on which you configured the JCA 1 5 IMS DB adapter see Integrating OracleAS Adapter for IMS DB with OC4J 4 Under the Adapters node expand the Legac...

Page 67: ...eType xsd restriction base xsd string xsd maxLength value 8 xsd restriction xsd simpleType xsd attribute xsd attribute name CA_ACCT_I_NUM type xsd int xsd complexType xsd schema xsd schema xmlns xsd http www w3 org 2001 XMLSchema xmlns noNamespace findIMSAccount targetNamespace noNamespace findIMSAccount elementFormDefault qualified attributeFormDefault unqualified xsd element name CA_OUTPUT type ...

Page 68: ... element xsd sequence xsd attribute name CA_CUST_NAME_F xsd simpleType xsd restriction base xsd string xsd maxLength value 10 xsd restriction xsd simpleType xsd attribute xsd attribute name CA_CUST_NAME_M xsd simpleType xsd restriction base xsd string xsd maxLength value 1 xsd restriction xsd simpleType xsd attribute xsd attribute name CA_CUST_NAME_L xsd simpleType xsd restriction base xsd string ...

Page 69: ...adapter fw record oracle AttuXMLRecordConver terImpl operation name findAccount jca operation FunctionName findAccount InteractionSpec com oracle adapter AttuInteractionSpec ExecutionTimeout 120 input output operation binding service name findAccountService port name findAccountPort binding tns findAccountJCABinding jca address adapterInstanceJndi eis legacy findIMSAccount port service plt partner...

Page 70: ...Configuring Oracle BPEL Process Manager 4 6 Oracle Application Server Adapters for IMS DB User s Guide ...

Page 71: ...led Legacy adapter must be deployed Oracle Studio with the necessary machines loaded See Configuring Oracle Connect This chapter provides examples of the configuration steps that are used when using BPEL to work with the Oracle IMS DB adapters You should be familiar with the following before working with these examples How to create J2CA connections See Chapter 3 Integrating OracleAS Adapter for I...

Page 72: ...e the connection for the J2CA IMS DB resource adapter You do this by creating a connection factory See Configuring the J2CA 1 5 IMS DB Adapter for information on how to do this Write a schema file First create an interaction called findDoctor using Oracle Studio See Configuring an OracleAS Adapter for IMS DB for Outbound Interactions for a description on how to create the findDoctor interaction Wr...

Page 73: ...e Design a BPEL Outbound Process to Read the String Create a Partner Link to the Database Adapter Edit the Invoke_1 Activity Edit the Assign_1 Activity Create a BPEL Project for a BPEL Outbound Process Do the following to create a BPEL project for outbound 1 In JDeveloper from the View menu select Application Navigator 2 In the Application Navigator right click the application you are working with...

Page 74: ...gs section of the Create Partner Link dialog box as shown in the figure above 3 Enter the following information in the Adapter Configuration wizard a Step 1 Adapter Type Select Database Adapter b Step 2 Service Name type findDoctor c Step 3 Service Connection In this step select the database you want to work with Click New to open the Create Database Connection wizard Step 1 Select the connection ...

Page 75: ...the list g Step 7 Messages Schema File URL Enter findDoctor xsd Schema Element Enter FindDoctorData 4 Click Finish Design a BPEL Outbound Process to Read the String In this step you design the BPEL process Do the following to design the BPEL outbound process 1 From the Component Palette Process Activities pane drag a Receive Assign and Invoke activity into the editor for the process you created in...

Page 76: ...ox is selected Click OK to close the dialog box and accept the information Create a Partner Link to the Database Adapter In this step create a partner link to the Database adapter you defined when you created the IMD DB configuration in Oracle Studio Do the following to create a partner link 1 Drag a PartnerLink into a service lane of the visual editor The Create Partner Link dialog box is display...

Page 77: ...ivity that you added to the Visual Editor so that it will invoke the FINDDOCTOR service Do the following to edit the Invoke_1 activity 1 Double click the Invoke_1 activity to edit it The Invoke dialog box is displayed Figure 5 6 Invoke Dialog Box 2 In the Invoke dialog box make sure that the Partner Role Web Service Interface section has the following values Partner Link FINDDOCTOR Operation FINDD...

Page 78: ...dit it The Assign dialog box is displayed Figure 5 7 Assign Dialog Box 2 Click the Create list and select Copy Operation The Create Copy Operation dialog box is displayed Figure 5 8 Create Copy 3 On the From side expand Variables then expand Read_1_SelectDoctor_ InputVariable then expand nsx findDoctor and select Record1 4 On the To side expand Variables then expand Read_1_SelectDoctor_ InputVaria...

Page 79: ...d call it FindDoctor xml as shown in the following example xml version 1 0 encoding UTF 8 CU FindDoctorData xmlns CU http xmlns oracle com Esb FindDoctorData xmlns xsi http www w3 org 2001 XMLSchema instance Record1 IMSDB Record1 CU FindDoctorData 2 Save the file to the C temp folder that was defined for the first adapter The file is deleted after the SOA server reads the file and complete the pro...

Page 80: ...Deploy a BPEL Outbound Process 5 10 Oracle Application Server Adapters for IMS DB User s Guide ...

Page 81: ...the OracleAS Adapter for IMS DB and create outbound interactions you must create an IMS DB data source import the metadata from IMS DB create a database adapter then create interactions that will be used to access the data Requirements The following is required to carry out the tasks described in this chapter Computer with Windows operating system Mainframe computer with z OS operating system Orac...

Page 82: ... be the host name and the port number User name If the computer you are accessing needs an administrator password If so enter the name o f the computer s administrator Password If necessary enter the computer administrator s password Connect via NAT with fixed IP address Select this if the machine uses the NAT Network Address Translation firewall protocol with a fixed configuration mapping each ex...

Page 83: ... see Importing Metadata for the IMS DB Data Source In this example you should import the metadata for the Doctor and Patient coluumns of the Hospital database This database is supplied as an example with Oracle Connect and should be installed when you install Oracle Connect on your Mainframe computer You will need the following information for the metadata import In the Get Input Files step add th...

Page 84: ...eeking To create a database adapter do the following 1 Expand the computer you just added and then expand the NAV binding 2 Right click the Adapters folder and then select New adapter 3 Enter the following information for your adapter then click Finish Name findDoctor Type Database Select Create event queue for the adapter For a detailed explanation on how to set up a database adapter see Setting ...

Page 85: ...k Interactions and select New 4 Enter the following information for in the wizard then click Finish Name findDoctor Type Database Select Create event queue for the adapter In Creation Mode select Manual and Database query Interaction Name findDoctor Select Create New Query Create a Select statement find a doctor in the database For detailed information on how to create an interaction see Generatin...

Page 86: ...Create the findDoctor and findPatient Interactions 6 6 Oracle Application Server Adapters for IMS DB User s Guide ...

Page 87: ...eAS Adapter for IMS DB is performed using Oracle Studio It is used to monitor the daemon and server activity and control what happens to the daemon and server processes This section contains the following topics Starting the Daemon Shutting Down the Daemon Monitoring the Daemon During Run Time Daemon Logs Starting the Daemon The daemon is started when OracleAS Adapter for IMS DB is installed In ca...

Page 88: ...ick the computer defined in Setting Up the IBM z OS Platform in Oracle Studio on page 2 14 and select Open Runtime Perspective You can manage the daemon by expanding the relevant node daemon workspace or server process as described in the following sections Daemon Computer Options Right click the daemon to display the options available for it including the ability to display the daemon log The fol...

Page 89: ...e daemon displayed in the Runtime Explorer Remove Removes the daemon from the Runtime Explorer Refresh Refreshes the display Table 7 2 Workspace Options Option Description Edit Workspace Configuration Opens the daemon editor to enable you to reconfigure the workspace See Also Appendix C Advanced Tuning of the Daemon for details about the configuration settings Status Checks the status of the works...

Page 90: ... Oracle Studio provides a monitor for these logs as shown in the following figure Disable Disables the selected workspace Refresh Refreshes the display Table 7 3 Server Options Option Description Status Checks the status of the server The information about the server includes the server mode and the number of active client sessions for the server View Log Displays the server log For details see Da...

Page 91: ...ogging by clicking Properties The following levels of logging are available none The log displays who has connected and disconnected from the server process error The log displays who has connected and disconnected from the server process and any errors that have been generated debug The log displays who has connected and disconnected from the server process any errors that have been generated and...

Page 92: ... Idle Not Processing a Client Request Processing a Client Request Explicit Disconnect client explicitly closes connection or client program terminates The server is immediately notified of the disconnect and either becomes available for use by another client or terminates if it is not reusable The server does not know that the client has disconnected and continues processing When processing comple...

Page 93: ...stem command C00C Daemon request requires a server login Cause A non Oracle Connect server or program was trying to use a daemon service reserved for Oracle Connect servers Action Check the processes and kill the relevant process with a system command C00D Daemon request requires a client login Cause The requested daemon requires a valid client login which was not supplied Action Reissue the comma...

Page 94: ...ount that is allowed to check for system usernames and passwords C014 Client connection limit reached try later Cause The maximum number of server processes for the workspace has been reached and none of the active servers could accept the client connection Action Increase the value of the Number of sub tasks in the WS Server section of the daemon configuration Action Try running the command later...

Page 95: ...acle Support Services C01B Unexpected error in s Cause Internal error Action Contact Oracle Support Services C01C Cannot update configuration without _APPLICATIONS lock Cause Internal error Action Contact Oracle Support Services C01D Need to lock the application first Cause Internal error Action Contact Oracle Support Services C01F Cannot set configuration of a deleted application Cause Internal e...

Page 96: ...emon Action Try to connect again Action Increase the Connect timeout value for the server workspace in the WS Info section of the daemon configuration Action Check that the startup script for the workspace launches the correct version of Oracle Connect Action Increase the value of the Set maximum number of servers and Maximum parameter for the Clients per server limit in the WS Server section of t...

Page 97: ...Cause Internal error Action Contact Oracle Support Services C02A Server thread failed to start Cause Internal error Action Contact Oracle Support Services C02B Stopping the s server no client Cause A server that was started by the Oracle Connect daemon to service a client did not get a client connection request within one minute The server terminates Action In most cases the client was terminated ...

Page 98: ...he system C036 Failed to register RPC procedure module s Cause Internal error Action Contact Oracle Support Services C037 Failed to register an invalid RPC procedure number x Cause Internal error Action Contact Oracle Support Services C038 Cannot reregister RPC procedure number x Cause Internal error Action Contact Oracle Support Services C042 Remote call to s failed s Cause Remote call to API fai...

Page 99: ... or server failed or an established session with a server has failed Action Check the remote computer definition in the oc4j ra xml file Action Check that the daemon is up on the IBM z OS platform Use the Status option in the Runtime Manager perspective Action In case of a network problem check the network connection by trying to ping the host computer or run ftp or telnet to or from it C067 Unexp...

Page 100: ...ive transaction is aborted as well Action Oracle Connect automatically tries to reestablish a connection with a server upon the next SQL command issued against the server Once the network or computer failure is corrected the connection to the daemon is reestablished automatically C070 Server failed to send reply to the client Cause Server terminated unexpectedly Action Unless the client was intent...

Page 101: ...rce shortage J0006 Operation on already closed connection was requested Cause A request using a connection that was closed was attempted Action Reopen the connection and try again J0028 Internal Error Unknown XML tag s Cause Internal error Action Contact Oracle Support Services J0030 Internal Error Method s needs to be overwritten Cause Internal error Action Contact Oracle Support Services J0031 I...

Page 102: ...ices J0039 Internal Error ACP root is not found in the XML Cause Internal error Action Contact Oracle Support Services J0040 Internal Error Input record is required for interaction s execution Cause Internal error Action Contact Oracle Support Services J0048 Invalid metadata type s is passed to s function Cause A request for metadata was not fulfilled Action Check the validity of the request J0050...

Page 103: ... of type Object Cause In a PUT operation the value must be mapped record array Action Change the value used in the operation to a valid value J0078 In nonpersistent connection and the nonkeep alive encryption is not supported ignored Cause Encryption is not supported for nonpersistent connections Action There is no action to take This warning can be ignored J0079 Invalid argument passed to s Argum...

Page 104: ...Resolving Specific Errors 7 18 Oracle Application Server Adapters for IMS DB User s Guide ...

Page 105: ...re a workspace to use a pool of server processes so that a server process is always available for a client request Use Oracle Studio to maintain daemon and daemon workspace parameters to control the allocation of server processes and their management in a pool You can also have a number of daemon workspace configurations Thus you can create individual workspaces for use with different adapters Add...

Page 106: ...you want ot edit the workspace 3 Expand the Daemons folder The daemon available on this computer are listed 4 Expand the IRPCD daemon The daemon workspaces are listed 5 Right click the workspace you are editing and select Open 6 Click the tab that contains the information you want to edit For full details of the tabs and the fields in these tabs see Workspaces 7 After editing the workspace click S...

Page 107: ...he maximum number of concurrent clients a server process for the current workspace accepts reusable This is an extension of the single client mode Once the client processing finishes the server process does not die and can be used by another client reducing startup times and application startup overhead This mode does not have the high overhead of single client mode because the servers are already...

Page 108: ... Server Mode tab Port Range Select the range for specific firewall ports through which you access the workspace Determines the range of ports available for this workspace when starting server processes Use this option when you want to control the port number so that Oracle Connect can be accessed through a firewall Enter the port range in the following fields From Enter the highest numbered port i...

Page 109: ... this if you want the servers for the workspace to remain active even after the daemon has been shut down If selected it is the responsibility of the system operator or manager to ensure that the servers are eventually killed This must be done at the system level Number of prestarted servers in pool The number of server processes that are prestarted for this workspace when the daemon starts up The...

Page 110: ...ronment settings in Oracle Studio perform the following steps 1 From the Start menu select Programs Oracle and then select Studio 2 In the Design perspective Configuration view expand the Machine folder then expand the machine where you want to configure the binding 3 Expand the Bindings folder The binding available on this computer are listed 4 Right click NAV and select Open 5 In the Environment...

Page 111: ...anging the default setting can degrade performance Query warnings This parameter is not applicable for use with OracleAS Adapter for IMS DB Add timestamp to traced events Select this to add a timestamp on each event row in the log Query Processor trace This parameter is not applicable for use with OracleAS Adapter for IMS DB Binary XML Log Level Select the binary XML log level from the list The fo...

Page 112: ... the Sliding Base Year policy is used Two policies are provided Fixed Base Year year2000Policy is set to a value greater than or equal to 1900 In this case the value of year2000Policy is the first four digit year after 1900 that can be represented by a two digit year For example if year2000Policy is set to 1905 the years 2000 2004 will be represented by 00 04 All other two digits will map to 19xx ...

Page 113: ...at define transaction support Table 8 4 Language Settings Parameters Parameter Description Language Identifies the application language A default codepage is selected based om the value specified for this parameter See also Appendix E Globalization Settings Code Page For use with globalization support to identify the codepage for the workspace See also Appendix E Globalization Settings NLS String ...

Page 114: ...er the time to wait for a transaction to complete before an error is returned This parameter is also used when performing a RECOVERY and it then indicates the number of minutes to wait before a forced activity can be performed since the last transaction activity Conversions Select one No conversion Select this if you want all transactions to remain as sent This is selected by default Convert all t...

Page 115: ... in Oracle Studio in the same way you set up the source platform as described in Setting Up the IBM z OS Platform in Oracle Studio on page 2 14 7 In the Configuration Explorer right click the target computer and select Import XML definitions 8 Import the XML file to the target platform Security Considerations Oracle Connect works within the confines of the platform security system For example on a...

Page 116: ...uding controlling the daemon for the access Setting Design Time Security Setting design time security is described in the following sections Securing access to Oracle Studio is described in Setting Password Access to Oracle Studio on page 2 15 Securing rights to configure a computer in Oracle Studio is described in Specifying Users with Administrative Rights on page 2 16 Securing access to user pr...

Page 117: ...ctions select Convert all to distributed in the Transaction section of the binding environemtal properties See Transactions in the Configuring a Binding Environment section To use the global transaction capability to access data on the or z OS computer define every library in the ATTSRVR JCL as an APF authorized library To define a DSN as APF authorized in the SDSF screen enter the following comma...

Page 118: ...can participate in a distributed transaction as the only one phase commit resource if the Transaction log file environment property includes the keyword NORRS See Transactions in the Configuring a Binding Environment section Note If a log file is not specified then the format for the logFile parameter when RRS is not running is NORRS ...

Page 119: ...o maintain the metadata for the IMS DB data source 1 From the Start menu select Programs Oracle and then select Studio 2 Expand the Machines folder then expand the machine with the metada you are working with 3 Expand the Bindings folder 4 Expand the NAV binding 5 Expand the Data sources folder to display the data sources 6 Right click the IMS DB data source and select Show Metada View to display ...

Page 120: ...neral tab The General tab comprises fields as listed in the following table Table A 1 General Tab Components Field Description Description An optional description of the table Table Properties Data file location The name of the file that contains the table You must enter the full path and include the file extension for the file For example D COBOL orders cob You can click Browse and browse to find...

Page 121: ... hash symbol is used to specify a pseudo column For example SELECT FROM colleges WHERE 6 Record format Specifies how the record represented by the table is formatted The options that are displayed depend on the record The IMS DB records have a fixed format Maximum record length The maximum allowable size of a record in bytes DB Command IMS DB specific commands are displayed in the DB Command secti...

Page 122: ...Selecting this field displays a drop down box listing the possible data types Size The size of the column Scale The information entered in this field depends on the data type For decimal data types this is the number of digits to the right of the decimal place This number must not be greater than the number of digits The default value is 0 For scaled data types this is the total number of digits T...

Page 123: ...size of the proceeding column Select the check box in this column to override this calculation and specify a fixed offset at design time This can happen if there is a part of the buffer that you want to skip By selecting the check box or by editing the offset value you pin the offset for that column The indicated value is used at runtime for the column instead of a calculated value Note that the o...

Page 124: ...ld you must explicitly ask for it in a query for example SELECT NATION_ ID SYSKEY FROM NATION where SYSKEY is a field defined with Explicit Select You cannot use an asterisk in a query where you want to retrieve a field defined with the Explicit Select value Hidden The current field is hidden from users The field is not displayed when a DESCRIBE statement is executed on the table Non Selectable Wh...

Page 125: ...first section lets you define the index keys for the columns in the table The bottom of the tab lists the properties for each of the columns at the top The following sections describe the Indexes tab Table Information Properties Table Information The following table describes the fields for the top part of the tab which defines the indexes used for the table Note The Indexes tab contains informati...

Page 126: ...his properties displayed at the bottom of the tab describe the index or segment The properties available depend on the data source Statistics Tab Use the Statistics tab to update statistics for a table The Statistics tab is shown in the following figure Table A 5 Indexes Tab Components Field Description Name The names of existing indexes for the current table Order The ordering of the rows retriev...

Page 127: ...mate number of rows in the table If the value is 1 then the number of rows in the table is unknown a value was not supplied and the update statistics utility was not run to update the value A value of 0 indicates that this table is empty No of blocks The approximate number of blocks in the table Note If neither the number of rows nor the number of blocks is specified for a table queries over the t...

Page 128: ...ber of distinct values for the column If the value is 1 then the number of distinct values for the column is unknown a value was not supplied and the update statistics utility was not run to update the value A value of 0 indicates that there are no distinct values for the column Table A 9 Indexes group Components Field Description Indexes and segments The indexes and segments in the table Cardinal...

Page 129: ...ws in the table Specify the number in the text box This number is used to shorten the time to produce the statistics assuming that the value specified here is the correct value or close to the correct value Exact The exact statistical information returned Note that this can be a lengthy task and can lead to disk space problems with large tables Table A 11 Resolution group Components Field Descript...

Page 130: ... the data source is not configured to include the row number column false Select false to not include a column that specifies the row number in the virtual or sequential view for this table even if the data source is configured to include the row number column default Select default to use the default data source behavior for this parameter Inherit all parent columns Select one of the following tr...

Page 131: ...ect to the adapter You make these changes in the Design perspective Metadata view Adapter Metadata Interactions Enter details of an interaction The interaction Advanced tab is displayed for some adapters only such as the Database adapter and includes more details about the interaction Adapter Metadata Schema Records The input and output record structure for a record in the adapter definition Adapt...

Page 132: ...he available mechanisms are kerbv5 none basic password Max request size Specifies the maximum size in bytes for an XML request or reply Larger messages are rejected with an error Max active connections Specifies the maximum number of simultaneous connections for an adapter per process Max idle timeout Specifies the maximum time in seconds that an active connection can stay idle After that time the...

Page 133: ...2 Expand the adapter with the interaction that you want to edit 3 Expand the Adapter folder 4 Right click the adapter you want to edit and select Open The Adapter Metadata Interactions editor is displayed The Adapter Metadata Interactions editor is shown in the following figure Figure A 8 Adapter Metadata Interactions The Adapter Metadata Interaction properties are listed in the following table Ta...

Page 134: ... mode The following interaction modes are available sync send receive The interaction sends a request and expects to receive a response sync send The interaction sends a request and does not expect to receive a response sync receive The interaction expects to receive a response Input record Identifies an input record Output record Identifies an output record for the results of an interaction Inter...

Page 135: ... a valid SQL statement at the bottom of the screen The Interaction Properties section lets you select any of the following Pass Through Select this to pass a query directly to the IMS DB data Reuse compiled query Select this to save query objects created in the previous execution to the cache This allows the objects to be reused Fail on no rows returned Select this if you want to the system to ret...

Page 136: ...r a default value for the parameter which is used if the parameter attribute is missing in the input record Adapter Metadata Schema Records The Adapter Metadata Schema Records editor defines the general details of the input and output record structures for the interaction The following describes how to open the Adapter Metadata Schema Records editor 1 In Oracle Studio Design perspective Metadata v...

Page 137: ...s list Defines the single data item within a record This section has a table with the following three columns Name The name of the field Type The data type of the field See the Valid Data Types table for a list of the valid data types Length The size of the field including a null terminator when the data type supports null termination such as the string data type Specifications Defines specific fi...

Page 138: ... Design perspective Metadata view expand the Adapters folder 2 Right click the adapter that you want to edit and select Open as XML The adapter XML editor is displayed in the Design view The adapter XML editor is shown in the following figure Figure A 11 Adapter Metadata XML Editor For information on how to edit the properties in the XML editor Design view see Numeric p s Short String Time Timesta...

Page 139: ... The mapping of data types between OracleAS Adapters for IMS DB and Oracle Application Server is performed internally by Oracle Connect Table 8 7 Data Type Mapping COBOL and Oracle Connect Back end Adapter COBOL Data Type Oracle Connect Data Type BINARY with fractional data string BINARY without fractional data int COMP with fractional data string COMP without fractional data int COMP 2 double COM...

Page 140: ...MS DB User s Guide NATIVE 4 int NATIVE 8 string PACKED DECIMAL string POINTER int SIGN IS TRAILING string SIGN IS TRAILING SEPARATE CHARACTER string Table 8 7 Cont Data Type Mapping COBOL and Oracle Connect Back end Adapter COBOL Data Type Oracle Connect Data Type ...

Page 141: ...ck the computer and select Open Runtime Perspective 4 Right click the required daemon in the Runtime Explorer and select Edit Daemon Configuration The Control tab for the damon is displayed in the editor 5 After making changes to the daemon right click the daemon and select Reload Configuration The Control tab is shown in the following figure Note You can also change daemon settings using the Conf...

Page 142: ...for any reason any error that causes the daemon process to terminate such as network process lost or the CPU running the daemon crashes and the backup daemon is defined on another CPU All available and unconnected servers are terminated and any connected servers are marked and terminated on release Also the backup starts a backup for itself The backup appends a new log file to the log of the origi...

Page 143: ...nificant amount of time If a short call takes more than the specified time to complete then the connection is stopped The default value for this parameter is 60 seconds Values of less than 60 seconds are considered to be 60 seconds Specifying the timeout in a workspace overrides the value set in this field for that workspace Connect timeout The time the client waits for a daemon server to start If...

Page 144: ...ght click the daemon and select Edit Daemon Changes made to the daemon configuration are only implemented after the configuration is reloaded using the Reload Configuration option in the Runtime Manager perspective Table 8 9 Daemon Logging Tab Components Field Description Logging options Daemon log file location Specifies the daemon produces its log data The full path must be specified Server log ...

Page 145: ...d processes Extended RPC trace Generates a verbose message in the server log file for each low level RPC function called This is useful for troubleshooting the server System trace Generates system specific tracing of various operations Timing Generates a timestamp for every entry to the server log file Sockets Generates a message in the server log file for each socket operation Trace information S...

Page 146: ...the daemon and select Reload Configuration 7 Right click the daemon and select Recycle servers Any servers in the connection pool are closed and new servers start with the new configuration The Daemon Security tab is shown in the following figure Figure 8 5 The Daemon Security tab The Daemon Security tab comprises fields as listed in the following table Note You can also change daemon settings usi...

Page 147: ... daemon and change the settings Selected users only Identifies the names of users accounts and groups that can be administrators 1 If a user is not specified the account from which the daemon was started is considered the administrator Note that the daemon does not require the user to log in to the account on the system but to log in to the daemon using the account name and password 1 The name is ...

Page 148: ...rs in the connection pool are closed and new servers start with the new configuration The General tab is shown in the following figure Figure 8 6 The General tab The General tab comprises fields as listed in the following table Note You can also change daemon settings using the Configuration Explorer by selecting a computer and scrolling the list to the required daemon Right click the daemon and s...

Page 149: ...ecifying the timeout here overrides the default setting specified in the Control section See Also Control for details about the Daemon Control section Client idle timeout The maximum amount of time a workspace client can be idle before the connection with the server is closed Connect timeout The time the client waits for a workspace server to start If the workspace server does not start within thi...

Page 150: ...t operation This is useful for troubleshooting client server communication providing a detailed trace of every client server communication Extended RPC trace Select this to generate a verbose message in the server log file for each low level RPC function called This is useful for troubleshooting the server System trace Select this to generate operating system specific tracing Timing Select this to...

Page 151: ...tive 4 Expand the Daemons node to display the workspaces in the Runtime Explorer 5 Right click the workspace and select Edit Workspace Configuration 6 Click the Server Mode tab 7 After making changes to the workspace right click the daemon and select Reload Configuration 8 Right click the daemon and select Recycle Servers Any servers in the connection pool are closed and new servers start with the...

Page 152: ...Workspaces C 12 Oracle Application Server Adapters for IMS DB User s Guide Figure 8 7 The Server Mode tab The Server Mode tab has the following fields ...

Page 153: ...cable for use with OracleAS Adapter for IMS DB reusable An extension of single client mode Once the client processing finishes the server process does not die and can be used by another client reducing startup times and application startup overhead This mode does not have the high overhead of single client mode because the servers are already initialized However this server mode can use a lot of s...

Page 154: ...nsibility of the system operator or manager to ensure that the servers are eventually killed This must be done at the system level Set maximum number of servers The maximum number of available server processes Once this number is reached no new nonactive server processes are created for the particular workspace For example if a number of server processes are released at the same time so that there...

Page 155: ...tions with online transaction processing can be assigned a higher priority than a workspace that requires only query processing The lower the number the higher the priority For example workspaces with a priority of 1 are given a higher priority than workspaces with a priority of 2 Note This is unavailable if Use default server priority is selected Use default server priority Sets the priority to 0...

Page 156: ...ses to the value specified in the Initial number of servers field If this field is set to a value higher than the Initial number of servers field the daemon uses the value specified in the Initial number of servers field The default for this field is 0 Prestarted server pool limit The maximum number of available server processes Once this number is reached no new nonactive server processes are cre...

Page 157: ...Figure 8 8 The Security Tab The Security tab has the following fields Notes You can also change daemon settings using the Configuration Explorer by selecting a computer and scrolling the list to the required daemon Right click the daemon and select Edit Daemon Changes made to the daemon configuration are not implemented They are only implemented after the configuration is reloaded using the Reload...

Page 158: ... Workspace users Indicate which users have permission to use the workspace Select one of the following All users Any user who has logged on to the daemon may use the workspace Selected users only Select this to allow only users or accounts with specific permission to use the workspace When this is selected add the names of users or accounts and groups that can be use the workspace in the field bel...

Page 159: ...contains the following sections Supported SQL Statements Supported Operators Supported Functions SQL Enhancements Supported SQL Statements OracleAS Adapter for IMS DB supports SELECT DELETE INSERT and UPDATE statements when specified in interactions Supported Operators OracleAS Adapter for IMS DB enables the use of the following operators in SQL statements Arithmetic Operators Comparison Operators...

Page 160: ...nce of str1 in str2 Length Length Length str Returns the number of bytes of str Lower Lower Lower str Returns str in lowercase Lpad Lpad Lpad str n Returns str with n leading blanks Ltrim Ltrim Ltrim str Returns str with leading blanks removed Rpad Rpad Rpad str n Returns str with n trailing blanks Rtrim Rtrim Rtrim str Returns str with trailing blanks removed Substr Substr Substr str n m Returns ...

Page 161: ...acle Function Oracle Connect Function Usage Comment Abs Abs Abs n Returns the absolute value of n Ceil Ceil Ceil n Returns n rounded up to the closest integer Cos Cos Cos n Returns the cosine value of n Exp Exp Exp n Returns the exponential value of n Floor Floor Floor n Returns n rounded down to the closest integer Ln Ln Ln n Returns the natural log value of n Log Log Log n Returns the log value ...

Page 162: ...ild1 child2 alias Flattening Hierarchical Data Using SQL You can produce a flattened view of hierarchical data by embedding a SELECT statement inside the list of columns to be retrieved by another SELECT statement You use parentheses to delimit the nesting The nested SELECT statement can reference a child rowset using the parent child syntax only in its FROM clause Using an Alias To list the hiera...

Page 163: ...upport Defining the Language and Codepage The language and codepage parameters are accessed from the computer where Oracle Studio is installed Perform the following steps to define the required language and codepage 1 From the Start menu select Programs Oracle and then select Studio 2 In the Design perspective Configuration view expand the Machines folder 3 Expand the machine for which you want to...

Page 164: ...e determined by the code page that is selected If you have additional NLS strings available you can manually enter them in this field The codepage is used by a field with a data type defined as nlsString This parameter is used for a field with a codepage that is different than the machine s codepage This property includes values for the name of the codepage and whether the character set reads from...

Page 165: ...an GER Windows 125 2 ISO 8859 15 IBM1141 IBM273 IBM037 IBM500 IBM1140 IBM1148 IBM1047 ISO 8859 1 ASCII based Portuguese POR Windows 125 2 ISO 8859 15 IBM1140 IBM037 IBM500 IBM1148 IBM1047 ISO 8859 1 ASCII based Italian ITL Windows 125 2 ISO 8859 15 IBM1144 IBM280 IBM037 IBM500 IBM1140 IBM1148 IBM1047 ISO 8859 1 ASCII based Greek GRK Windows 125 3 ISO 8859 7 IBM875 Russian1 RUS Windows 125 1 ISO 88...

Page 166: ...7 Korean KOR MS949 EUC KR IBM933 MS949 1 Russian users who use ANSI 1251 Cyrillic as their Windows codepage must edit the RUS TXT file and compile it to RUS CP using the NAV_UTIL CODEPAGE 2 To work with solutions in Oracle Studio when using Turkish add the nl en switch to the Target path in the Oracle Studio shortcut properties For example C Program Files Oracle Studio1 studio exe nl en Table 8 14...

Page 167: ...saction extended logging 8 8 disable 2PC 8 10 disk space requirements IBMmainframe 2 2 E environment parameters ACX trace 8 7 add timestamp to traced events 8 7 cache buffer size 8 8 code page 8 9 COM maximum XML size 8 10 COM maximum XML size in memory 8 10 COM XML transport buffer 8 10 commit on destroy 8 10 debug 8 7 disable 2PC 8 10 GDB trace 8 7 general trace 8 7 language 8 9 log file 8 7 mis...

Page 168: ...n options C 3 log file parameter 8 7 logging daemon configurations C 3 optimizer strategy 8 7 8 8 M memory requirements IBM mainframe 2 2 metadata atomic data types B 1 miscellaneous parameters environment 8 8 N nav utility editor parameter 8 8 nav utility editor text editor 8 8 NLS string parameter 8 9 O odbc environment parameters 8 9 oledb environment parameters 8 9 operating system requirement...

Page 169: ...actions environment parameters 8 9 transactions parameters commit on destroy 8 10 disable 2PC 8 10 recovery delay 8 10 time limit 8 10 transaction conversions parameters 8 10 transaction extended logging 8 9 transaction log file 8 10 user commit confirm table 8 10 tuning environment parameters 8 10 U user commit confirm table 8 10 W Workspace server mode C 13 X XML environment parameters 8 10 XML ...

Page 170: ...Index iv ...

Reviews:

No comments

Brands by name

Popular brands

Load more brands