iiug conf 2010 i4gl soa latest

8/8/2019 Iiug Conf 2010 i4gl Soa Latest

1/48


2/48

2

2010 IIUG Informix Conference

Copyright IBM Corporation 2010. All rights reserved.

U.S. Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule

Contract with IBM Corp.

THE INFORMATION CONTAINED IN THIS PRESENTATION IS PROVIDED FOR INFORMATIONAL PURPOSESONLY. WHILE EFFORTS WERE MADE TO VERIFY THE COMPLETENESS AND ACCURACY OF THE

INFORMATION CONTAINED IN THIS PRESENTATION, IT IS PROVIDED AS IS WITHOUT WARRANTY OF

ANY KIND, EXPRESS OR IMPLIED. IN ADDITION, THIS INFORMATION IS BASED ON IBMS CURRENT

PRODUCT PLANS AND STRATEGY, WHICH ARE SUBJECT TO CHANGE BY IBM WITHOUT NOTICE. IBM

SHALL NOT BE RESPONSIBLE FOR ANY DAMAGES ARISING OUT OF THE USE OF, OR OTHERWISE

RELATED TO, THIS PRESENTATION OR ANY OTHER DOCUMENTATION. NOTHING CONTAINED IN THIS

PRESENTATION IS INTENDED TO, NOR SHALL HAVE THE EFFECT OF, CREATING ANY WARRANTIES OR

REPRESENTATIONS FROM IBM (OR ITS SUPPLIERS OR LICENSORS), OR ALTERING THE TERMS AND

CONDITIONS OF ANY AGREEMENT OR LICENSE GOVERNING THE USE OF IBM PRODUCTS AND/OR

SOFTWARE.

IBM, the IBM logo, ibm.com, FileNet, OmniFind and all IBM FileNet products are trademarks or registered

trademarks of International Business Machines Corporation in the United States, other countries, or both. If these

and other IBM trademarked terms are marked on their first occurrence in this information with a trademark symbol (

or ), these symbols indicate U.S. registered or common law trademarks owned by IBM at the time this information

was published. Such trademarks may also be registered or common law trademarks in other countries. A current list

of IBM trademarks is available on the Web at Copyright and trademark information atwww.ibm.com/legal/copytrade.shtml

Other company, product, or service names may be trademarks or service marks of others.

Disc la imer


3/48

3


Contents

Informix 4GL

Problem statement

Service Oriented Architecture (SOA)

Prerequisites and Supported Platforms

Publish Web services

Consume Web services

Troubleshooting

Informix 4GL: Road Ahead

Demos

References


4/48

4


Front-end for Informix database servers

Caters to development of database applications

Character-based user interface (CUI)

Rich environment of forms and reports

Easy to maintain

Cost and performance advantage over new generation languages

Extensively used by many Informix customers

In formix 4GL


5/48

5


Lots and lots of application code including reports written in I4GL

How to reuse the existing I4GL code and I4GL skill set?

Character-based user interface (CUI)

How do we make use of GUI yet doing things with I4GL?

Solution: I4GL-SOA

Problem St at em ent


6/48

6


Serv ic e Or ient ed Archi t ec t ure (SOA)

Separate core businessfunctions

Maximal use of IT assets &investments

Open communicationenvironment

On demand infrastructure

Connect processes online

Process automation

Better control over information

Reusability Agile


7/48

7


Befo re I4GL-SOA

Interoperability between distributed system was very complex

Tight coupling among interactive systems

Migrating existing system to newer technology


8/48

8


Af t er I4GL-SOA

Efficient, flexible and agile systems in place

Interoperability between distributed system made easy

Loose coupling among interactive systems

Needless to migrate existing system to newer technology

A collection of loosely-coupled, distributed services which communicate

and interoperate via agreed standards.


9/48

9


I4GL-SOA Rat ionale

Ease of deployment of I4GL functions as web services

Easy integration of I4GL with web based applications

Reuse the existing I4GL functions in web based solutions

Consuming I4GL services from within I4GL Consuming third party services from within I4GL

Ease of maintenance

More business opportunity for your existing I4GL code


10/48

10


Benef i t t o Custom ers

Reuse algorithms and business logic

- Internet

- Another partner/company location

Think process and not screens or forms Seamless operation across multiple programming languages and

platforms

Efficient collaboration across departments

Create Dictionary of available functionality/expertise Save precious dollars in time and effort


11/48

11


I4GL-SOA Arc hi t ec t ure

Web Service

IBM Informix 4GL

Apache AXIS2C Web Server

Publisher Subscriber

IDS

Publish Consume


12/48

12


Prerequis i t es and Support ed Plat form s

Prerequisites Apache Axis2/C Version 1.5.1 (bundled with I4GL)

Apache Axis2/Java Version 1.3.1 (bundled with I4GL)

IBM Informix Dynamic Server Version 10 or later

IBM Informix 4GL 7.50.xC4

Java Runtime Environment (JRE) 1.5 or later

Perl 5.8.8

Supported Platforms

HP-IA 11.23 or 11.31 AIX 5.3 and 6.1

Red Hat Enterprise Linux 4 or 5

Solaris 5.9 or 5.10

SUSELinux Enterprise Server 10


13/48


Role of w 4g l and w 4g lc

4GLsourcecode

w4gl

(User Interface)

Web-service definitions

IDS

Configuration File (.4cf)w4glc

(Perl script)

Publisher / Subscriber

SubscribePublish

FUNCTION visa_valid(cc_number, cc_exp, cc_cvp)

DEFINE vis_rec RECORD LIKE visa_validation.* ,cc_number CHAR(16),cc_exp CHAR(5),

cc_cvp CHAR(3),sel_stmt CHAR(512);

LET sel_stmt = "SELECT * FROM visa_validation

WHERE cc_number = ?AND cc_exp = ? AND cc_cvp = ?";

PREPARE st_id FROM sel_stmt;DECLARE cur_id CURSOR FOR st_id;

OPEN cur_id USING cc_number, cc_exp, cc_cvp;FETCH cur_id INTO vis_rec.*;CLOSE cur_id;

FREE cur_id;FREE st_id;

RETURN vis_rec.cc_name, vis_rec.cc_balance, vis_rec.cc_limit

END FUNCTION


14/48

14


W4GL

A different database can be chosen using anenvironment variable PROGRAM_DESIGN_DBS


15/48

15


W4GL fac i l i t a t es

Create a web service entry

Manage a web service entry

Generates configuration for publisher and subscriber

Deploys/Publish a web service

Package a deployed web service Parse WSDL Source can be URL and file

Generates code for consumer/subscriber

Trouble shooting

Persistent web service entries for regeneration


16/48

16


Sc hem a Design


17/48

17


Publ ish / Subsc r ibe Work f low

I4GL function

Service name

I/O arguments4GL files

Publisher

Su

bscriber

App

Server

I4GL

Runtime IDS

WSDLOperation name

I4GL functionTarget Directory

Object file I4GL+

Other webservices

Non-I4GLconsumer

I4GL

consumer

IDS


18/48

18


MACH 11 t opology

Primary

SDS

Blade Server A

City-ABlade Server B

HDRSecondary

SharedDisk

Shared

Disk

RSS

Blade Server C

SharedDisk

SharedDiskMirror

SDS

SDS

Blade Server D

City-A

Connection Manager(workload balancing and failover arbitration)

DBAIDSAdmin

IDSAdmin

Client Apps

Client Apps

HDRTraffic

RSSTrafficCity-B

City-D


19/48

19


I4GL-SOA and MACH11

I4GL function

Service name

I/O arguments4GL files

Publisher

Su

bscriber

App

Server

I4GL

Runtime IDS

WSDLOperation name

I4GL functionTarget Directory

Object file I4GL+

Other webservices

Non-I4GLconsumer

I4GL

consumer

IDS

ConnectionManager

Connection

Manager


20/48

20


Configuration File (.4cf)

App Server

Compile and generateShared object

w4gl(User Interface)

I4GL functionService nameI/O arguments

4GL files

Publ i shing / Deploy ing Proc ess overview

Informix 4GLfunction

IDS

w4glc(Backend script)

Publish

FUNCTION visa_valid(cc_number, cc_exp, cc_cvp)

DEFINE vis_rec RECORD LIKE visa_validation.* ,cc_number CHAR(16),

cc_exp CHAR(5),cc_cvp CHAR(3),sel_stmt CHAR(512);

LET sel_stmt = "SELECT * FROM visa_validationWHERE cc_number = ?AND cc_exp = ? AND cc_cvp = ?";

PREPARE st_id FROM sel_stmt;DECLARE cur_id CURSOR FOR st_id;

OPEN cur_id USING cc_number, cc_exp, cc_cvp;FETCH cur_id INTO vis_rec.*;CLOSE cur_id;FREE cur_id;

FREE st_id;

RETURN vis_rec.cc_name, vis_rec.cc_balance, vis_rec.cc_limit

END FUNCTION

Deploy


21/48

21


Defin ing a Web Servic e for Publ i shing

Basic environment description

Hostname

Application server

Database Web Service

Service name, function name

Input and Output parameters

Existing I4GL source code Generate and build


22/48

22


Adding a Web Service

Defi ne: Publ ish ing

I4GL functionthat provides a

service

Name of theweb-service

that is exposed


23/48

23



Input and output arguments

Input / Outputarguments to /

from the function


24/48

24



Entering 4GL file details


25/48

25


Generate c onf igurat ion for Publ ish ing

Generating configuration file


26/48

26


Generated c onf igurat ion f i le

.TYPE = publisher

.


27/48

27


Deploy ing a w eb servic e

Needs a configuration file


28/48

28


Deploy ing a w eb servic e

Input is the configuration file

Compiles supplied files

Generates a Web Services Definition Language (WSDL) file

Generates Axis2/C interface files

Generates the shared object

Copies the files to the location which application server uses


29/48

29


Web servicedetails

Executable using web servicefunctionality

Generate and CompileIntermediate code

w4gl(User Interface)

Subsc r ib ing / Consum ing Process overv iew

Informix 4GLsourcecode

IDS

Configuration File (.4cf)w4glc

(Backend script)

Subscribe

MAINCALL call_web_service_client()

END MAIN

FUNCTION call_web_service_client()

DEFINE name VARCHAR(40),address VARCHAR(200),

...transaction_date DATE,

description VARCHAR(250),value INTEGER

...

OPEN FORM f_credit FROM "svc_client"DISPLAY FORM f_credit

INPUT card_number, cvv_number, expiry_date

FROM s_card.card_number, s_card.cvv_number, s_card.expiry_date

CALL i4gl_cc_details(card_number, expiry_date, cvv_number)

RETURNING name, address, city, state, zipcode, phone, email,card_number, creditLimit, cardType,

transaction_date, description, value

DISPLAY name TO s_card.nameDISPLAY address TO s_card.address...

...DISPLAY description TO s_card.description

DISPLAY value TO s_card.valueEND FUNCTION


30/48

C


31/48

31


Consuming a w eb serv ice

Generates consumption code

2010 IIUG I f i C f


32/48

32



2010 IIUG I f i C f


33/48

33



2010 IIUG I f i C f


34/48

34


Generat ed Conf igurat ion Fi le

.TYPE = subscriber

.

Data extracted fromWSDL



35/48

35


St eps t o consume

Compile option generates

Configuration file

Object file

User application links this object file to create executable



36/48

36


Reports

Reports can also be generated from web-service

Reports function can be deployed similar to other functions

New type for file WS_FILENAME introduced in w4gl UI and config

file Generated report

Received at the client side

Stored at the client side in the target directory

Known file extensions are honored



37/48

37


Report function as web-service

Similar to deploying other services

Similar to consuming other services New TypeWS_FILENAME

[SERVICE]

TYPE = subscriberI4GLVERSION = 7.50.xC4WSHOME = /home/informix/4GL/AXIS2C

TARGET_DIR = /home/informix/IIUG_demo/i4gl-report/I4GL_FUNCTION = client_report

TARGET_FILE = client_report.c[WSDL_INFO]

WSDL_PATH = /home/informix/IIUG_demo/i4gl-report//local.wsdlWSDL_NAME_SPACE = http://www.ibm.com/genreport_cc_details[FUNCTION]

SERVICENAME = ws_gen_reportNAME = genreport_cc_details

[INPUT][VARIABLE] NAME = card_number TYPE = varchar(19) [END-VARIABLE]

[VARIABLE] NAME = expiry_date TYPE = varchar(5) [END-VARIABLE][VARIABLE] NAME = cvv_number TYPE = varchar(3) [END-VARIABLE]

[END-INPUT][OUTPUT]

[VARIABLE] NAME = stmt_report TYPE = ws_filename [END-VARIABLE]

[END-OUTPUT][END-FUNCTION]

[END-WSDL_INFO][END-SERVICE]



38/48

38


Report function as web-service

Similar to consuming other servicesFUNCTION call_web_service_client()

DEFINE file VARCHAR(255),cc_num VARCHAR(19),exp_date VARCHAR(5),cvv_num VARCHAR(3)

DEFINE l_ans CHAR(1),

p_msg CHAR(50)

OPEN FORM f_input FROM "client"DISPLAY FORM f_inputINPUT cc_num, cvv_num, exp_date FROM

s_card.card_number, s_card.cvv_number,s_card.expiry_date

CALL client_report(cc_num, exp_date, cvv_num)RETURNING file

DISPLAY cc_num TO s_card.card_numberDISPLAY cvv_num TO s_card.cvv_numberDISPLAY exp_date TO s_card.expiry_dateDISPLAY file TO s_card.rep_file

END FUNCTION

FUNCTION genreport_cc_details(lcard_number, lexpiry_date, lcvv_number)DEFINE lcard_number VARCHAR(19),

lexpiry_date VARCHAR(5),lcvv_number VARCHAR(3),p_qrystmt VARCHAR(255),file VARCHAR(255)

DEFINE p_customer RECORD LIKE credit_customer.*,p_trans RECORD LIKE card_transaction.*

LET p_qrystmt = "SELECT * FROM card_transaction \WHERE customerid = ?";

LET file = "cust_listing.html"START REPORT cust_list TO OUTPUT "FILE" DESTINATION fileDECLARE q_curs CURSOR FOR

SELECT * FROM credit_customerWHERE card_number = lcard_numberAND expiry_date = lexpiry_date

AND cvv_number = lcvv_numberPREPARE stmt_1 FROM p_qrystmtDECLARE q_trans CURSOR FOR stmt_1

FOREACH q_curs INTO p_customer.*OPEN q_trans USING p_customer.customeridFETCH q_trans INTO p_trans.*OUTPUT TO REPORT cust_list(p_customer.*, p_trans.*)CLOSE q_trans

END FOREACHFINISH REPORT cust_list

RETURN fileEND FUNCTION

REPORT cust_list (r_customer, r_trans)DEFINE r_customer RECORD LIKE credit_customer.*

DEFINE r_trans RECORD LIKE card_transaction.*

OUTPUT

TOP MARGIN 0BOTTOM MARGIN 0

PAGE LENGTH 25

FORMAT

ON EVERY ROW

PRINT "STATEMENT FOR CREDIT CARD " || r_customer.card_numberPRINT "---------------------------------------------"

PRINT "To"PRINT " "

PRINT " " || r_customer.name

PRINT " " || r_customer.addressPRINT " " || r_customer.city || ", " || r_customer.state || ", " ||

r_customer.zipcode

PRINT " "PRINT "Ph: " || r_customer.phone

PRINT "Email: " || r_customer.email

PRINT " "PRINT " "

PRINT "Credit Limit : " || r_customer.creditLimit

PRINT " "PRINT "Transaction Details"

PRINT "-------------------"PRINT r_trans.transaction_Date || " " ||

r_trans.description || " " ||

r_trans.value

PRINT " "PRINT " "

END REPORT



39/48

39


Trouble Shoot ing



40/48

40


Com m and L ine Ut i l i t y (W4GLC)

For Advanced users

Manually create a configuration file

Data in configuration file not stored in database

DESCRIPTIONOPTION

Bundling a web service for production deploymentpackage

Deploy web service on the AXIS2C serverdeploy

Compile generated intermediate codecompile

Generate intermediate code for publish/subscribegenerate

Overwrite existing service with identical nameforce

Retain intermediate source files for troubleshootingkeep

Generates code without on-screen displaysilent

W4GLC {-OPTION}



41/48

41


W4GL A g lanc e

Management of web-service details

Persistent data for easy regeneration of configurations

Flexible design to deploy a service remotely

Easy administration Written in I4GL

Ease of use for I4GL users

Automation using WSDL parser

Validation using data type parser

Remote error propagation



42/48

42


Demos

Publishing an I4GL web service

Consuming an I4GL web service using an non-I4GL subscriber

Consuming an I4GL web service using an I4GL subscriber

Generating and consuming reports



43/48

43

In form ix 4GL: Road Ahead

Disclaimer: The information on the new product is intended to outline our general product direction and it should not be relied on in making a purchasing decision. The information on the new product is for informational purposes only and may not be incorporatedinto any contract. The information on the new product is not a commitment, promise, or legal obligation to deliver any material, code or functionality. The development, release, and timing of any features or functionality described for our products remains at our solediscretion.

4GL 7.x4GL 7.x(SOA enablement)(SOA enablement)

Form enhancements

System curses

Improved color

Box Multi-line fields in screen arrays

Variable size forms

Enhanced Sub-table handling

Mac OS

Native Library

Enhance Language support

New SQL syntax from IDS

SOA Enablement

WAS support

Report enhancements

PDF support

I4gl in IDS

I4GL InterimI4GL InterimReleasesReleases

2012 and beyond2012 and beyond

SOA enablement

Reports via web services

Function signature

detection (I4GL parser)

Enhanced Error handling

RECORD type

AIX port of SOA

WSDL parser

Enhance Language support

File I/O support

Client Required PriorityDefect Fixes

4GL 7.x4GL 7.x(I4GL(I4GLEmbeddability)Embeddability)

Library support

I4GL non-interactive part aslibrary

Dynamic load of shared

library by p-code runner

Certification of non-interactive

I4GL-LIB for weblanguages/tools.

Mac OS basic port

Evaluation copy

P-code, C-code, ISQL & ID


4GL 7.x4GL 7.x(I4GL(I4GL

Modernization)Modernization) Form enhancements

Horizontal Scrolling

Form and field status

List support

Report enhancements

XML output

Enhanced Language

support

New I4GL syntax


Q2 2010 Q4 2010 Q2 2011



44/48

44

Summary

Tools w4gl and w4glc

I4GL-SOA can

publish functions to web services

subscribe functions from other web services Reuse of existing code and skill set

I4GL code can be used in GUI

Opens new business opportunities

Aggressive enhancements to I4GL New investments to I4GL



45/48

45

IBM Informix 4GL v 7.50.xC4 documents available at : TBD

http://www-01.ibm.com/support/docview.wss?uid=swg27013652

IBM Informix 4GL v 7.50.xC4, xC3: Release notes, documentation notes andmachine notes is available at

TBD

http://www-01.ibm.com/support/docview.wss?uid=pub1gi11910302

Developer works on Deploying 4GL functions as web-services athttp://www.ibm.com/developerworks/data/library/techarticle/dm-0902mottupalli/

Developer works on Consume Web services using Informix 4GL athttp://www.ibm.com/developerworks/data/library/techarticle/dm-0910i4glwebservices/index.html

References



46/48

46

Quest ions

!!!



47/48

47

Signup to participate in user feedback sessions for IDS

Session opportunities include:

Hands on experience test driving the latest Schema and

Storage Manager UIs for the OpenAdmin Tool

A sneak peak and feedback on the new IDS Installation andConfiguration Tooling/UI: A group walkthrough discussion with theIDS Dev team

A sneak peak and feedback on the new IDS DeploymentTooling/UI: A group walkthrough discussion with the IDS Dev team

Your opportunity to give your input on useful sources andresources for solving problems encountered while using IDS:An examination of current and future resources followed by agroup exercise to provide your preferences

How Optim may be used for problem determination andresolution with IDS A walkthrough and group discussion

Look for posters and sign-up sheets



48/48

48

Informix 4GL functions usage in the GUIenvironment via web-services

Thank you !!!

Srinivasan R Mottupalli

[email protected]

Session: C07

iiug conf 2010 i4gl soa latest

Documents