Rob,
Additional Message Information
Message ID . . . . . . : CPD439A Severity . . . . . . . : 40
Message type . . . . . : Diagnostic
Date sent . . . . . . : 09/25/19 Time sent . . . . . . : 08:57:10
Message . . . . : Parameter 1 of function DECRYPT_CHAR not valid.
Cause . . . . . : Parameter 1 specified in function DECRYPT_CHAR is not
valid for use for reason code 8. The reason codes and their meanings follow:
1 -- Parameter must be a string constant.
2 -- Parameter must be an integer constant.
3 -- Parameter must be a numeric constant.
4 -- Parameter's length is too long.
5 -- Parameter's value is out of range.
6 -- Parameter must be a valid CCSID.
7 -- Parameter cannot be a parameter marker.
8 -- Parameter's data type is not supported by the built-in function.
9 -- Parameter cannot reference a column with an active column mask since
More...
Press Enter to continue.
F3=Exit F6=Print F9=Display message details
F10=Display messages in job log F12=Cancel F21=Select assistance level
and
Additional Message Information
Message ID . . . . . . : SQL0171 Severity . . . . . . . : 30
Message type . . . . . : Diagnostic
Date sent . . . . . . : 09/25/19 Time sent . . . . . . : 08:57:10
Message . . . . : Argument 01 of function DECRYPT_CHAR not valid.
Cause . . . . . : The data type, length, or value of argument 01 of function
DECRYPT_CHAR specified is not valid.
Recovery . . . : Refer to the DB2 for IBM i SQL Reference topic collection
in the Database category in the IBM i Information Center for more
information on scalar functions. Correct the arguments specified for the
function. Try the request again.
Bottom
Press Enter to continue.
F3=Exit F6=Print F9=Display message details
F10=Display messages in job log F12=Cancel F21=Select assistance level
These errors occur at runtime, not at compile-time, and only on the V7R3 system that is "behind" on PTFs.
Mark
On Wednesday, September 25, 2019, 8:48:04 AM EDT, Rob Berendt <rob@xxxxxxxxx> wrote:
If you look at the joblog, what is the error in your joblog? The return code is critical.
Rob Berendt
As an Amazon Associate we earn from qualifying purchases.