skchonghk
Last Activity: Oct 31 '07, 01:40 AM
Joined: Jan 18 '07
Location:
-
SELECT procschema, procname FROM syscat.PROCEDUR ES;... -
Execute "values current schema" SQL statement with the connection. The resultset will have the current schema.Leave a comment:
-
Call stored proc from sql statement as subquery
As title. Is it possible?
Thanks.
Adrian -
Your guess is right. Execute this SQL statement before any others:
set schema XXXXXX, where XXXXX is the schema name.
However, if the new schema and the old schema have objects of the same name, it will take the original schema as default. So prefixing the object name in SQL statement should be a better approach actually.
AdrianLeave a comment:
-
How to open cursor to the resultset returned by stored procedure?
Dear Experts,
In a table UDF, do you know how to open cursor to the resultset returned by stored procedure?
Thanks!!! -
Can't load java class of Java UDF
Dear all smart experts,
I write a simple Java UDF, which should run on DB2 v8 on AIX. But it can't load the Java class. Help ugently needed!! Thanks!
I develop and deploy the Java UDF with these steps:
1. Write the java class, compile and make a jar (see below for source).
2. Call SQLJ.REPLACE_JA R ('file:/home/pws01ta/pws01ta1/examples.jar',' test',0)
3. call sqlj.refresh_cl asses()
...
No activity results to display
Leave a comment: