AW: store procedure - parameter passing

Attention! 

Overloading means, that the same procedure can exist with a different number
of parameters in the same schema.
But these procedures are different programs that can do something completely
different.

For Stored Procedures only the number of parameters and the data types are
checked, but not the length. 
Also compatible data types (such as Decima, Integer) can be passed for
numeric fields, and CHAR(), VARCHAR(), GRAPHS() can be passed for character
fields. The length of the parameters is not checked.

For User Defined Functions, overloading is slightly different. In the same
schema several UDFs with the same name can coexist, 

Mit freundlichen Grüßen / Best regards

Birgitta Hauser

"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)

"If you think education is expensive, try ignorance." (Derek Bok)

"What is worse than training your staff and losing them?  Not training them
and keeping them!"



-----Ursprüngliche Nachricht-----
Von: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] Im
Auftrag von rob@xxxxxxxxx
Gesendet: Thursday, January 25, 2007 19:00
An: RPG programming on the AS400 / iSeries
Betreff: Re: store procedure - parameter passing


Pretty sure you do.  Stored procedures support "overloading".  You can 
have the same procedure, with the same name, out there multiple times. The 
differentiator being the parameters.  It would be like having an RPG 
subprocedure called AddDaysToDate and automatically determining on the 
type of the first parameter if you are working with character, numeric, 
true dates, etc.

Rob Berendt