encryption functions

Posted in 2004

Topics: Connectivity: ESQL/C, 4GL & Embedded SQL, Security, Permissions & Auditing

Sudhir Sambrani — Thu, 28 Oct 2004 15:24:46 — source: IIUG Forums & Mailing Lists

Hi I am looking for some encryption function to encrypt values stored in a column does anyone know of any esql/c function which provide this Thanks Sudhir

↪ replying to Sudhir Sambrani

JHAYS2@sears.com — Thu, 28 Oct 2004 16:52:55 — source: IIUG Forums & Mailing Lists

If you are on Sun UNIX, there is a utility there to encrypt. $man encrypt C Library Functions encrypt(3C) NAME encrypt - encoding function SYNOPSIS #include <unistd.h> void encrypt(char block[64], int edflag); DESCRIPTION The encrypt() function provides (rather primitive) access to the hashing algorithm employed by the crypt(3C) function. The key generated by setkey(3C) is used to encrypt the string block with encrypt(). The block argument to encrypt() is an array of length 64 bytes containing only the bytes with numerical value of 0 and 1. The array is modified in place to a similar array using the key set by setkey(3C). If edflag is 0, the argu- ment is encoded. If edflag is 1, the argument may be decoded (see the USAGE section below); if the argument is not decoded, errno will be set to ENOSYS. "Sudhir Samb...." <sudhirsambrani@gmail.com> Sent by: forum.subscriber@iiug.org 10/28/2004 10:24 AM To: ids@iiug.org cc: Subject: encryption functions [3584] Hi I am looking for some encryption function to encrypt values stored in a column does anyone know of any esql/c function which provide this Thanks Sudhir

↪ replying to JHAYS2@sears.com

Martin Fuerderer — Fri, 29 Oct 2004 11:02:20 — source: IIUG Forums & Mailing Lists

Hi, beware that some of these algorithms are one-way encryptions, i.e. there is no decryption possible. If that is what you want, then you should be OK with things like "crypt()". BTW: the upcoming 9.50.UC1 will have new functionality for column level encryption - where decryption will also be supported. Regards, Martin -- forum.subscriber@iiug.org wrote on 28.10.2004 18:52:55: > If you are on Sun UNIX, there is a utility there to encrypt. > $man encrypt > C Library Functions encrypt(3C) > > NAME > encrypt - encoding function > > SYNOPSIS > #include <unistd.h> > > void encrypt(char block[64], int edflag); > > DESCRIPTION > The encrypt() function provides (rather primitive) access to > the hashing algorithm employed by the crypt(3C) function. > The key generated by setkey(3C) is used to encrypt the > string block with encrypt(). > > The block argument to encrypt() is an array of length 64 > bytes containing only the bytes with numerical value of 0 > and 1. The array is modified in place to a similar array > using the key set by setkey(3C). If edflag is 0, the argu- > ment is encoded. If edflag is 1, the argument may be decoded > (see the USAGE section below); if the argument is not > decoded, errno will be set to ENOSYS. > > > > > "Sudhir Samb...." <sudhirsambrani@gmail.com> > Sent by: forum.subscriber@iiug.org > 10/28/2004 10:24 AM > > > To: ids@iiug.org > cc: > Subject: encryption functions [3584] > > > Hi > > I am looking for some encryption function to encrypt > values stored in a column > > does anyone know of any esql/c function which provide > this > > Thanks > Sudhir > > > > >

Glossary

ESQL/C