Could you not dynamically set the schema in you ODBC Connection?


Thanks,

Mark


Mark Walter
Sr. Programmer/Analyst
Hanover Wire Cloth a div of CCX, Inc.
mwalter@hanoverwire.com
http://www.hanoverwire.com
717.637.3795 Ext.3040



                    "Mike Naughton"
                    <mnaughton@juddwir        To:     domino400@midrange.com
                    e.com>                    cc:
                    Sent by:                  Subject:     CHGLIBL for QNOTES
                    domino400-admin@mi
                    drange.com


                    09/19/01 04:54 PM
                    Please respond to
                    domino400






We are developing a Notes/Domino application that interacts with AS/400
data. The Domino app uses stored procedures to call RPG programs, which
then do various things. These RPG programs seem to run using the user
profile QNOTES.

My question is: is there a way to control the library list in which these
jobs run? Basically, in the plain-old AS/400 world, we have a production
environment and a test environment. Normally, we want QNOTES (or maybe I
should say the Domino apps) to point to production, but if we're
developing something new we'd like to be able to run it in test (test
versions of programs using test data). Is there a way to do this? Our best
solution so far is to pass a parm to the program that tells it which
environment to run in, and then adjust the library list in each program
based on that parm, but we're wondering if there is a better (e.g. more
global) way.

TIA,

Mike Naughton
Senior Programmer/Analyst
Judd Wire, Inc.
124 Turnpike Road
Turners Falls, MA  01376
413-863-4357 x444
mnaughton@juddwire.com

_______________________________________________
This is the Lotus Domino on the iSeries / AS400 (DOMINO400) mailing list
To post a message email: DOMINO400@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/domino400
or email: DOMINO400-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/domino400.







As an Amazon Associate we earn from qualifying purchases.

This thread ...


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

This mailing list archive is Copyright 1997-2022 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.