Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2011
    Posts
    9

    Unanswered: Informix Stored Procedure question.

    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

  2. #2
    Join Date
    Sep 2011
    Location
    Pont l'Abbé, Brittany, France
    Posts
    381
    Provided Answers: 1
    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

  3. #3
    Join Date
    Jan 2011
    Posts
    9
    Thanks for the info Eric,

    That's exactly what I was looking for!

    -sb

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •