Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Nils Myklebust — — source: Informix-list mailing list archive (1991-1998)
On Mon, 17 Aug 1998 08:46:34 -0700, "Bryan Stasiuk"
<Bryan_Stasiuk(nospam)@weldwood.com> wrote:
>I'm new to the Informix brand of SQL and I have some questions that more
>experienced developers will probably be able to answer easily. I'm running
>against an Informix-SE 7.1 db on a UNIX server (don't have the O/S
>version-hopefully it's not relevant to these questions).
>
>1) Is there a (simpler) way to code a stored proc to return a multi-row
>result set **other than** using the ForEach statement?
I am not an SPL expert, but I don't know of any. To mee the foreach
doesn't seem particularly hard though.
>2) Are there any functions or subroutines to return an UPPERcase or
>LOWERcase version of a string? I checked the 7.2 manuals for
>"UPPER"/"LOWER", couldn't find anything.
Unfortunately there isn't. That's a feature of IDS 7.3 (there is no SE
7.3 i believe and I don't know when/if it will be available) and can
be done relatively easily with IDS/UDO (Universal Data Option - in 9.2
at least it will be built in).
There are however some stored procedures available that can do this.
Check the FAQ (see my signature).
Nils Myklebust
NM Data AS
Norway
E-mail: Nils.Myklebust@nmdata.com
FAQ at: http://www.iiug.org/techinfo/faq/faq_top.html
(Now with ODBC info under "Third party products".)
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.