Here is with libs:


create table jstone/fl2 (field1 char(20))
Table FL2 in JSTONE created but was not journaled.
insert into jstone/fl2 (field1) values(Encrypt_RC2('TEST','AAABBB'))
1 rows inserted in FL2 in JSTONE.
select decrypt_char(field1,'AAABBB') from jstone/fl2
Argument 01 of function DECRYPT_CHAR not valid.

Additional Message Information

Message ID . . . . . . : SQL0171

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 UDB for iSeries SQL Reference topic in
the Information Center for more information on scalar functions. Correct the
arguments specified for the function. Try the request again.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Chris Bipes
Sent: Friday, April 27, 2012 1:30 PM
To: 'Midrange Systems Technical Discussion'
Subject: RE: SQL encryption v5r4 error

In your original insert into you qualified the file with the library. Is you library list correct?

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2019 by and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].