Re: Calculate MD5 Hash for Stream File

[Brad Stone <bvstone@xxxxxxxxx>]

Thanks,  Birgitta.  Sorry for being an SQL dunce with these functions, but
how would you enter that into SQL command line to test it?  I always forget.


On Thu, Dec 31, 2020 at 8:59 AM Birgitta Hauser <Hauser@xxxxxxxxxxxxxxx>
wrote:

> SQL can do it!
> It may only depend on the release and/or Technology Refresh you are on.
> The following SQL Statement will calculate the MD5 or an IFS File.
>
> Values(HASH_MD5(Get_Clob_From_File('/home/Dir1/Dir2/YourIFSFile.txt')));
>
> Mit freundlichen Grüßen / Best regards
>
> Birgitta Hauser
>
>
> "Shoot for the moon, even if you miss, you'll land among the stars." (Les
> Brown)
> "If you think education is expensive, try ignorance." (Derek Bok)
> "What is worse than training your staff and losing them? Not training them
> and keeping them!"
> „Train people well enough so they can leave, treat them well enough so they
> don't want to.“ (Richard Branson)
>
>
> -----Original Message-----
> From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxxxxxxxx> On Behalf Of Brad
> Stone
> Sent: Donnerstag, 31. Dezember 2020 15:43
> To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxxxxxxxx>
> Subject: Calculate MD5 Hash for Stream File
>
> anything new in the realm of generating an MD5 hash for a stream file in
> the
> IFS?
>
> It looks like openssl may be the easiest... then just output the data to a
> stream file and read it in?
>
> Wanted to make sure there weren't any SQL functions that may make it easier
> and avoid needing to read in and parse a stream file.
>
> Bradley V. Stone
> www.bvstools.com
> Native IBM i e-Mail solutions for Microsoft Office 365, Gmail, or any Cloud
> Provider!
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx To subscribe,
> unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives at
> https://archive.midrange.com/midrange-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 Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-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