• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

References to a function (UDF) in SQL Server

 
nitinram agarwal
Ranch Hand
Posts: 90
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,
I am working on a project which is currently heavily db based and I want to pull out some of the processing from DB side to the Java side. I am trying to understand as to how should I start the work. I am planning to first start identify UDF (user defined function ) which are there in the db and move the logic to Java side if possible.
However I need to also correct the dependent object (which use these UDFs). Is there a way to identify where and all a UDF is getting used (something similar to reference menu in Eclipse) . I am using SQL server for my work.

Regards,
 
E Armitage
Rancher
Posts: 989
9
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I don't see why you need to. If a function called another function then you need to replace the calling function first unless if you are suggesting that you want to be calling the Java layer solution from the SQL functions?
 
nitinram agarwal
Ranch Hand
Posts: 90
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
I have no intention to call the Java layer from Sqls. The idea is to move the business logic away from db side. For this, I am trying to pick up those units which can be migrated easily. A UDF and references to it , is the first point I want to start with. For example, if a UDF is called from 2 pl-sql routine and the logic in UDF can be replaced by Java code then modify the pl-sql routine so as to remove the reference to UDF and do some application rewrite on Java (kind of util ) which mimics the behavior of UDF. As a second stage , check if we can replace pl-sql routine with Java code. Please let me know if you need any other details.
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic