What DB2 are you using this for. If OS/390, have easy solution, just
use DSNTPSMP with edit program on source to move from one system to
another.
--- kishore lingamallu <[EMAIL PROTECTED]> wrote:
> Hi
>
> We want to move the stored procedures from one environment to other
> environments like Test to QA , QA to Pord we are encountering
> problem.
>
> The table names are completely qualified means like
> testschema.tablename in
> Test environment qaschema.tablename in QA and proschema.tablename.in
> Prod in
> the stored procedures
>
> When we want to move the SQL stored procedures from one environment
> to other
> we are facing problem because of the qualifier and we have change
> qualifier/code every time to make it environment fit. There is a
> possibility
> of human errors while doing that hence we want to avoid it.
>
> What are the best ways to make the Stored Procedures Qualifier
> independent
> or edit free while moving them from one environment to other?
>
> Any kind of suggestion is appreciated.
>
> Thank You.
>
> Kish
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com
>
>
> =====
> To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
> For other info (and scripts), see
> http://people.mn.mediaone.net/scottrmcleod
>
__________________________________________________
Do You Yahoo!?
Yahoo! Auctions - buy the things you want at great prices
http://auctions.yahoo.com/
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
