Encryption

[Chris.Sharman@ccagroup.co.uk]

>We are considering using the ENCRYPT/DECRYPT functions in an application.
>Do any of you have any experiences, suggestions or pitfalls that we need to
>hear about?

*Don't* follow the recommendation in the manuals to use ENCRYPT(CHARACTERS())
to encrypt numeric/date data. Cognos provide _no_ way to get the data back
again: there's no reverse of the characters function.

*Don't* plan on compatibility with 3GL code: Cognos don't publish their
algorithm (whether because it's fairly weak or what, I don't know).
______________________________________________________________________
Chris Sharman			Chris.Sharman@CCAgroup.co.uk
CCA Stationery Ltd, Eastway, Fulwood, Preston, Lancashire, PR2 9WS.
= = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
Subscribe: "subscribe powerh-l" in message body to majordomo@lists.swau.edu
Unsubscribe: "unsubscribe powerh-l" in message to majordomo@lists.swau.edu
powerh-l@lists.swau.edu is gatewayed one-way to bit.listserv.powerh-l
This list is closed, thus to post to the list, you must be a subscriber.