Re: Is is possible to Save/Restore SQL Stored procedures from one system to another

To generate the statement:
Right Click on the procedure (in QGPL)
From the context menu select Generate SQL.
On the Generate SQL window make sure that Open in Run SQL Scripts is
selected.
When the Run SQL Scripts session opens select Connection->Connect to
Database and select the target system.
Make any changes to the script that are required and then run the script.

You may also save the script in a file for later reuse.

HTH,

Robert Rogerson
On 19/10/2011 1:23 PM, John.BresinaJr wrote:

We are doing a Hardware upgrade from an 840 to Power6 560 and upgrading the OS from V5R4 to 7.1. The users have been testing all applications successfully except one external interface was receiving a Error: [DB2/400 SQL]SQL0204 - X09031SPS in QGPL type *N not found. After talking with the application support staff and not finding the object on the OLD and NEW systems I discovered it was a Stored procedure. I then looked in iSeries Navigator > Databases > Our System > Schemas > QGPL> Procedures and there it was. Is it possible to Save/Restore the stored procedures? Do I have to using navigator generate the SQL and rerun it on the new system? If so, I have never attempted this before, how?

John

John Bresina Jr | Sr Engineer | TTS Server Tech VOC HQ | *Target | 33 S 6th St | Minneapolis, Mn 55402 | 612 304 3665 (ph)