Rob wrote:
> I few weeks ago, I searched this newsgroup for discussions on
> string functions (such as upper() and lower()) for the Universal
> Server (now marketed as the "Informix Dynamic Server with
> Universal Data Option"). There were various pointers to SPL
> string handling functions which were torturous in design because
> of SPL limitations.
Yes, the SPL routines are horridly tortuous (and torturous, too).
They're also slow.
Mercifully, the 7.30 servers support some of these functions as
standard -- UPPER, LOWER, SUBSTR in particular. Long overdue!
What you've provided will be useful until the engine provides them
as standard -- which will probably be the 9.20 release of IDS/UDO,
though that is a *guess* which I have not checked at all. They will
appear in some forthcoming version is for sure.
--
Jonathan Leffler (jleffler@informix.com, jleffler@earthlink.net)
Guardian of DBD::Informix -- see http://www.perl.com/CPAN
#include <disclaimer.h>