Fully Qualified Table Names in a Stored Procedure

[acarruth]

Hi there,


I'm fairly new to Progress, but after scouring the manuals and Internet, I'm hoping someone here can help.

I'm trying to implement a very simple stored procedure. All the procedure does is

SELECT * FROM "DB100"."PUB"."TESTTABLE"​

From the command-line sqlexp, this query works fine (it only works if I fully qualify the table name with double quotation marks, as above). However, when I try to insert this into a stored procedure declaration, if fails. Here is the body:

CREATE PROCEDURE testproc()​

BEGIN​

SQLIStatement stmt = new SQLIStatement("SELECT * FROM TESTTABLE" );​

stmt.execute();​

END​

When I attempt to execute the above, it returns with:

=== SQL Exception 1 ===​

SQLState=HY000​

ErrorCode=0​

[DataDirect][OpenEdge JDBC Driver]Invalid SQL specified.​

=== SQL Exception 1 ===​

SQLState=HY000​

ErrorCode=-20024​

[DataDirect][OpenEdge JDBC Driver][OpenEdge] Sorry, operation not implemented yet (7484)​

Does anyone know how to enter in fully qualified table names into the Java string here? I tried

SQLIStatement stmt = new SQLIStatement("SELECT * FROM \"DB100\".\"PUB\".\"TESTTABLE\"");​

but that returns the same error. Or, is there something else going on here that is preventing me from running this simple piece?

Any help would be much appreciated!
Thanks!
Allan