× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.



Thanks for the reply Jerry.
That's one procedure we are exploring.
I was just curious if SQL could be used in the fashion I described.


Alan Shore

NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx

midrange-l-bounces@xxxxxxxxxxxx wrote on 12/20/2006 02:31:32 PM:

Alan,


I have a similar set-up.  Except that I refresh the Dev box nightly.  I
don't use DDM or SQL, but simply SaveFiles FTP-ed.  Takes about 30
minutes for us (ymmv) to do that at 1:30 am.


Although I don't explode the libraries at that point, it would be a
simple matter to invoke a process (RUNRMTCMD) from Prod to do that.
Just be sure that, if you do that, the procedure in the RUNRMTCMD isn't
the one that actually explodes the libraries but submits the real one to
the job queue on Dev, otherwise Prod will stay connected to Dev; i.e.,
the Production process will be an active job until the remote command
ends on Dev.


The problem that I have with automatically restoring the libraries is
errors related to journals when I clear or delete the libraries before
the restore.  Primarily, though, I don't want it to wipe out "stuff"
I've been developing and testing.


   * Jerry C. Adams
*IBM System i5/iSeries Programmer/Analyst
B&W Wholesale Distributors, Inc.* *
voice
   615.995.7024
fax
   615.995.1201
email
   jerry@xxxxxxxxxxxxxxx <mailto:jerry@xxxxxxxxxxxxxxx>



Alan Shore wrote:

Good morning list - Before I forget, or don't have a chance again,
A Merry Christmas and a Happy New Year to one and all.

We have 2 boxes, one for PRODUCTION, the other one for DEVELOPMENT
Each weekend, using DDM, we refresh the DEVELOPMENT data from the
PRODUCTION box.
The past 3 weekends we have been having problems where one of the files
has
not finished till late Monday/early Tuesday. This has resulted in a
cleanup
of this file deleting some records that shouldn't be there otherwise we
have problems on the DEVELOPMENT box when we try and test any new
changes
to the ORDER ENTRY system.
My question is
can SQL be used to directly create files ON the DEVELOPMENT box from the
same name files ON the PRODUCTION box?
If so, does anyone have any examples of what is required?


Thanks in advance



Alan Shore

NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx



--
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 ...

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.