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