467,858 Members | 1,699 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,858 developers. It's quick & easy.

Set Encryption password and SQL20143N

Hi all,

I'm on DB2 9.5 fp 0 on Windows.
I have a simple SQL stored procedure which uses the Encrypt() function
to insert data in a table.
I do not set the encryption password inside the procedure, I plan to
issue an Set Encryption statement at the beginning of every database
session from our middle layer.

But for now I use clp or db2ce to run something like

Set encryption password = 'password';
call sp();

When trying to run it, I get
SQL20143N The encryption or decryption function failed, because the
ENCRYPTION PASSWORD value is not set. SQLSTATE=51039

Is embedding the 'Set encryption password' statement in all my sql
stored procedures the only option I have here?


Oct 18 '08 #1
  • viewed: 1952

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Reimar Bauer | last post: by
34 posts views Thread by jlocc | last post: by
3 posts views Thread by Molly Gibson | last post: by
4 posts views Thread by PJones | last post: by
25 posts views Thread by eggie5 | last post: by
reply views Thread by jack112 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.