Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2004

    Unanswered: Dynamic sql in UDF

    Can dynamic sql be used inside the UDF or not? other wise is any way there to implement that?
    Can sql procedure be called from inside the UDF, if yes from what version.

    Please clarify these doubts.

  2. #2
    Join Date
    Jan 2005
    Provided the UDF is an external UDF (ie not LANGUAGE SQL) you shouldn't have any problems.

    Unless, of course, the version of DB2 you are running doesn't support it - for example the unsupported DB2 UDB ULWO V7. But you omitted that piece of information.

    James Campbell

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts