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@... [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/
>
>
>