Re: AW: DB2 Stored Procedures

[CRPence <CRPbottle@xxxxxxxxx>]

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