Re: SQL Question

[Alan Shore <AlanShore@xxxxxxxx>]

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.