DB2 Stored Procedure Migration

I. Exporting stored procedures

EXPORT to D:/procudure/procudure.del of Del MODIFIED by Lobsinfile
SELECT ' SET current SCHEMA ' | | RTrim (procschema) | | ' @ ' | | Chr (10) | | SET current PATH = Sysibm,sysfun,sysproc, ' | | RTrim (procschema) | | | Chr (10) | | text| | Chr (10) | | @ ' | | Chr (10)
From syscat.procedures WHERE procschema = ' ILS ' ORDER by Create_time;

Executing the above export statement is to export the schema as a stored procedure under ILS as a file, because there is an order by create_time, so the order of the export is established in the order of the original stored procedure.

You're done, you should see two files in G:/procudure.

1. Procudure.del

2. Procudure.del.001.lob

Ii. Importing stored Procedures

The next step, of course, is to import the stored procedures under other DB:

1. Enter the directory where the stored procedure is located under the command line

2. Connect to the Db:connect to CMDB user xxx using XXX for import

3. DB2 [email protected]-VF Procudure.del.001.lob

DB2 Stored Procedure Migration