Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2004
    Posts
    51

    Unanswered: IDE for UDF's in Version 7

    I can't find any IDE elements that support the CREATE FUNCTION syntax,
    AND I really don't like the CLI.

    The Stored Procedure building seems like a likely place, but it chokes on some syntaxes that should be native to UDF's so I'm pretty sure it's not the place.

    The Control Center has a fly-out for 'create' on the UDF node but in just leads to a table/column selector. That would focus on Table Udf's and I need a scalar or 'generic' UDF.

    Help again help!

    Thanks,

    Kimball

  2. #2
    Join Date
    Jan 2003
    Posts
    4,292
    Provided Answers: 5
    Kimball,
    There are none for V7. In V8 Development Center, you can do UDFs.

    You maybe able to use the V8 Development Client which includes the Development Center against your V7 server. Look here:

    http://www-106.ibm.com/developerwork...liu/index.html

    HTH

    Andy

  3. #3
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650
    Unfortunately, V8 Dev Centre does not support connections to V7 databases

    You may probably define your UDF using the interface in a V8 database and then use the SQL to create the UDF in V7 ... But, remember not to use the new V8 features

    Cheers
    Sathyaram
    Visit the new-look IDUG Website , register to gain access to the excellent content.

  4. #4
    Join Date
    Aug 2004
    Posts
    51

    Hmmm... well...

    I just decided to use a stored procedure as a 'you dee eff'.

    Thanks very much!

    And V8 does look a bunch better.

    Kimball

Posting Permissions

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