Justin:

Do you have, or can you get, sufficient storage to put up a virtual
partition hosted by IBM i ? It's easy to set up, you can make it almost
any size you need, and then you have the best of worlds. (you'll also
need an HMC but I think you have one based on earlier posts)

--
Jim Oberholtzer
Chief Technical Architect
Agile Technology Architects


-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of
Justin Taylor
Sent: Friday, June 05, 2015 6:15 PM
To: MIDRANGE-L (midrange-l@xxxxxxxxxxxx)
Subject: Stored procedure test environment

We're starting to rely heavily on RPG programs exposed as DB2 stored
procedures and the time has come for an improved test environment. I don't
have a test server/partition. My plan is to create a test schema and
duplicate my stored procedures and tables there, while continuing to use the
production programs and users.

First, I'll have to set the library list. Is there a good way to do this?
My thought is to determine the schema of the stored procedure (assuming
that's even possible) and set the library list in code. Is there a better
way?

Second, I need the IP address of the caller. Currently, these are kept in
data areas by application. Is there some easy way to get the client IP for
a QZDASOINIT job?


Thanks
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe,
or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a
moment to review the archives at http://archive.midrange.com/midrange-l.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Follow-Ups:
Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.