HASH anyone?

Posted in 2010

MIKE MAGIE — Tue, 09 Feb 2010 22:00:55 — source: IIUG Forums & Mailing Lists

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

↪ replying to MIKE MAGIE

MIKE MAGIE — Wed, 10 Feb 2010 15:31:46 — source: IIUG Forums & Mailing Lists

Oh and by hash I mean encyption hash, i.e. MD5 - not any other kind of hash.

↪ replying to MIKE MAGIE

John Miller iii — Wed, 10 Feb 2010 16:22:11 — source: IIUG Forums & Mailing Lists

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. >

↪ replying to John Miller iii

Art Kagel — Wed, 10 Feb 2010 16:25:33 — source: IIUG Forums & Mailing Lists

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