Re: Check digit calculation/validation in SQL

I would create a UDF with an RPG program to do the checks. Sounds like you already have the logic in RPG.

Roger Harman
COMMON Certified Application Developer - ILE RPG on IBM i on Power

 
 




From: MIDRANGE-L <midrange-l-bounces@xxxxxxxxxxxx> on behalf of Alan Shore <ashore@xxxxxxxx>
Sent: Tuesday, February 28, 2017 6:03 AM
To: Midrange Systems Technical Discussion
Subject: RE: Check digit calculation/validation in SQL
 
Hi Rob
Thanks for the reply
Did you read what was in your answers
The vast majority of them deal with the modulus as in a divided by b

Alan Shore
E-mail : ASHORE@xxxxxxxx
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
'If you're going through hell, keep going.'
Winston Churchill

-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Rob Berendt
Sent: Tuesday, February 28, 2017 8:48 AM
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Subject: Re: Check digit calculation/validation in SQL

I googled for
modulus 10 sql
and got a bunch of hits.

Gee can we now have a debate on the merits of mod 10 vs mod 11?  :-)


Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1 Group Dekko Dept 1600 Mail to:  2505 Dekko Drive
          Garrett, IN 46738
Ship to:  Dock 108
          6928N 400E
          Kendallville, IN 46755
http://www.dekko.com





From:   Alan Shore <ashore@xxxxxxxx>
To:     "midrange-l@xxxxxxxxxxxx" <midrange-l@xxxxxxxxxxxx>
Date:   02/28/2017 08:38 AM
Subject:        Check digit calculation/validation in SQL
Sent by:        "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



Hi everyone
Within the last month or so, I THOUGHT I read an article/e-mail on some
method of calculating check digits (Mod10 etc.) within SQL
I have searched through my saved e-mails as well as googled myself up the
kazoo
But can I find it now that I need it - nnnnnoooooooooo!!!!

If anyone else knows what I am talking about and can point me in the right
direction - it would be MUCH appreciated
Not that it makes a difference, but we are on V7r1



Alan Shore
E-mail : ASHORE@xxxxxxxx
Phone [O] : (631) 200-5019
Phone [C] : (631) 880-8640
'If you're going through hell, keep going.'
Winston Churchill