James Dey writes:
>I forget how to export and import the DB2 stored procedures. Anybody?
If they're SQL stored procedures, then the TEXT column in SYSCAT.PROCEDURES
will contain the statement that was used to create each proc. When the
operating systems of the source and target database differ, this is pretty
much the only option, since GET_ROUTINE and PUT_ROUTINE aren't
cross-platform capable.
Hope that helps,
Fred Sobotka
IBM Certified Database Administrator - DB2 UDB V8.1 for Linux, UNIX, and
Windows
CollegeNET, Inc.
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
*** For more information, check http://www.db2eug.uni.cc
