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

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

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

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

Thanks very much!

And V8 does look a bunch better.

Kimball