Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Obnoxio The Clown — — source: Informix-list mailing list archive (1991-1998)
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.