All,

Is there a way to make a call/link to a c library function
from a stored procedure?

I don't want to run the system command from inside the
procedure to execute an external shell...If at all possible.

I'm running Informix 10.00

Thank in advance for your time.
Steve

Hi Steve,

What you can do is to create a "User Defined Routine", stored procedure or function, invoking an "External Routine"

The principle is to refer to an "external name" pointing to the fullpath of a .so file ( C source compiled as shared library ). The same mechanics works with java archive files.

This should work in IDS 10.0. check your product documentation at "Programming/SQL/Guide to SQLyntax/Other syntax segments/External routine reference"

I also recommend to read this excellent post at oninit's blog site
who should make you happy.

Hope this helps

Eric

Thanks for the info Eric,

That's exactly what I was looking for!

-sb