Query Web Service from Informix 4GL
Posted in 2008
Topics: Connectivity: ESQL/C, 4GL & Embedded SQL, Server Administration
[Resend to list] On Thu, Nov 20, 2008 at 5:11 AM, eferreyra <eferreyra@gmail.com> wrote: > Our DBA tell us (developers) that in informix IDS 11.5 and his new > version of Informix 4GL we can query web services from Informix 4gl > program. > > I cant find any help or guide to do this. > > Does anyone have some link or doc where i can get info on this > function ? There will be some functionality related to I4GL and SOA in I4GL 7.50.xC2, due out soon; it is not in 7.50.xC1 which is currently GA. The functionality will be released in increments over the next two or three releases. In the first release, it will be possible to use I4GL as a service publisher - that is, you will be able to deploy I4GL functions so that they can be used as a web service by other languages. When I say "function", that means there's an entry point function that is described in WSDL (Web Services Description Language); the implementation of that function may, and usually will, call other I4GL functions. The I4GL function is accessed via the Axis2/C libraries, which does the heavy lifting of parsing the messages incoming (collecting the parameters to the function) and reformatting the responses outgoing (sending the return values from the function). In subsequent releases (order, timing unspecified), the functionality will be extended. It will allow I4GL to invoke web services (nominally provided by some other system, though of course it could actually be a web service provided by an I4GL function). It will handle report output, possibly via MTOM (a SOAP-based Message Transmission Optimization Mechanism) or an analogous mechanism. It will handle record type parameters. It will (eventually) handle array (and array of record) parameters, using the dynamic array feature of I4GL 7.32 and later. As with all predictions about the future, this one is bound to be wrong in details. It is in no sense a commitment by IBM; product plans may change; and all the other standard disclaimers. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2008.0513 -- http://dbi.perl.org/ "Blessed are we who can laugh at ourselves, for we shall never cease to be amused." NB: Please do not use this email for correspondence. I don't necessarily read it every week, even.
Ok, many thanks Jonathan!
For other people who could fall in this posts, what we do is:
Build a c++ program with gSOAP (google it) that consume web/wcf
services process the results and send it to a new file with unload
format (pipe separated or something like) and then we load the file in
a temp table, then we have the result in I4GL. Of course as "good"
developers all this is isolated in a function in a library, so for
simple example a I4GL function like:
f_get_some_info_from_ws()
works doing:
RUN "gsoapprogram > /tmpfile"
(Check exit code for exceptions)
LOAD FROM /tmpfile DELIMITER ... INSERT INTO temptable.......process temptable to build function's return
return info
Hope helps anyone more!
Thanks again!
Here are some alternetaive ways;
http://www.querix.com/news-events/development/development-
update-september-2008-4gl-web-service-provider
http://www.querix.com/news-events/development/development-
update-september-2008-4gl-web-service-client
On 21 Nov 2008 at 3:47, eferreyra wrote:
> Ok, many thanks Jonathan!
>
> For other people who could fall in this posts, what we do is:
>
> Build a c++ program with gSOAP (google it) that consume web/wcf
> services process the results and send it to a new file with unload
> format (pipe separated or something like) and then we load the file in
> a temp table, then we have the result in I4GL. Of course as "good"
> developers all this is isolated in a function in a library, so for
> simple example a I4GL function like:
>
> f_get_some_info_from_ws()
>
> works doing:
> RUN "gsoapprogram > /tmpfile"
> (Check exit code for exceptions)
> LOAD FROM /tmpfile DELIMITER ... INSERT INTO temptable.......> process temptable to build function's return
> return info
>
> Hope helps anyone more!
>
> Thanks again!
>
> _______________________________________________
> Informix-list mailing list
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list
>