b15 leffler 4gl as soa

Enabling 4GL function as web service

Srinivasan R MottupalliIBM India Pvt Ltd

Wednesday, April 29, 2009 • 01:00 – 02:00

Session: B15

2009 IIUG Informix Conference

International Informix Users Group 2

THE INFORMATION CONTAINED IN THIS PRESENTATION IS PROVIDED FOR INFORMATIONAL PURPOSESONLY. WHILE EFFORTS WERE MADE TO VERIFY THE COMPLETENESS AND ACCURACY OF THEINFORMATION CONTAINED IN THIS PRESENTATION, IT IS PROVIDED “AS IS” WITHOUT WARRANTY OFANY KIND, EXPRESS OR IMPLIED. IN ADDITION, THIS INFORMATION IS BASED ON IBM’S CURRENTPRODUCT PLANS AND STRATEGY, WHICH ARE SUBJECT TO CHANGE BY IBM WITHOUT NOTICE. IBMSHALL NOT BE RESPONSIBLE FOR ANY DAMAGES ARISING OUT OF THE USE OF, OR OTHERWISERELATED TO, THIS PRESENTATION OR ANY OTHER DOCUMENTATION. NOTHING CONTAINED IN THISPRESENTATION IS INTENDED TO, NOR SHALL HAVE THE EFFECT OF, CREATING ANY WARRANTIES ORREPRESENTATIONS FROM IBM (OR ITS SUPPLIERS OR LICENSORS), OR ALTERING THE TERMS ANDCONDITIONS OF ANY AGREEMENT OR LICENSE GOVERNING THE USE OF IBM PRODUCTS AND/ORSOFTWARE.

IBM, the IBM logo, ibm.com, FileNet, OmniFind and all IBM FileNet products are trademarks or registeredtrademarks of International Business Machines Corporation in the United States, other countries, or both. If theseand 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 informationwas published. Such trademarks may also be registered or common law trademarks in other countries. A current listof 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.

Disclaimer

• Informix 4GL (I4GL)• SOA Concepts• Rationale behind SOA for I4GL• What can we achieve with I4GL v7.50 xC2• 4GL-SOA Architecture• Using I4GL SOA• References

Contents

• Front-end for Informix Database Servers

• Caters to development of database applications

• Character-based user interface

• Easy To Maintain

• Cost and performance advantage over new generation languages

• Extensively used by many Informix customers

• Interoperability between system very complex

• Tight coupling among interactive systems

• Migrating existing system to newer technology

Before 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.”

After SOA

SOA for I4GL - Rationale • Ease of deployment of 4GL functions as web services

• Easy integration of 4GL with web based applications

• Reuse the existing 4GL functions in web based solutions

• Consuming other services from with in 4GL

• Ease of maintenance

• More business opportunity for your existing 4GL code

I4GL SOA Architecture

W4GL enables to …• Create a web service entry

• Manage a web service entries

• Deploy a web service – interface code generation

• Package a web service

• Consume web service – interface code generation

• Trouble shooting

- 10 -

Pre-requisites

• Apache Axis2/C Version 1.5 (bundled with 4GL)

• Apache Axis2/Java Version 1.3.1 (bundled with 4GL)

• IBM Informix Dynamic Server Version 7.31 or later

• IBM Informix 4GL 7.50.xC2 or later

• Java™ Runtime Environment (JRE) 1.4 or later

• Perl 5.8.5 or later

- 11 -

Supported Platforms

• Linux

• * Will also be available on• Sun Solaris• HP-UX• AIX

* Subject to change

- 12 -

Role of w4gl and w4glc

4GL source code

w4gl(User Interface)

Web-service definitions

Configuration File (.4cf) w4glc(Perl script)

Publisher / Subscriber

Publish Subscribe

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

- 13 -

A Sample Configuration Files

- 14 -

A different database can be chosen using an environment variable PROGRAM_DESIGN_DBS

- 15 -

Syspgm4gl - Database Design

- 16 -

Create a web serviceAdding a Host Name

- 17 -

Create a web serviceAdding an Application Server

- 18 -

Create a web service• Adding database information

Specify database used by I4GL function

- 19 -

Adding a Web Service

Create a web serviceName of the web-service

that is exposed

I4GL function that provides a

service

Input / Output arguments to /

from the function

- 20 -

Create a web serviceInput and Output argument entry

- 21 -

Create a web serviceEntering 4GL file details

- 22 -

Create a web serviceGenerating configuration file

- 23 -

Generated Configuration File

- 24 -

Deploying a web service

• Input to deployment process is the configuration file

• Compiles supplied files

• Generates a Web Services Definition Language (WSDL) file

• Generates Axis2/C interface files

• Copies the files to the location from which application server refers for services

- 25 -

Deploying a web service• Needs a configuration file

- 26 -

Trouble Shooting

- 27 -

Consuming a web service• Generates consumption code

- 28 -

Consuming a web service

- 29 -

- 30 -

- 31 -

- 32 -

Generated Configuration File

- 33 -

Steps to consume• Compile option generates

Configuration file Object file

• User application links this object file

- 34 -

Managing Web-services• W4GL allows you to manage

Host Name

App Server

Database

Web service

- 35 -

w4glc tool• Independent tool• Requires configuration file• Requires specific command line options

Usage: perl /vobs/tools_4xpm/sqldist/bin/w4glc { [-help] [-version] | [-silent] [-force] [-generate] [-compile] [-deploy] [-package]} <config-file>

-silent - Do not display the progress-force - Avoid user prompts-generate - Generate the code-compile - Compile the generated code-deploy - Deploy the web service-package - Create a package (tar-format) file for web-service

- 36 -

• IBM Informix 4GL v 7.50.xC2 documents available at : http://www-01.ibm.com/support/docview.wss?uid=swg27013652

• IBM Informix 4GL v 7.50.xC2 : Release notes, documentation notes and machine notes is available at http://www-01.ibm.com/support/docview.wss?uid=swg27013651

• Developer works Article on deploying 4GL functions as web-services at http://www.ibm.com/developerworks/data/library/techarticle/dm-0902mottupalli/

References

- 37 -

Srinivasan R MottupalliIBM India Private Limitedmrsrinivas@in.ibm.com

Session: B15Enabling 4GL Function as Web Service

- 38 -

Backup slides

- 39 -

Role of w4gl and w4glcUser Interface

(w4gl)Configuration File

(.4cf)

Input definitions

-Hostname-Appserver-Database-WebService-Subscriber

IDSProgramDesign

PERL script(w4glc)

Generate Code

Deploy Consume

- 40 -

[SERVICE]TYPE = publisherINFORMIXDIR = /vobs/tools_4xpm/sqldistDATABASE = i4glsoaCLIENT_LOCALE = en_US.8859-1DB_LOCALE = en_US.8859-1INFORMIXSERVER = loc_ids11_mrsHOSTNAME = idcxs2.in.ibm.comPORTNO = 9876I4GLVERSION = 7.50.xC2WSHOME = /vobs/tools_4xpm/sqldist/AXIS2CWSVERSION = AXIS1.5TMPDIR = /tmp/w4glSERVICENAME = ws_demo[FUNCTION]

NAME = test_demoINPUT = CHAR(10),OUTPUT = CHAR(100), CHAR(100),

[END-FUNCTION][DIRECTORY]

NAME = /tmp/soademoFILE = soademo.4gl,

[END-DIRECTORY][END-SERVICE]

Configuration File - Deployment

b15 leffler 4gl as soa

Documents

informix 4gl reference guide

forecasting aircraft icing jonathan leffler chicago cwsu

4gl handbook progress

leffler feb 8 access to paid content

informix 4gl y soe - rejuveneciendo 4gl con servicios...

table of contents b2 b3 b4-b-9, b14-b15 b14-b15 b10-b13

cloud-optimized 4gl applications

the closing bell - leffler commodities

informix-4gl by...

forecasting aircraft icing jonathan leffler chicago cwsu

informix dynamic 4gl user guide - oninitthe informix dynamic...

beginners unit b15

exploded views & replacement parts list · e1 e10 40 181-1...

perl, apache, dbi and dbd::informix jonathan leffler open...

välkommen till frescati - mittag-leffler institute

informix 4gl to genero bring your code into the future by...

supercharge 4gl applications with eagleiq · 2007. 3....

the poincaré-mittag-leffler relationship 2 .pdf ·...

informix 4gl statements

informix-4gl concepts and use · informix®-4gl concepts...