Re: Many, many, columns in a query ...

twarfield@vnunet.clark.net (Tom Warfield) wrote: >Hi. I hope some of you Informix gurus can help me come to a decision. [SNIP - can't say too much about the performance issues...I only have one site which has a >100 column select, and that seems to run great] >Finally, how much work is it going to be to translate all my scripts & >stored procedures into Informix-ese? It depends - I understand that Sybase's ANSI standard (?) allows 30-character table names, Informix's ANSI standard allows only 18. Also, Sybase triggers appear to be a lot more programmable than Informix's - hence there could be a *lot* of manual recording. Good thing there are such clear standards, eh? :) >So, should we switch? But of course.... :) HTH. -- Cheers, Billy ----------------------------------------------------------------------------- INCLUDE "Disclaimer.4gh" -- my opinions are INCLUDE "FlamesToDevNull.4gh" -- flamers, eat my shorts! INCLUDE "CaveatEmptor.4gh" -- take my advice at your own risk INCLUDE "ThirtySomething.4gh" -- header file for this class -- Written by : Billy Wheeler, Date: today -- Copyright (c) 1995, The West Solutions Group