SEO
vBulletin Search Engine Optimization
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-27-2008, 11:30 AM
| ||||
| ||||
 iSeries Query - Code behind We have clients who have not been exposed to SQL and have built a few thousand queries using the iSeries Query tool via their 5250 sessions. Is there any way to gather the code behind these queries that they have saved? Rather than opening each of them to reverse engineer how they work and rebuild them in SQL? Thank You! Jason      |
|
02-27-2008, 11:34 AM
| ||||
| ||||
| Re: iSeries Query - Code behind On 19 Jan 2007 14:15:23 -0800, "kellyj00@gmail.com" <kellyj00@gmail.com> wrote: >We have clients who have not been exposed to SQL and have built a few >thousand queries using the iSeries Query tool via their 5250 sessions. > >Is there any way to gather the code behind these queries that they have >saved? Rather than opening each of them to reverse engineer how they >work and rebuild them in SQL? > >Thank You! >Jason If not too late: RTVQMQRY - Retrieve Query Mgmt Query The Retrieve Query Management Query (RTVQMQRY) command allows you to retrieve Structured Query Language (SQL) source from a query management query (QMQRY) object. The source records are placed into an editable source file member. this includes iSeries (As/400, i5, System i....whatever) Query. Also make sure you use ALWQRYDFN(*YES) |
Linear Mode
