×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
If you made a view that did a decrypt you would need to keep that view away from just any old ODBC/JDBC SQL utility command (e.g. Crystal Reports, Query) or the encryption isn't much good. Wouldn't it be safer to just decrypt on the SELECT command embedded in the application? Of course then you have the passwords in clear text in the RPG app you have to worry about so then it's off to using a keystore to encrypt the keys used to encrypt the data and of course you have a password to the keystore that should be encrypted and stored someplace other than the keystore so in comes TrueCrypt on a PC which has a password which should be stored in an encrypted database ... In logic class we called this an endless loop :)
-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx] On Behalf Of rob@xxxxxxxxx
Sent: Tuesday, March 25, 2008 4:16 PM
To: RPG programming on the AS400 / iSeries
Subject: RE: _cipher API vs Qc3Encrypt/Qc3DecryptData vs SQL
<snip>
and so you would still need application awareness to decrypt the data.
</snip>
That's what a view is for. ;-)
Rob Berendt
--
Group Dekko Services, LLC
Dept 01.073
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com
--
This is the RPG programming on the AS400 / iSeries (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at
http://archive.midrange.com/rpg400-l.
midrange.com
