Re: SPL vs Shell Scripting

From: Scott A Andrews <scott_a_andrews@yahoo.com> > >I am new to Informix and I was wanting some opinions on the pros and >cons of Informix stored procedures. > >I have a application that will need to select data from several >different tables. Do some massaging, do some looping and then insert the >results into several tables in a seperate Informix database. > >Is a task similar to this one best suited for a stored procedure or >would a shell script be more appropriate? Depends on the massaging. SPL has truly vile string manipulation "capabilities" and is revolting on things like record definition. SPs also cannot process dynamic SQL, it all has to be precompiled. But if you can live with all those warts, it should run a lot faster than dbaccess from a shell. >Your input will be greatly appreciated. That's funny, that's just what she said last night... ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com