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

how to select source of procedures and functions

P: n/a
Hello!

I'm new to DB2 as you can see at the Posting-Count.

I'm not sure but I think that I read about that the Source of stored
Procedures and Functions get stored in SYS-Tables.

Is this right? How can I get back the Source of my Functions??

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
to*******@freesurf.fr wrote:
Hello!

I'm new to DB2 as you can see at the Posting-Count. Well, then so am I.... ;-)
I'm not sure but I think that I read about that the Source of stored
Procedures and Functions get stored in SYS-Tables.

The source of SQL Functions an SQL Procedures gets stored in
SYSCAT.ROUTINES.TEXT

In general you can get the DDL of your DB reverse engineered using teh
db2look application (it's in sqllib/bin and should be on your OS path I
think)

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab
Nov 12 '05 #2

P: n/a
aaaahh -ok
THX a lot!!

cu
Christian

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.