473,321 Members | 1,916 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

SQL2k UDF's and Stored Procedure

hey does anybody know what are these in UDF's in SQL2k?
when to use UDF's and when to use Stored procedures
are they dependent?
where i will get information on this topic
please let me know
thanks and regards
hrishikesh
*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 20 '05 #1
2 1833
On 05 Nov 2003 09:51:02 GMT, hrishikesh musale
<mu*****@mahindrabt.com> wrote:
hey does anybody know what are these in UDF's in SQL2k?

You use UDFs to return a "computed" result per row of a query. You use
stored procedures to return a single set of data. They really have
different uses; stored procedures are much more akin to what
relational databases are for.

The typical use I've had for UDFs is to perform row-based calculations
based on data lookups. For example, if you have a table that stores
shift begin and end times per line, you could create a UDF to look up
the shift of any data based on the record entry time and the line ID,
and use that in your stored procedure. This would be very There are
other uses along these lines.
--
to replay by email, chop off the head!
Jul 20 '05 #2

Thanks a lot for giving prompt reply
you mean UDF's are used in Stored procedures(or independently also)and
they are mainly for computing things(per row)
Thanks again
hrishi

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Jul 20 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: Steven Ensslen | last post by:
Hi All, I have an application that reads data from a very slow database link (like 10 seconds per call) though what I am looking for would be of generic use for anyone who has long-running...
9
by: Evgeny Gopengauz | last post by:
Please, explain me, why INSERT / UPDATE / DELETE with global tables and EXEC (any modifications of the global tables) are prohibited in the user-defined function? On my point of view UDF is the...
4
by: Abram Friesen | last post by:
Hi all, I'm a newbie at DB2 and trying to create a simple java UDF. When I call my function, I'm receiving SQL4306N. Could someone please tell me what I'm doing wrong here? Here is my java...
7
by: Yaro | last post by:
Hello Is it possible using dynamic SQL in UDF? In Sybase below example work but in DB2 UDB 8.1.3 I get error: "SQL0104N Unexpected element "EXECUTE IMMEDIATE" found....." CREATE FUNCTION...
7
by: Rhino | last post by:
Since I haven't been able to find out yet how to get my Eclipse debugger to step through my Java UDF code, I am adding old-style File I/O debugging to some of my UDFs. I'm not sure of the best way...
3
by: Michael Rechberger | last post by:
Hey I am studying DB2 right know and trying to make some things to work. I noticed that I might understood some things wrong. Could you help me clarify a bit? That's what I wanted to do: A...
6
by: Rhino | last post by:
I'm trying to debug a simple Java UDF written in the DB2General style within Eclipse. I'm getting a java.lang.UnsatisfiedLinkError when I execute the set() method in the UDF. I know that the...
11
by: Mahesh S | last post by:
Hi I recently wrote a user defined function in SQl to run in db2 and it works fine. But I seem to get a warning saying that the performance is sub-optimal. Here is the warning message: ...
1
by: okonita | last post by:
Hello all, I have a Java problem that I hope can be answered here. Very new to DB2 UDB and UDF (we are on DB2v9.5, Linux and Windows), I have managed to get the UDF registered but having problem...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.