Prasad,
when you say that it isn't working "from ETL" does that mean from DataStage? Which stage and and how are you calling the SQL? It might be that you are doing a second encryption by misteak <sic>.
Encryption/Decryption
Moderators: chulett, rschirm, roy
Data Encryption/DeCryption
Hi Kumar,kumar_s wrote:Hi Prasad,
Not necessary to post twice, Pls delete the other post.
Sure. Next time, i will try not to post twice.
Thanks,
Last edited by ukyrvd on Thu Mar 30, 2006 4:25 pm, edited 1 time in total.
thank you
- prasad
- prasad
Sorry, missed copying full query. I have used the correct/balenced query:ArndW wrote:I find it odd that the encrypt has 4 parameters (unabalanced in your post) and the decrypt only 1. Is that correct?
Code: Select all
SELECT xxxx, (RPAD (xxxx, LENGTH (xxxx) + 8 - MOD (LENGTH (xxxx), 8), ' '))
FROM tablet
The query when ran @ SQL prompt working fine and encrypting the data correctly. And when we apply decrypt on that we are getting original value(space padded) back.
But when I execute from a DataStage job the encrypted text is different from what we got from the execution at SQL prompt. As a result the decrypt is not working either. The ETL job used is :
Code: Select all
OCI------------------------------------------->OCI
(select query posted earlier) (insert to table)
thanks
thank you
- prasad
- prasad