HASH anyone?
Mike Magie asked on IDS 11.5 (Solaris 10) for a built-in or existing hash function such as MD5 for use in SELECT, before writing his own UDR. John Miller III asked how that differed from column-level encryption. Art Kagel questioned looking up MD5 of plain-text columns as weird. No answer.
Auto-generated by Claude from the posts below — may be imperfect; read the full thread.
11.5 (finally)
Solaris 10
Before I start writting a UDR called hash to perform a hash on a column value;
i.e.
select col1, col2, hash(col3)
from my_tab
where col1 = X
does anyone know if there are plans for future releases to include something
like this for us? and/or does someone already have one...
MM
Oh and by hash I mean encyption hash, i.e. MD5 - not any other kind of hash.
Can you please explain the difference between what you are asking and column level encryption. John F. Miller III STSM, Support Architect miller3@us.ibm.com 503-578-5645 IBM Informix Dynamic Server (IDS) ids-bounces@iiug.org wrote on 02/10/2010 07:31:46 AM: > Oh and by hash I mean encyption hash, i.e. MD5 - not any other kind of hash. > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. >
Looking up an MD5 encrypted version of a column stored in plain text? That would be weird and less than totally secure, but... Art Art S. Kagel Advanced DataTools (www.advancedatatools.com) IIUG Board of Directors (art@iiug.org) See you at the 2010 IIUG Informix Conference April 25-28, 2010 Overland Park (Kansas City), KS www.iiug.org/conf Disclaimer: Please keep in mind that my own opinions are my own opinions and do not reflect on my employer, Advanced DataTools, the IIUG, nor any other organization with which I am associated either explicitly, implicitly, or by inference. Neither do those opinions reflect those of other individuals affiliated with any entity with which I am affiliated nor those of the entities themselves. On Wed, Feb 10, 2010 at 11:22 AM, John Miller iii <miller3@us.ibm.com>wrote: > Can you please explain the difference between what you are asking > and column level encryption. > > John F. Miller III > STSM, Support Architect > miller3@us.ibm.com > 503-578-5645 > IBM Informix Dynamic Server (IDS) > > ids-bounces@iiug.org wrote on 02/10/2010 07:31:46 AM: > > > Oh and by hash I mean encyption hash, i.e. MD5 - not any other kind of > hash. > > > > > > > > > ******************************************************************************* > > > Forum Note: Use "Reply" to post a response in the discussion forum. > > > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > --001517477faa8da7ff047f417b77