Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Calling Stored Function Thru JDBC
4 views
Skip to first unread message
Brent Barker
Feb 23, 2000, 3:00:00 AM2/23/00
to
Does anybody know how to call a stored function through a JDBC connection?
The Stored Function is on the AS/400. I have it working calling a Stored
Procedure and I can have the Stored Procedure call the Stored Function, but
I just can't get it working calling the Function from Java using JDBC.
The Stored Function is on the AS/400. I have it working calling a Stored
Procedure and I can have the Stored Procedure call the Stored Function, but
I just can't get it working calling the Function from Java using JDBC.
Thanks for any ideas.
- Brent
Brent Barker
Feb 27, 2000, 3:00:00 AM2/27/00
to
Any takers on this problem?
Luther Miller
Feb 28, 2000, 3:00:00 AM2/28/00
to
Do you meanjust call the function as if it was a stored procedure, and not
as part of a SQL statement? I think you can only di this with DB2 SQL as
part of a SQL statement. For example, you can just do SELECT CURRENT USER
... you need to to do SELECT CURRENT USER FROM SOMETABLE or it will give an
error.
as part of a SQL statement? I think you can only di this with DB2 SQL as
part of a SQL statement. For example, you can just do SELECT CURRENT USER
... you need to to do SELECT CURRENT USER FROM SOMETABLE or it will give an
error.
Brent Barker <bba...@xmission.com> wrote in message
news:B4DF5FA4.2D04%bba...@xmission.com...
0 new messages