View previous topic :: View next topic
|
Author |
Message |
sun_job
New User
Joined: 18 Sep 2007 Posts: 73 Location: Bangalore
|
|
|
|
Hi All,
Request all veterans help in the below case.
The requirement is to encrypt confidential data in the Db2 tables. The confidential would include:
PO Number
Customer
Amount
Just wanted to know , is there any JCL or process to do the same.
I understand that DB2 table data cannot be encrypted directly. |
|
Back to top |
|
|
gylbharat
Active Member
Joined: 31 Jul 2009 Posts: 565 Location: Bangalore
|
|
|
|
Please check ENCRYPT_TDES and DECRYPT_BINARY, DECRYPT_BIT, DECRYPT_CHAR, and DECRYPT_DB functions. |
|
Back to top |
|
|
sun_job
New User
Joined: 18 Sep 2007 Posts: 73 Location: Bangalore
|
|
|
|
Thanks will check and keep posted |
|
Back to top |
|
|
sun_job
New User
Joined: 18 Sep 2007 Posts: 73 Location: Bangalore
|
|
|
|
One more question :
Would the above listed functions encrypt/decrypt data which is already in the table? |
|
Back to top |
|
|
enrico-sorichetti
Superior Member
Joined: 14 Mar 2007 Posts: 10873 Location: italy
|
|
|
|
does anybody realise that encryption/decryption is more than plain functions calls!
for example ...
encryption/decryption need a KEY ...
what plans are in place for key management ???
just to state one of the problems to be solved |
|
Back to top |
|
|
Nic Clouston
Global Moderator
Joined: 10 May 2007 Posts: 2455 Location: Hampshire, UK
|
|
|
|
No JCL will be able to do it as that is not the function of JCL. The L may stand for Language but the JC stands for Job Control which means telling the OS what programs you want to run, in what sequence and the resources required. I do not see how you think Job Control could have anything to do with your requirement apart from telling the OS to run whatever you decide needs to be run to satisfy your requirement.
And, as you are enquiring about DB2 encryption why not post i the DB2 part of the forum - that is what it is there for! |
|
Back to top |
|
|
prino
Senior Member
Joined: 07 Feb 2009 Posts: 1306 Location: Vilnius, Lithuania
|
|
|
|
enrico-sorichetti wrote: |
does anybody realise that encryption/decryption is more than plain functions calls! |
That realisation has been outsourced by a PHB. |
|
Back to top |
|
|
|