You were probably given APIs for decryption - there are some built around an MI function called CIPHER - I forget whether it does decryption.
For most of this you'll need the key they use on the Windows side to decrypt.
You'll likely also need to convert the decrypted values from ASCII to EBCDIC - seems I recall that early in this thread.
I just looked up CIPHER - at v5r1 there was support for encryption or decryption using DEA, TDEA, RC4, and AES.
Seems it is the same at 7.1 - there are several options for each of these.
Recent releases have DECRYPT functions in SQL - will the entire CSV file be encrypted en masse, or by individual rows? If the latter, you might be able to fit the data into a "column" and use SQL.
Just thinking off-the-cuff - now back to real work!
On 4/9/2014 3:34 PM, Jeff Young wrote:
The encryption will be done on a WINDOWS platform.
Needs to be "push-pull-click-click'
Sr. Programmer Analyst
On Wed, Apr 9, 2014 at 4:06 PM, Steinmetz, Paul <PSteinmetz@xxxxxxxxxx>wrote:
We use OpenSSH, client and server.
This does 2 things for you.
1) Encrypts the data.
2) Eliminates need for storing users and passwords.
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:
midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Jeff Young
Sent: Wednesday, April 09, 2014 10:43 AM
To: Midrange Systems Technical Discussion
Subject: Encryption methods on the i
I have a client that is presently sending files from another system (not
i) to the IFS in CSV format..
They are planning to encrypt the data prior to transmission and my program
will need to decrypt it before processing.
What encryption / decryption methods are available on the i to do this?
At this time, the client has not chosen an encryption method and they want
to ensure that the decryption process is available for the i.
At this time, they are not looking for a commercial solution, and I would
prefer a solution that could be used an ILE RPG program, or a system
Sr. Programmer Analyst
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe,
unsubscribe, or change list options,
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
This mailing list archive is Copyright 1997-2014 by MIDRANGE dot COM and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available here. If you have questions about this, please contact