Welcome to dbFreaks.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Set Encryption password and SQL20143N

 
   Database Help (Home) -> DB2 RSS
Next:  Tiered Commission Calculation  
Author Message
Jon.Hakkinen

External


Since: Sep 29, 2008
Posts: 5



(Msg. 1) Posted: Fri Oct 17, 2008 8:35 pm
Post subject: Set Encryption password and SQL20143N
Archived from groups: comp>databases>ibm-db2 (more info?)

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?

thanks!

 >> Stay informed about: Set Encryption password and SQL20143N 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
db2stop and db2start require password in partition env - Hi! I'm trying to set up a database instance on a prime Linux server, using db2 V9.5 with fixpack 1 applied. I issued db2set DB2RSHCMD=/usr/bin/ssh After adding 2 partitions, when issuing db2stop (as instance owner), I have to give the password 6 times...

DB2 UDB LUW 8.2:clp 32 bit connect to 64 bit engine - Environment: DB2 UDB LUW (AIX) 8.2 Database instance: test migration to 64 bit Clients: 32 bit, embedded sql, db2 clp When PATH/LIBPATH point to the 32 lib environment (/usr/opt/db2_08_01/bin and (/usr/opt/db2_08_01/lib) db2..

How to reterive the last 5 records in a table? - Hi I have a table which contains number of rows. I want to fetch the last 5 records from the table. I know for the first 'n' records we can use FETCH FIRST n ROWS ONLY command. But i want to fetch last 5 records. Can any one help in this... ..

"FIND" command is narrowed - In the ISPF editor I am using, for a particullar PO Dataset I am getting the result of FIND statement narrowed down to the colums 48-56. i.e. if I give "FIND 'TO' ALL", the result I am getting as "CHARS 'TO' - found 239 times within colum...

Schema mapper - As do all such projects, my latest venture into DB design has grown as the user becomes more educated to his needs, the design process and the capabilities of those involved. I am looking for a tool which I can point to a db2 dub schema and get a..
   Database Help (Home) -> DB2 All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]