471,895 Members | 1,988 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,895 software developers and data experts.

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 1080

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 zermasroor | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.