Re: Date in External Stored Procedure not as expected...

On 02-Feb-2012 11:18 , Robert Rogerson wrote:

On 2012-02-02 1:34 PM, CRPence wrote:

Maybe iNav database run SQL feature "helps" by passing NULL or
DEFAULT as the argument? That "help" may be a side effect of the
capability provided to deal with INOUT and OUT parameters.

I will modify the code to handle this problem/feature.

FWiW: If no specific documentation can be found to suggest that the side effect is intended, then there may be value [for you, and others] if someone affected would ask IBM to provide either a doc reference to explain that as the expected behavior [and why] or an APAR in which the outcome is documented as an [un]intended effect. I did not look for any docs about that feature, for how the CALL arguments are handled via the iNav database RunSQL.

Regards, Chuck