Stored Procedure

Yahoo Archive
1
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,
Jeremy


[Non-text portions of this message have been removed]
2
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 ===
SQLState=HY000
ErrorCode=-210022
[JDBC OpenEdge Driver]:Failed during dynamic load of Java dynamic
library. Reason = [126]The specified module could not be found.
[jvm].


The procedure is below:


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


Any help is appreciated