User executes a DB2 stored procedure with input/output parameters and does not supply a value for some of the parameters. The following error is generated:
Error [39004][IBM][DB2]SQL0470N The user defined routine "7" ("specific name") has a null value for argument that could not be passed.
Error caused by database when parameters are defined as Not Null parameters in procedure code.
WORKAROUND
Parameters that are defined as Not Null parameters in procedure code need to have values when executing procedure.
Enter these parameter values when executing procedure.
© 2024 Quest Software Inc. ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center