http://www.informixfaq.com/wiki/ 2010-02-10T11:33:24-06:00 http://www.informixfaq.com/wiki/ http://www.informixfaq.com/wiki/lib/images/favicon.ico text/html 2010-02-10T11:30:06-06:00 Paul Watson http://www.informixfaq.com/wiki/doku.php/wiki:howto?rev=1265823006&do=diff What is currently installed Check out the $INFORMIXDIR/etc/*cr files, this will list the various products and versions. The $INFORMIXDIR/etc/.snfile will also give you the installation order Tell if the Engine is offline command: onstat -u INFORMIX-OnLine Version 7.14.UD2 -- On-Line -- Up 00:18:03 -- 147744 Kbytes If the words 'On-Line' do not appear in the returned line then there could be a problem. Check the log directly if the engine isn't running, otherwise use onstat -m If the engin… text/html 2010-01-26T16:24:17-06:00 http://www.informixfaq.com/wiki/doku.php/wiki:spl?rev=1264544657&do=diff Advantages of SPL * The work is done at the server so you don't have to collect a bunch of data and process it in client code. Saves bandwidth and improves performance drastically in some cases. * Permissions are the permissions of the creator of the SPL, not of the user. So you can have an SPL update a table that is normally off limits to a user. This allows a 'DBA' to set up strict rules for updating/inserting rows and codify them in an SPL. Programmers would then be required to use the … text/html 2009-09-03T07:20:40-06:00 http://www.informixfaq.com/wiki/doku.php/useful:whoswho?rev=1251980440&do=diff If you have been using IBM-Informix for a number of years then you will have noticed that certain names keep cropping up. This section aims to tell you more about them Alan Caldera Alan Caldera is currently team lead for the IBM Informix DataBlade development group and member of the IDS Architecture Board. He has over 20 years of experience in the IT industry as a software developer, database administrator and consultant. He joined the Informix Software Professional Services Organization as a…