Re: Newbie Questions

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".)