Re: Reg: Encrypt/Decrypt Image in IBMi

Hi Daniel,

Thanks a lot for helping me out.

Currently I am using the below SQL statement for fetching the image from
IFS/Windows shared drive

dcl-s Wrk_SystemImage sqltype(blob_file);
dcl-s Wrk_Image sqltype(blob:500000);
Wrk_SystemImage_FO = SQFRD;
Wrk_SystemImage_Name = ImagePath;
Wrk_SystemImage_NL = %len(ImagePath);
exec sql values :Wrk_SystemImage into :Wrk_Image;

This way I can get the image into the blob field (Wrk_Image).

To use the IBMi API encryption/decryption (Qc3EncryptData/Qc3DecryptData),
I need to send the image as an input to the IBMi API
(Qc3EncryptData/Qc3DecryptData) in the character format. Is that ok to move
the Image from a BLOB field into character field? Will this not change the
image data?

Like rpg code -> CharacterField = %trim(Wrk_Image_Data);

Regards,
Suren



On Thu, Jul 28, 2022 at 12:23 AM Daniel Gross <daniel@xxxxxxxx> wrote:

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