Re: Reg: Encrypt/Decrypt Image in IBMi

The current proper name for IBM i database is "Db2 for IBM i", or
shortened, simply Db2.

--
Jim Oberholtzer
Chief Technical Architect
Agile Technology Architects


On Fri, Jul 29, 2022 at 6:52 AM Gad Miron <gadmiron@xxxxxxxxx> wrote:

Just wondering

If you need to save the document for keeps,
why not store it permanently in a Blob field in the DB?
(the last I heard it was called DB2/400)

When needed, extract it (using SQL) to a temp dir in the IFS and let the
user open it.


My 2cnts

Gad

date: Thu, 28 Jul 2022 06:23:33 +0200
from: Daniel Gross <daniel@xxxxxxxx>
subject: Re: Reg: Encrypt/Decrypt Image in IBMi

Sure ?

Alternative 1: read the IFS file with SQL into a BLOB field - encrypt and
write it out with SQL again

Alternative 2: read the IFS file with IFS APIs - encrypt and write it out
with IFS APIs.

With SQL there is the chance that you can also do the encryption with SQL
- if the algorithm is supported.

HTH and kind regards,
Daniel

Von meinem iPhone gesendet

Am 28.07.2022 um 04:02 schrieb Suren K <suren7437@xxxxxxxxx>:

?Hi All,

Is it possible to encrypt/decrypt (Qc3EncryptData/Qc3DecryptData) an

image

(Student Photo/ Drivers License) in rpgle and store the encrypted image

in

IFS?

Regards,
Suren
--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription

related questions.

Help support midrange.com by shopping at amazon.com with our affiliate

link: https://amazon.midrange.com

--
This is the RPG programming on IBM i (RPG400-L) mailing list
To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/rpg400-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: https://amazon.midrange.com