Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

checksum or MD5 on columns

2 posts in General Discussion Last posting was on 2011-11-10 13:20:52.0Z
checksum or MD5 on columns Posted on 2011-11-09 02:24:44.0Z
Sender: 1223.4eb9e2ba.1804289383@sybase.com
From: checksum or MD5 on columns
Newsgroups: sybase.public.iq
Subject: checksum or MD5 on columns
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4eb9e46c.1272.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 8 Nov 2011 18:24:44 -0800
X-Trace: forums-1-dub 1320805484 10.22.241.41 (8 Nov 2011 18:24:44 -0800)
X-Original-Trace: 8 Nov 2011 18:24:44 -0800, 10.22.241.41
Lines: 7
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4416
Article PK: 246556

in sybase IQ, is there a function which would take a string
and calculate the MD5 or checksum 32bit value so, i can
store it in a column?

is there an example on syntax of such function?

thanks.


Roland Posted on 2011-11-10 13:20:52.0Z
Sender: 60cc.4ebbce74.1804289383@sybase.com
From: Roland
Newsgroups: sybase.public.iq
Subject: Re: checksum or MD5 on columns
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4ebbcfb4.60fe.1681692777@sybase.com>
References: <4eb9e46c.1272.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 10 Nov 2011 05:20:52 -0800
X-Trace: forums-1-dub 1320931252 10.22.241.41 (10 Nov 2011 05:20:52 -0800)
X-Original-Trace: 10 Nov 2011 05:20:52 -0800, 10.22.241.41
Lines: 11
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.iq:4418
Article PK: 246557


> in sybase IQ, is there a function which would take a
> string and calculate the MD5 or checksum 32bit value so, i
> can store it in a column?
>
> is there an example on syntax of such function?
>
> thanks.

SELECT hash('testing','sha1')
SELECT hash('testing','md5')
May well perform slow (ASA function).