Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to invoke an UFD in SQL query

Status
Not open for further replies.
dnagaraj

dnagaraj

Programmer
Mar 20, 2005
1
US
Hello,
I am new to DB2, I am trying to call an UDF inside of SQL query statement. For some reason or so i am not able to call UFD as column value.

SQL query

"select column1, column2, library.function(column1) from library.Tablename"


Thanks for any help
-Deepak
 
Sort by date Sort by votes
Are using your UDF with the same user as you created the UDF?

Salih Sipahi
Software Engineer.
City of Istanbul Turkey
s.sipahi@sahinlerholding.com.tr
turkey_clr.gif
 
Upvote 0 Downvote
To clarify, pls paste here your CREATE FUNCTION statements.
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

C
  • Locked
  • Question
STRDBG not bringing up options to set breakpoints
Replies
10
Views
283
chuckw0325
C
tekpr00
  • Locked
  • Question
Adding storage to DB2 PureScale Cluster
Replies
0
Views
305
tekpr00
tekpr00
gdg1976
  • Locked
  • Question
db2 sql extract double rows (different in case sensitive) 1
Replies
6
Views
252
mikrom
mikrom
MichaelDe
  • Locked
  • Question
SQL Update with File Join
Replies
10
Views
1K
MichaelDe
MichaelDe
MohanV
  • Locked
  • Question
Using table functions in Query
Replies
5
Views
229
fredericofonseca
fredericofonseca

Part and Inventory Search

Sponsor

Back
Top