Re: Scott's JDBCR4 program from RPG

Alan Campin wrote:

1. If the SQL Server stored procedure returns a value with a Return 0
statement in the stored procedure how do you get the value of the parameter?

Do you mean the RPG REturn op-code? Or the SQL Return statement?

An RPG return op-code can't be used from a stored procedure, it can only be used from a UDF. If you are writing a UDF, then the output it returned to an SQL statement that called the UDF (such as a SELECT statement) and you'd get the output by reading the results of that SELECT.

If it's the SQL RETURN statement, then you use the GET DIAGNOSTICS SQL statement to retrieve the result. Personally, I've never used that feature (but that's what the manual says.)

2. I am running into problems trying to call a stored procedure with
parameters coming from variables.

You didn't say what the problem is. Just that you're having problems, and that you found out that there's some sort of a bug in the service program...

Kindly tell us what the problem is, and what the bug is in the service program, and I'll see if I can help.