|
Alan Campin wrote:
1. If the SQL Server stored procedure returns a value with a Return 0parameter?
statement in the stored procedure how do you get the value of the
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 is the RPG programming on the IBM i / System i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/rpg400-l.
As an Amazon Associate we earn from qualifying purchases.
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.