Dj wrote:
If you passed all of the fields as one group level when you rejester the SP
you would only be able to use one CHAR field. Now here is the rub. If you
are passing mix data, why not send it in the smallest network transaction
possible. Also why not have DB2 validate each parameter. This should be a
must so the SP knows that data type has already passed DB2 validation
requirements.
Thanks for your response, Dj.
The stored procedure is set up and working in a production environment.
The SP is set to receive five 01 level parameters. The caller passes
these five parameters using one group level item. I am concerned because
the system where these types of calls are located is having data
inconsistency problems. In addition, I have not seen any other examples
of this type of parameter passing. These calls, as far as I know, are
not generating SQL errors. However, I am concerned that passing
parameters this way may hide problems. For instance, would the 05 level
parameters from the caller match up internally with the 01 levels of the SP?
Thanks again, Dj.
John