IBM Software Group IBM Informix and SOA

® IBM Software Group IBM Informix and SOA Integration How to enable your Informix based application for an On. Demand business Alexander Koerner, Channel Technical Sales – Informix / SOA Alexander. Koerner@de. ibm. com Certified Senior IT-Specialist, IBM Germany (Munich) © IBM Corporation

IBM Software Group Agenda § Service-oriented Architectures (SOA) § Informix and SOA - Overview § Informix and SOA - Details § Additional Information

IBM Software Group What is SOA? § Service-oriented architecture (SOA) helps hide the IT complexity inherent in even seemingly simple interactions § One key technical foundation of SOA are Web services § SOA is an architectural style that allows Web services applications to interoperate dynamically with one another § SOA isn’t really new, but the availability of more and improved Web services applications is making SOA much more powerful and easier to implement § SOA makes it less expensive for companies to link their business processes to those of their suppliers, vendors and other business partners

IBM Software Group SOA Example: Internet Bookstore § Customer point of view: 4 A book is ordered online and a few days later delivered to your house § What happens behind the scenes: 4 Your identity must be authenticated 4 Your charge card validated 4 Your order acknowledged by e-mail 4 The order sent to a distributor 4 The book located and boxed for shipping 4 E-mail notification that your order has shipped 4 Hand-off to the shipper (at which point the shipper’s supply chain management system tracks the movement of the purchase) 4 And finally delivery and acknowledgement of receipt § How SOA comes into play 4 Each of the applications above performs a service that is orchestrated increasingly by SOA

IBM Software Group What are Web services? § ‘Remote Function Calls’ via Inter-/Intranet § Based on XML-formatted messages § Utilize internet protocols like HTTP (important if proxys/firewalls are involved) § Base technology for complex applications § Some reasons why Web services are successful: 4 Loosely coupled systems 4 Independent from the used programming language (e. g. Java, 4 GL, ESQL/C, Cobol, C++, etc. ) 4 Easy application integration due to open standards

IBM Software Group Why SOA now? § To keep pace with global competition: 4 “We are taking apart each task and sending it … to whomever can do it best, … and then we are reassembling all the pieces” from Thomas Friedman’s ‘The World is Flat’ § The standards and technology are finally in place, with broad industry support § Availability of best practices for effective governance § The necessary software to get started is available today

IBM Software Group Information as a Service Moving From a Project-Based to a Flexible Architecture (SOA) Tools & Applications Dashboards In-line, Real-time Insightful Relationships Standards based: e. g. , XQuery, JSR 170, JDBC, Web Services. . . Metadata Management Data & Content Business Context Information as a Service Real Time : e. g. , On Line Help, Synchronized Master Data… Extracted: e. g. Basel II, Business Optimization… Heterogeneous Applications & Information DB 2 abc… IBM Content Manager Informix IDS and more…

IBM Software Group IBM Information Management Software Delivering Value Beyond Traditional Repositories Information Delivered on Demand Based on Services Oriented Architecture § Data Services 4 Informix IDS, DB 2, IMS, Cloudscape, U 2 § Content Services 4 Content Management Services 4 Content Integration Services § Information Integration Services 4 4 Federation Services Movement Services Transformation Services Quality Services… § Information Accelerators 4 4 4 Master Data Management Entity Analytics Information Warehousing Customizable Dashboards Industry Data Models

IBM Software Group IBM Information Management Software Delivering Value Beyond Traditional Repositories Information Delivered on Demand § Based on Services Oriented Architecture § re ha ents S in Cli Data Services #1 00+ 0 4 Informix IDS, DB 2, , IMS, Cloudscape, U 2 50 4 Content Services 4 Content Management Services re ha 4 Content Integration Servicesents S § n Cli 1 i Services # Information Integration 0+ 0 4 Federation Services 3, 0 1 4 Movement Services 4 Transformation Services re 4 Quality Services… ha § No Other Vendor Delivers The Breadth and The Depth of Capabilities ts n S lien i Information Accelerators C #1 0+ 0 4 Master Data Management 5, 0 4 Entity Analytics 4 Information Warehousing ce p 4 Customizable Dashboards a e S ts 4 Industry Data Models n Th ie ing + Cl ad Le 1, 000

IBM Software Group Agenda § Service-oriented Architectures (SOA) § Informix and SOA - Overview 4 Case Study 1: IDS as a Web service provider 4 Case Study 2: IDS as a Web service consumer 4 Case Study 3: Informix 4 GL and Web services integration § Informix and SOA – Details § Additional Information

IBM Software Group Case Study 1: Supply Chain Integration § Problem: An IDS 7 based application (manufacturer order entry system) should be integrated into the supply chain management of a world wide operating retail customer. § Solution: IDS 10 as a Web service provider 4 In-place update of IDS 7 to IDS 10 4 Utilizing WORF (Web services Object Runtime Framework) with IDS 10 § Result: WORF provides Web service access to an IDS 10 Stored Procedure which is the interface to the manufacturer’s order entry system.

IBM Software Group Informix IDS and SOA: Web services integration § IDS as a Web service provider 4 IBM WORF (Web services Object Runtime Facilty) support for IDS § Easy IDS Web service definition based on SQL Statements (SELECTs, INSERTs, UPDATEs and Stored Procedure Calls) § Requires Web. Sphere Application Server or any other J 2 EE server as a runtime environment § Integrated easy to use test environment 4 IBM EGL (Enterprise Generation Language) allows easy Web service providing § Easy to learn, Java based 4 GL-like language 4 Strong. NET support for IDS and Web services integration for non. Java environments 4 Any Java object (Servlet, Bean etc. ) could be used as an IDS Web service provider

IBM Software Group Agenda § Service-oriented Architectures (SOA) § Informix and SOA - Overview 4 Case Study 1: IDS as a Web service provider 4 Case Study 2: IDS as a Web service consumer 4 Case Study 3: Informix 4 GL and Web services integration § Informix and SOA – Details § Additional Information

IBM Software Group Case Study 2: Web service access from a Legacy App § Problem: An Informix ESQL/Cobol application should be enhanced to be able to access a credit card verification (Web-) service. § Solution: IBM IDS 10 as a Web service consumer 4 JFoundation, Apache AXIS Framework § Result: An IDS 10 Java Stored Procedure (User Defined Routine) which accesses the remote Web service. Callable via SQL statements. Only minor changes in the ESQL/Cobol application are required since SQL is being used to interact with the Web service.

IBM Software Group Informix IDS and SOA: Web services integration § IDS as a Web service consumer 4 IDS leading extensible architecture provides the perfect foundation for web service access § IDS JFoundation in combination with the Axis framework allows transparent access to web services from the Informix SQL layer § IDS Data. Blade API for any kind of custom Web service access (e. g. via C routines in the server) IDS Web services consumer example: Google Search

IBM Software Group Agenda § Service-oriented Architectures (SOA) § Informix and SOA - Overview 4 Case Study 1: IDS as a Web service provider 4 Case Study 2: IDS as a Web service consumer 4 Case Study 3: Informix 4 GL and Web services integration § Informix and SOA – Details § Additional Information

IBM Software Group Case Study 3: Provide Web service API for a 4 GL App § Problem: An Informix ISV gets the customer requirement to add an Web service API to an existing Informix 4 GL legacy application. § Solution: Conversion of the 4 GL application to IBM’s Enterprise Generation Language (EGL) and utilization of EGL’s Web services support 4 Rational Application Developer, 4 GL to EGL conversion tool, EGL Web services, IDS 10 § Result: After converting the 4 GL App to EGL, some former 4 GL functions (now in EGL) could be offered as Web services w/o any major changes to the original code. Positive side effect: Due the Java based EGL language, parts of the application could be web-enhanced and also could be deployed to more platforms (e. g. Windows)

IBM Software Group Informix 4 GL and SOA: Web services integration § Informix 4 GL applications 4 Consider a conversion to Enterprise Generation Language (EGL) 4 EGL allows easy Web service provision and Web service access § Web service support is part of the EGL language! 4 Easy to learn, Java based 4 GL-like language 4 EGL supports character based (4 GL-like), batch and web applications (soon also GUI applications) 4 An included conversion utility allows an easy 4 GL to EGL conversion process 4 Additional platform deployment support (e. g. Windows)

IBM Software Group Informix IDS / SOA in a real world: Retarus Gmb. H § Business Problem 4 Deep business and process integration in a heterogeneous B 2 B environment § Solution 4 COMMUnix XC by Retarus Gmb. H (Munich, Germany) is a high performance EDI XML cross converter that can easily manage hundreds of connections between different applications and organisations on a single processor machine. The converter supports the following formats: EDIFACT, XML, SWIFT, DTA, SAP, open. Trans, ODETTE, ANSI X. 12, FORTRAS, Chem e. Standards and Rosetta. Net. Interfaces like X. 400, SMTP, S/FTP, HTTP/S, IBM MQSeries, APIs, RFC and OFTP § Who is using that solution? 4 BAX Global, Sigma-Aldrich, K 2, Avnet, Caparol, DAW (Deutsche Amiphibolin Werke), DZ Bank, Exel, Sony Pictures Home Entertainment, Fiducia and more § Why Informix IDS? 4 IDS its being used due to its low admin overhead, performance and ease of embeddebility

IBM Software Group Summary § SOA and Web services allow an easy integration of heterogeneous applications § IBM‘s Information Management portfolio provides Data services to meet all current and future customer requirements § IBM Informix based applications can be easily integrated into existing SOA environments § Due to its leading extensible architecture, IDS 10 provides the necessary foundation for SOA applications § Informix legacy applications (e. g. 4 GL-based) can be easily transformed into services Investment protection

IBM Software Group Recommended Products for Informix SOA Integration § IBM Informix IDS 10 (any edition) 4 Contains enhancements for better SOA integration § IDS 10 Extensions (Datablades) 4 Web. Sphere MQ Datablade 4 XML Generating UDRs Data. Blade (Informix Developer. Zone) 4 XSLT Data. Blade (Alphaworks) § WORF (Web Services Object Runtime Framework) 4 Part of the Rational Software Development Platform (SDP) 4 and Web. Sphere Application Server § IBM Rational EGL 4 Part of the Rational SDP (e. g. Rational Application Developer) 4 Integrated 4 GL to EGL conversion tool

IBM Software Group Agenda § Service-oriented Architectures (SOA) § Informix and SOA - Overview § Informix and SOA - Details 4 More on Web services 4 Informix SOA Foundation Technologies 4 IDS 10 as a Web service provider 4 IDS 10 as a Web service consumer § Additional Information

IBM Software Group Web services: Characteristics § Web services are self-contained 4 On the client side only a programming language with HTTP and XML support is required 4 The client and server can be implemented in different environments § Web services are self-describing 4 The definition of a Web service message format travels with the message 4 No external metadata repositories or code generation tools are required § Web services are modular 4 Simple Web services can be aggregated to form more complex Web services 4 E. g. by using workflow techniques or by calling lower layer Web services from a Web service implementation.

IBM Software Group Web services: Typical Categories § Business information 4 A business shares information with consumers or other businesses 4 Examples: news streams, weather reports, or stock quotations § Business integration 4 A business provides transactional, "for fee" services to ist customers 4 Examples: bid and auction e-marketplaces, reservation systems, and credit checking § Business process externalization 4 A business differentiates itself from its competition through the creation of a global value chain 4 The business uses Web services to dynamically integrate its processes 4 Example: associations between different companies to combine manufacturing, assembly, wholesale distribution, and retail sales of a particular product.

IBM Software Group Web services: Standards § An extensible Web service description language. . . 4 WSDL § A limited number of protocols being used. . . 4 HTTP GET/POST 4 SOAP § An Web service directory protocol. . . 4 UDDI § A commen, open foundation. . . 4 XML

IBM Software Group Web services: Standards (cont. )

IBM Software Group Web services: A simple SOAP Message <SOAP-ENV: Envelope xmlns: SOAPENV="http: //schemas. xmlsoap. org/soap/envelope/" xmlns: xsd="http: //www. w 3. org/1999/XMLSchema" xmlns: xsi="http: //www. w 3. org/1999/XMLSchema-instance"> <SOAP-ENV: Body> <ns 1: get. Customer encoding. Style="http: //schemas. xmlsoap. org/soap/encoding/ " xmlns: ns 1="urn: place. Order"> <Customer_num xsi: type="xsd: int"> 106 </Customer_num> </ns 1: get. Customer> </SOAP-ENV: Body> </SOAP-ENV: Envelope>

IBM Software Group Web services: Best Practices § Do not use Web services between layers of an application or e. g. within a Java application server. The parsing of every Web service message is very costly and will slow down your application. § Do not use Web services if you’re not exposing external interfaces e. g. for interoperability or if you don’t use an XML document based workflow. § Use Web services on the edge of your application server to expose external APIs or if you need to execute remote calls through a firewall. § If you have a need to execute function calls between Java application servers you might want to consider other protocols, e. g. RMI/IIOP.

IBM Software Group Agenda § Service-oriented Architectures (SOA) § Informix and SOA - Overview § Informix and SOA - Details 4 More on Web services 4 Informix SOA Foundation Technologies 4 IDS 10 as a Web service provider 4 IDS 10 as a Web service consumer § Additional Information

IBM Software Group IDS and SOA, the Foundation: XML and Messaging § Rational Development Tools / Web. Sphere Application Server (XML Input, XML Output) § XML Generation and Transformation with User Defined Routines (XML Output, XML Shredding [planned], XPath Support [planned]) § Web Data. Blade (XML Output) § XSLT Data. Blade (XML Transformation) § JAXP Support in the Informix JDBC driver (XML Validation) § CLOB/TEXT/LVARCHAR data types (XML Storage) § Excalibur Search Data. Blade (Full Text Searches) § Spatial Data. Blade 8. 20 (XML/GML Output) § Web. Sphere MQ Data. Blade (reliable Messaging integration)

IBM Software Group IDS and XML: XML Generation with UDRs § Based on the extensibility features of IDS 10 (Data. Blade Technology) § Basic building block is the genxml() routine § Code can be found on the IBM Informix Developer Zone (Author: Jacques Roy) 4 http: //www 7 b. software. ibm. com/dmdd/zones/informix/library/techarticle/0302 roy 2. html Output of the Statement on the left side: SQL Statement: SELECT genxml("customer", customer) FROM customer; genxml() UDR example <customer> <customer_num>101<//customer_num> <fname>Ludwig </fname> <lname>Pauli </lname> <company>All Sports Supplies </company> <address 1>213 Erstwild Court </address 1> <city>Sunnyvale </city> <state>CA</state> <zipcode>94086</zipcode> <phone>408 -789 -8075 </phone> </customer>

IBM Software Group IDS and XML: Web Data. Blade § Since version 4. 13. x. C 2: XML support builtin! 4 New attributes for the MISQL tag: XMLDOC, XMLROW, XMLVERSION § Focus on XML output (XML input possible in combination with XSLT Data. Blade) § XML templates are stored in IDS 4 Allows usage of IDS server features like ER, HDR or Onbar! § Perfect companion to the XSLT Data. Blade 4 IBM Informix Developer Zone article (Author: Susan Cline) § http: //www 7 b. software. ibm. com/dmdd/zones/informix/library/techarticle/0303 cline. html <? MISQL SQL="select code, desc, ecomm, total from ecommerce; " XMLDOC="TABLE">$1<? /MISQL> Web Data. Blade template example <? xml version="1. 0" ? > <TABLE> <ROW ID="1"> <code>311</code> <desc>Food Products</desc> <ecomm>54837. 00</ecomm> <total>434261. 00</total> </ROW>. . additional output not shown </TABLE>

IBM Software Group IDS and XML: XSLT Data. Blade § IDS 10 Data. Blade, based on libxslt, the Gnome XSLT library § Available via IBM Alphaworks 4 http: //www. alphaworks. ibm. com/tech/xsltblade § Creates several UDRs which take two parameters: an XML document and an XSL stylesheet 4 xslt_udr (returns LVARCHAR) 4 xslt_udr_As. Clob (returns CLOB) 4 xslt_udr_As. Html (returns HTML – Web Data. Blade type) select xslt_udr(s. style_doc, x. xml_doc) FROM style_sheets s, xml_docs x WHERE s. style_title = 'quote. xsl' and x. xml_title = 'ecommerce. xml'; XSLT Data. Blade usage example

IBM Software Group IDS and XML: JAXP Support (Informix JDBC Driver) § JAXP = Java API for XML Parsing § Part of the current Informix Type 4 JDBC driver § The API has two subsets 4 SAX 4 DOM 4 plus a plugability layer (to standardize access to the SAX or DOM layer) § Facilitate storage and retrieval of XML data in IDS database columns 4 Methods used for storage ensure that only valid XML data are stored 4 Methods used for retrieval assist in converting XML data to DOM objects or Input-Source type (can be used for SAX or DOM methods) § The Informix JAXP API supports all IDS 7 and IDS 10 text data types (incl. TEXT, CLOB and LVARCHAR)

IBM Software Group IDS and XML: CLOB/TEXT/LVARCHAR data types § All IDS text data types can be used for XML storage § Typically used for storage of complete documents or fragments 4 Archived copies of generated documents for legal purposes 4 Device independent publishing 4 Temporary storage of XML fragments § Can be easily combined with 4 JAXP API for XML parsing 4 XSLT Data. Blade for transformation 4 Web Data. Blade for publishing 4 Text Search Data. Blades for searching (e. g. Verity Text Search) § CLOB/LVARCHAR allow seamless replication (ER, HDR)

IBM Software Group IDS and XML: Spatial Data. Blade 8. 20 § Since version 8. 20 the Spatial Data. Blade supports the conversion into GML (Geography Markup Languge, based on XML) § Function SE_As. GML(ST_Geometry) (returns ST_Geometry) § Returns only XML fragments, not complete documents! CREATE TABLE mytable (id integer, location ST_Point); INSERT INTO mytable VALUES(1, ST_Point. From. Text('point (10. 02 20. 01)', 1000)); SELECT SE_As. GML(location) FROM mytable WHERE id = 1; <gml: Point srs. Name="UNKNOWN"> <gml: coord><gml: X>10. 02</gml: X><gml: Y>20. 01</gml: Y></gml: coord> </gml: Point> SE_As. GML() function usage example

IBM Software Group IDS and Web. Sphere MQ § Web. Sphere MQ: Reliable messaging infrastructure for SOA applications § Easy IDS / Web. Sphere MQ integration via Web. Sphere MQ Data. Blade 4 New Web. Sphere MQ API for IDS 10, modelled after an existing DB 2 MQ API 4 Allows an Informix application to easily interact with a Web. Sphere MQ based infrastructure 4 Additional Virtual Table Interface (VTI) support for simple SQL/Table-based access to Web. Sphere MQ queues! 4 Comes bundled with IDS 10

IBM Software Group Web. Sphere MQ Data. Blade: Examples API Example: VTI Example: execute function MQSend('AMT. SAMPLE. SERVICE', 'AMT. SAMPLE. POLICY', 'Hello Queue'); insert into vti. MQ (msg) values ('Hello World!'); 1 row(s) inserted. (expression) 1 1 row(s) retrieved. select msg from vti. MQ; execute function MQReceive('AMT. SAMPLE. SERVICE ', 'AMT. SAMPLE. POLICY'); msg Hello World! (expression) Hello Queue 1 row(s) retrieved.

IBM Software Group Agenda § Service-oriented Architectures (SOA) § Informix and SOA - Overview § Informix and SOA - Details 4 More on Web services 4 Informix SOA Foundation Technologies 4 IDS 10 as a Web service provider 4 IDS 10 as a Web service consumer § Additional Information

IBM Software Group IDS as a Web service provider: What is supported? § WORF based Web services § EGL based Web services § Stateless Session EJB Web services § Java Bean Web Services 4 The Java Bean could e. g. contain Informix JDBC calls § Java Bean Web Services based on the SQLto. XML/XMLto. SQL Java class libraries §. NET IDS provider allows easy integration into. NET Web services frameworks

IBM Software Group IDS as a Web service provider: WORF § WORF (Web services Object Runtime Framework ) is the runtime component of DADX based Web services. § WORF uses the SOAP protocol and DADX files and provides the following features: 4 Resource based deployment and invocation 4 Automatic service redeployment, at development time, when defining resource changes 4 HTTP GET and POST bindings, in addition to SOAP 4 Automatic WSDL and XSD generation, including support for UDDI Best Practices 4 Automatic documentation and test page generation IDS 10

IBM Software Group IDS as a Web service provider: WORF (cont. ) § Document Access Definition e. Xtension (DADX) Web services: originally developed with IBM DB 2 and XML Extender in mind 4 Easily wrap IBM DB 2 XML Extender or regular SQL statements inside a Web service. § Supported DADX functions for IDS: 4 Query 4 Insert 4 Update 4 Delete 4 Call Stored Procedures (limited support for IDS 7)

IBM Software Group WORF Example (1): Generated DADX file <? xml version="1. 0" encoding="UTF-8"? > <dadx: DADX xmlns: dadx="http: //schemas. ibm. com/db 2/dxx/dadx" xmlns: xsi="http: //www. w 3. org/2001/XMLSchema-instance" xmlns: xsd="http: //www. w 3. org/2001/XMLSchema" xsi: schema. Location="http: //schemas. ibm. com/db 2/dxx/dadx. xsd"> <dadx: operation name="insert. One. Customer"> <dadx: documentation xmlns="http: //www. w 3. org/1999/xhtml"> </dadx: documentation> <dadx: update> <dadx: SQL_update> <![CDATA[ INSERT INTO itso. customer ( customer_num, fname, lname, company, address 1, address 2, city, state, zipcode, phone ) VALUES ( 0, : fname, : lname, : company, : address 1, : address 2, : city, : state, : zipcode, : phone ) ]]> </dadx: SQL_update> <dadx: parameter name="fname" type="xsd: string"/> <dadx: parameter name="lname" type="xsd: string"/> <dadx: parameter name="company" type="xsd: string"/> <dadx: parameter name="address 1" type="xsd: string"/> <dadx: parameter name="address 2" type="xsd: string"/> <dadx: parameter name="city" type="xsd: string"/> <dadx: parameter name="state" type="xsd: string"/> <dadx: parameter name="zipcode" type="xsd: string"/> <dadx: parameter name="phone" type="xsd: string"/> </dadx: update> </dadx: operation> </dadx: DADX>

IBM Software Group WORF Example (2): Web service test client

IBM Software Group IDS as a Web service provider: EGL based services § EGL is a Java based, 4 GL-like language which is easy to learn § EGL has builtin Web services support § EGL communicates via JDBC with IDS 10 § EGL 6. x requires Web. Sphere Application Server for Web services deployment (additional app server deploymenmt support with EGL 7. x) § EGL is part of the Rational Software Development Platform (powerful IDE) § Very interesting for existing Informix 4 GL customers 4 Supported 4 GL to EGL conversion path!

IBM Software Group IDS as a Web service provider: EGL based services

IBM Software Group Agenda § Service-oriented Architectures (SOA) § Informix and SOA - Overview § Informix and SOA - Details 4 More on Web services 4 Informix SOA Foundation Technologies 4 IDS 10 as a Web service provider 4 IDS 10 as a Web service consumer § Additional Information

IBM Software Group IDS 10 as a Web service consumer: Overview § Utilization of the leading extensible database architecture (Data. Blade technology) of IDS 10 § User defined routines (stored procedures) in C or Java, to allow access to existing Web services § Simple integration of IDS J/Foundation and the Apache AXIS (SOAP) environment for Web service access § Web service access through IDS 10 adds new capabilities to existing SQL based applications (e. g. 4 GL, ODBC, JDBC, ESQL/C etc. )!

IBM Software Group IDS 10 as a Web service consumer: Development steps: § Step 1: Obtain access to the Web service description (WSDL file) § Step 2: Automatically generate Java classes with the AXIS code generator § Step 3: Write a simple Java ‚wrapper‘ UDR § Step 4: Compile the Java classes and create a JAR file § Step 5: Register the new Java UDR(s) with the database server (IDS 10) § Step 6: Execute the new Java UDR to access the Web service

IBM Software Group IDS 10 as a Web service consumer: Step 2

IBM Software Group IDS 10 as a Web service consumer: Step 3 import Currency. Exchange. *; public class Currency. Exchange. UDRs { public static double currency. Exchange( String country 1, String country 2) throws Exception { double Ret. Val; Currency. Exchange. Service service = new Currency. Exchange. Service. Locator(); Currency. Exchange. Port. Type port = service. get. Currency. Exchange. Port(); Ret. Val = port. get. Rate(country 1, country 2); return Ret. Val; } };

IBM Software Group IDS 10 as a Web service consumer: Step 4

IBM Software Group IDS 10 als Web Service Consumer: Step 5 execute procedure install_jar('file: C: /Red. Book 2003/AXIS/Currency. Exchange. jar', 'Currency. Exchange'); execute procedure ifx_allow_newline('t'); begin work; create function Currency. Exchange (lvarchar, lvarchar) returns float as exchange_rate external name 'Currency. Exchange: Currency. Exchange. UDRs. currency. Exchange(java. lang. String, java. lang. String) language java; alter function Currency. Exchange (lvarchar, lvarchar) with (add parallelizable); grant execute on function Currency. Exchange (lvarchar, lvarchar) to public; commit work;

IBM Software Group IDS 10 as a Web service consumer: Step 6 / Examples Example 2: Google Search Example 1: Currency Exchange

IBM Software Group Agenda § Service-oriented Architectures (SOA) § Informix and SOA - Overview § Informix and SOA - Details § Additional Information

IBM Software Group Helpful Links / Info § IBM Informix Dynamic Server 10 4 http: //www. ibm. com/software/data/informix/ids 10/ § IBM Informix and Web. Sphere 4 http: //www. ibm. com/software/data/informix/websphere § IBM Rational EGL 4 http: //www. ibm. com/developerworks/rational/products/egl/ § IBM and SOA 4 http: //www. ibm. com/soa § IBM Web. Sphere 4 http: //www. ibm. com/software/websphere § IIUG / IUG 4 Regular member emails 4 http: //www. iiug. org 4 Germany: IUG (http: //www. iug. de)

IBM Software Group Coming Soon: The IBM Data Servers / SOA Redbook § Covers all IBM Data Servers 4 DB 2 z/OS 4 DB 2 UDB 4 IMS 4 and. . . 4 One dedicated chapter on IDS! § Lots of step-by-step examples (example code downloadable) § Availability: Summer 2006 § Download at: http: //www. ibm. com/redbooks § Redbook ID: SG 24 -7259

IBM Software Group The IBM Informix / Web. Sphere Redbook! § Covers all IDS / Web. Sphere Topics 4 IDS and WAS 5 (J 2 EE development, JSP, Servlets, etc. ) 4 IDS and Web. Sphere Studio 4 IDS and XML Support 4 IDS and Web services 4 IDS and Web. Sphere Portal Server 4 IDS and Web. Sphere MQ 4 Informix 4 GL and WS Studio Integration § Lots of step-by-step examples (example code downloadable) § Based on Linux and Windows platforms § Published July 2003 § Download at: http: //www. ibm. com/redbooks § Redbook ID: SG 24 -6948 § Over 7000 downloads so far!

IBM Software Group What if you have additional EGL-related questions? The 4 GL/EGL Redbook! § EGL Language Concepts § The Rational SDP environment § A simple EGL web application § 4 GL to EGL conversion § EGL and databases § Advanced EGL web programming § EGL and Jasper. Reports § EGL Deployment (standalone and web) § EGL CUI applications § plus much more. . . § Redbook ID: SG 24 -6673 § Published July 2005

IBM Software Group IBM Information On Demand 2006 The premier information management global conference October 15 – 20, 2006 Anaheim, California ibm. com/events/Information. On. Demand Why Your Should Attend: § Participate in the PREMIER IBM Information Management event § Learn how technology solves business problems § Hear from your peers § Roadmap to strategic advantage

IBM Software Group . . . and finally: Thank you very much! Feel free to contact me at: Alexander. Koerner@de. ibm. com