×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
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.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.
midrange.com
