By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,230 Members | 1,473 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,230 IT Pros & Developers. It's quick & easy.

How do I get DDL for a UDF?

P: n/a
There's some user defined functions in a database that's being
migrated.

We can't just restore the database to the new server for a number of
reasons that I can't go into here. However, I can't see how to get the
definition of the UDFs out to recreate on the new server. Would
db2look do that?

If it can, and given I've got 800 tables in one schema and I only
really want the DDL for one UDF that happens to be in the same schema
as that, rather than all the DDL for every table and anything else in
there, is there an option to reduce the output to what I want?

Sep 14 '06 #1
Share this Question
Share on Google+
1 Reply


P: n/a
James Conrad StJohn Foreman wrote:
There's some user defined functions in a database that's being
migrated.

We can't just restore the database to the new server for a number of
reasons that I can't go into here. However, I can't see how to get the
definition of the UDFs out to recreate on the new server. Would
db2look do that?
Yes, db2look can generate the CREATE FUNCTION statements for you.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Sep 14 '06 #2

This discussion thread is closed

Replies have been disabled for this discussion.