Re: AW: DB2 Stored Procedures

On 11/8/10 9:17 AM, Vern Hamberg wrote:

I am convinced that you don't really have to register any existing
program - the CALL in SQL just works, no matter from where. But that
is only useful, perhaps, for things that don't return parameters or
return values or record sets. Those that maybe just perform some
operation on the server, and that is not what stored procedures are
normally used for, I think.

If you have CHAR parameters, you had better declare or register it,
so that you are aware of what you are doing - the generic "you"
<<SNIP>>

No different with CHAR than with the packed DECIMAL parameter for the program QCMDEXC; i.e. although there is positive effects for registering the procedure, there is no requirement to register, irrespective of which simple data type. In each case the caller must know and pass the appropriately typed parameters. As long as the SQL understands\promotes the data type to match [thus correctly passes] what is expected by the called program for each of the corresponding parameters coded in the called program, then an existing unregistered program could /function/ well; at least for when all of the parameters function the same as they would if declared as IN [versus INOUT or OUT].

Regards, Chuck