Migrating external SQL procedures from test to production
Use IBM Data Studio to migrate external SQL procedures from a test environment to production.
Before you begin
Deprecated function: External SQL procedures are deprecated and not as fully supported as native SQL procedures. For best results, create native SQL procedures instead. For more information, see Creating native SQL procedures and Migrating an external SQL procedure to a native SQL procedure.
About this task
External SQL procedures are usually built by using IBM Data Studio.
Procedure
To migrate an external SQL procedure from a test environment to production:
Use IBM Data Studio to deploy the stored procedure.
The binary deploy capability in IBM Data Studio promotes external SQL procedures without recompiling. The binary deploy capability copies all necessary components from one environment to another and performs the bind in the target environment.
