469,299 Members | 2,066 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,299 developers. It's quick & easy.

UDFs (written in C)

The developer rewrote one C program. So I need to replace the current
library, drop and recreate the UDFs. I don't want to restart the db server,
I just terminate all the sessions which might call this UDF. The strange
thing is my query:
select udf(column) from mytbl
still gave me the result from the old library. But,
values(udf(column) show me the new result.

If they all get the old result. Then I can understand.
BTW, both sql stmts I submitted in one session. We defined the UDF as fenced
& not threadsafe, no SCRATCHPAD and keepfenced = yes (I know this might
cause problem, but again why VALUES is ok)
Nov 12 '05 #1
0 1021

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

reply views Thread by Paul | last post: by
6 posts views Thread by eugenef | last post: by
1 post views Thread by Eugene | last post: by
3 posts views Thread by David Carver | last post: by
reply views Thread by Helmut Tessarek | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by harlem98 | last post: by
1 post views Thread by Geralt96 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.