Hi All:

I'm learning db2 (migrating from PostgreSQL). I have a quick question
about backing up stored procedures (SQL Only).

I've created a DDL file using db2look and after reviewing the output, I
can see where it defines the "CREATE PROCEDURE", but I don't see the
actual definition of the stored procedure.

Can someone point me in the right direction to backup a SQL Stored
Proccedure.

Thanks,
Barry

BarryS wrote:
> Hi All:
>
> I'm learning db2 (migrating from PostgreSQL). I have a quick question
> about backing up stored procedures (SQL Only).
>
> I've created a DDL file using db2look and after reviewing the output, I
> can see where it defines the "CREATE PROCEDURE", but I don't see the
> actual definition of the stored procedure.
>
> Can someone point me in the right direction to backup a SQL Stored
> Proccedure.

SQL Stored Procedures are backed up as part of a normal database backup
(i.e. BACKUP DATABASE).

If you just want to extract the text, see the column TEXT in
syscat.procedures.

you can also have a look at "GET ROUTINE" and "PUT ROUTINE" statements
to export and import SQL procedures in binary format.

refer to documentation for further details...

regards,
dotyet

dotyet wrote:
> you can also have a look at "GET ROUTINE" and "PUT ROUTINE" statements
> to export and import SQL procedures in binary format.
>
> refer to documentation for further details...
>
> regards,
> dotyet
>

Perfect. Thanks to both of you...

-Barry