Re: Newbie Questions

Posted in 1998

Octav Chiriac — Tue, 18 Aug 1998 10:45:53 +0300 (EETDST) — source: Informix-list mailing list archive (1991-1998)

Bryan Stasiuk 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? > Other way will be a temp table (I don't know if it's suitable for you). >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. > There are in IDS 7.3. And you could check the FAQ at iiug. As I remember there is a set of stored procedures there. >Thanks for your help (and your patience). > >Bryan Stasiuk >Weldwood of Canada Ltd. >Bryan_Stasiuk@weldwood.com > > -- Octav Chiriac Phone: (373) 2 21 20 96 NetInfo S.R.L. Fax: (373) 2 21 20 96 Chisinau (373) 2 24 00 83 Moldova, Republic of mailto:com@netinfo.moldova.net