Hi Alan,
What is QLI?
Thx
Regards, Marco

--- In ib-support@y..., "Alan McDonald" <alan@m...> wrote:
> my mistake - not across databases. you'll need QLI or manually via
datapump.
> Or you'll need to write you're own code to pump the data..
> select field1, field2,.. from database1_table
> insert into database2_table (field1, field2,..) values (:param1,
> :param2,... ) etc
> Alan
>
> > -----Original Message-----
> > From: column@c... [mailto:column@c...]
> > Sent: Tuesday, 12 November 2002 22:07
> > To: ib-support@y...
> > 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@m...>
> > To: <ib-support@y...>
> > 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@c... [mailto:column@c...]
> > > > Sent: Tuesday, 12 November 2002 21:51
> > > > To: ib-support@y...
> > > > 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@m...>
> > > > To: <ib-support@y...>
> > > > 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@c... [mailto:column@c...]
> > > > > > Sent: Tuesday, 12 November 2002 19:45
> > > > > > To: ib-support@y...
> > > > > > 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@e...
> > > > > >
> > > > > >
> > > > > >
> > > > > > 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@e...
> > > > >
> > > > >
> > > > >
> > > > > 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@e...
> > > >
> > > >
> > > >
> > > > 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@e...
> > >
> > >
> > >
> > > 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@e...
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >
> >