Re: Calculate MD5 Hash for Stream File

[Brad Stone <bvstone@xxxxxxxxx>]

Also, are these V7R4 only?   It looks to be.

On Thu, Dec 31, 2020 at 10:35 AM Brad Stone <bvstone@xxxxxxxxx> wrote:

> 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