This is end of day routine in my app. Something like intelligent backup.

----- Original Message -----
From: "Alan McDonald" <alan@...>
To: <ib-support@yahoogroups.com>
Sent: Tuesday, November 12, 2002 12:27 PM
Subject: RE: [ib-support] select from one_database.table into
another_database.table


> is this for a one-off data pump or to do it all the time?
> Alan
>
> > -----Original Message-----
> > From: column@... [mailto:column@...]
> > Sent: Tuesday, 12 November 2002 22:07
> > To: ib-support@yahoogroups.com
> > Subject: Re: [ib-support] select from one_database.table into
> > another_database.table
> >
> >
> > So, what I should put in IBSQL1.Database property then? First database
ore
> > second?
> >
> > ----- Original Message -----
> > From: "Alan McDonald" <alan@...>
> > To: <ib-support@yahoogroups.com>
> > Sent: Tuesday, November 12, 2002 12:00 PM
> > Subject: RE: [ib-support] select from one_database.table into
> > another_database.table
> >
> >
> > > no, just put that SQL i mentioned into an IBSQL component and execute
it
> > > Alan
> > >
> > > > -----Original Message-----
> > > > From: column@... [mailto:column@...]
> > > > Sent: Tuesday, 12 November 2002 21:51
> > > > To: ib-support@yahoogroups.com
> > > > Subject: Re: [ib-support] select from one_database.table into
> > > > another_database.table
> > > >
> > > >
> > > > Thank you for support.
> > > >
> > > > Regarding IBSQL. What is the way of using it?
> > > >
> > > > Should I :
> > > > connect to first_database
> > > > do select from first_database
> > > > connect to second_database
> > > > do insert to second_database?
> > > >
> > > > ----- Original Message -----
> > > > From: "Alan McDonald" <alan@...>
> > > > To: <ib-support@yahoogroups.com>
> > > > Sent: Tuesday, November 12, 2002 10:00 AM
> > > > Subject: RE: [ib-support] select from one_database.table into
> > > > another_database.table
> > > >
> > > >
> > > > > Sorry - I didn't note the reference to SP... You'll be able
> > to use the
> > > > IBSQL
> > > > > component
> > > > > Alan
> > > > >
> > > > > > -----Original Message-----
> > > > > > From: column@... [mailto:column@...]
> > > > > > Sent: Tuesday, 12 November 2002 19:45
> > > > > > To: ib-support@yahoogroups.com
> > > > > > Subject: [ib-support] select from one_database.table into
> > > > > > another_database.table
> > > > > >
> > > > > >
> > > > > > Hi,
> > > > > >
> > > > > >
> > > > > >
> > > > > > I need to do this action:
> > > > > >
> > > > > > Select from one_database.table into another_database.table
> > > > > >
> > > > > >
> > > > > >
> > > > > > Is it possible to do this with stored procedure?
> > > > > >
> > > > > >
> > > > > >
> > > > > > If no then is it possible to do wit IBX components? If yes then
> > > > > > what is the
> > > > > > best way to do that?
> > > > > >
> > > > > >
> > > > > >
> > > > > > To unsubscribe from this group, send an email to:
> > > > > > ib-support-unsubscribe@egroups.com
> > > > > >
> > > > > >
> > > > > >
> > > > > > Your use of Yahoo! Groups is subject to
> > > > http://docs.yahoo.com/info/terms/
> > > > > >
> > > > > >
> > > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > To unsubscribe from this group, send an email to:
> > > > > ib-support-unsubscribe@egroups.com
> > > > >
> > > > >
> > > > >
> > > > > Your use of Yahoo! Groups is subject to
> > > > http://docs.yahoo.com/info/terms/
> > > > >
> > > > >
> > > >
> > > >
> > > >
> > > > To unsubscribe from this group, send an email to:
> > > > ib-support-unsubscribe@egroups.com
> > > >
> > > >
> > > >
> > > > Your use of Yahoo! Groups is subject to
> > http://docs.yahoo.com/info/terms/
> > > >
> > > >
> > >
> > >
> > >
> > > To unsubscribe from this group, send an email to:
> > > ib-support-unsubscribe@egroups.com
> > >
> > >
> > >
> > > Your use of Yahoo! Groups is subject to
> > http://docs.yahoo.com/info/terms/
> > >
> > >
> >
> >
> > To unsubscribe from this group, send an email to:
> > ib-support-unsubscribe@egroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >
> >
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>