Stored Procedure

Im not sure how your doing it but I always need to write the query as
"Select * from Openquery(Vantage,'Select * from pub.part') as tblPart

Where "Vantage" is, put the name of your linked server that you set up.

Hope that helps,

[Non-text portions of this message have been removed]
I have created a simple stored procedure through SQL Explorer.
When I am running "SELECT * from sysprogress.sysprocedures" I can see
the procedure is there.

Now when I call the procedure, "call getcustname();" I am getting:

== SQL Exception 1 ===
[JDBC OpenEdge Driver]:Failed during dynamic load of Java dynamic
library. Reason = [126]The specified module could not be found.

The procedure is below:

Create Procedure getCustName ()
StringBuffer strName = new StringBuffer (50) ;
SQLCursor name_cursor = new SQLCursor("Select Name From pub.Customer ")
while (name_cursor.found ())
strName = (StringBuffer) name_cursor.getValue(1, CHAR);
name_cursor.close () ;

Any help is appreciated