Extract text (>32500 bytes) from SYSCAT.ROUTINES

[diwakar1983]

I know we have GET ROUTINE that produces a SQL archive (SAR) which can then be used to deploy elsewhere using the PUT ROUTINE. However let's consider the stored procedure needs code change.

How do we extract the stored procedure content from SYSCAT.ROUTINES for code whose length is greater than 32500 bytes?

The db version is IBM UDB db2 v9.1.

[Rabbit]

You can't. Not through the view. You'll have to use the db2look utility. Documentation for that utility can be found here: http://publib.boulder.ibm.com/infoce...e/r0002051.htm

[vijay2082]

Hi,

There is one more quick and easy way.
db2 "export to myfile.del of del select text from syscat.routines where < your condition >"

above will export your text in clean format and you can use it wherever you want.

Cheers, Vijay

[diwakar1983]

Thanks for your replies. Appreciate it.