Another quetion...about function
Juan Manuel Salazar Santaria, new to Informix, asked how to create a function in the database and use it in a query. Paul Brown pointed to Foundation.2000 and DataBlades; Rudy Fernandes said Oracle-style functions map to stored procedures. Jonathan Leffler said CREATE FUNCTION exists on IUS or other 9.x servers, otherwise use CREATE PROCEDURE and SPL.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
This is a multi-part message in MIME format. ------=_NextPart_000_0051_01BEEB03.E785FDE0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi... How can i create a function in the database and later use it in a = query?...is this posible? Sorry i'm begging to work with Informix Thanks ------=_NextPart_000_0051_01BEEB03.E785FDE0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META content=3D"text/html; charset=3Diso-8859-1" = http-equiv=3DContent-Type> <META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV>Hi...</DIV> <DIV> </DIV> <DIV>How can i create a function in the database and later use it in a=20 query?...is this posible?</DIV> <DIV> </DIV> <DIV>Sorry i'm begging to work with Informix</DIV> <DIV> </DIV> <DIV>Thanks</DIV></BODY></HTML> ------=_NextPart_000_0051_01BEEB03.E785FDE0--
Juan Manuel Salazar Santaria (jsalazar@lim-co.pe.dhl.com) wrote: : How can i create a function in the database and later use it in a = : query?...is this posible? : : Sorry i'm begging to work with Informix : Yes. In the Foundation.2000 product. Check out http://www.informix.com/idn in the DataBlades area for details and examples.
Are you are talking about functions like those in Oracle? If so, they translate to Stored Procedures in Informix. Read up for further info. Rudy Juan Manuel Salazar Santaria wrote: > > Hi... > > How can i create a function in the database and later use it in a = > query?...is this posible? > > Sorry i'm begging to work with Informix > > Thanks
Juan Manuel Salazar Santaria wrote: > How can i create a function in the database and later use it in a = > query?...is this posible? > > Sorry i'm begging to work with Informix If you've got IUS or other 9.x server, you can look up CREATE FUNCTION in the Informix Guide to SQL Syntax manual. If you got any other version, you'll need to look up CREATE PROCEDURE instead. In either case, you'll also need to read up on SPL (stored procedure language). If you decide to get into C or Java programming, you must have IUS, and you need to do a lot more manual bashing. -- Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net) Guardian of DBD::Informix v0.60 -- see http://www.perl.com/CPAN #include <disclaimer.h>