Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
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.