cancel
Showing results for 
Search instead for 
Did you mean: 

INFORMIX

Ricky B. Nino
Frequent Advisor

INFORMIX

Hi,

I created a STORED PROCEDURE.

I called this STORED PROCEDURE within my 4GL script.

The problem is that the STORED PROCEDURE cannot be recognize by my 4GL script.

Error message when I compile my is...

"The following errors were discovered during compilation.
/usr/ccs/bin/ld: Unsatisfied symbols:
sp_lpcnt (first referenced in pe_rpt2.o) (code)"

TIA...

Opportunities expand for people willing to put time and effort into learning new skills.
2 REPLIES
Rainer von Bongartz
Honored Contributor

Re: INFORMIX

What Informix server version ??

is your SHLIB_PATH configured correctly.


For IDS 9.3 and above it should include
$INFORMIXDIR/lib


Regards
Rainer
He's a real UNIX Man, sitting in his UNIX LAN making all his UNIX plans for nobody ...
Steve Lewis
Honored Contributor

Re: INFORMIX

You don't call a stored procedure using the CALL command, but by preparing and executing an SQL statement. e.g. I have a stored procedure called set_role()

To call it you have to do this:

define x char(2000)

let x="execute procedure set_role()"

prepare p_stmt from x

execute p_stmt

If you try to CALL stored_proc you get the error that you mentioned.