| Subject | Re: [IBO] Query on two DBs - ?how do I do it? |
|---|---|
| Author | Jason Wharton |
| Post date | 2001-01-30T23:54:11Z |
Two connections, one or two transactions, one cursor and a DSQL with an
INSERT statement. A datapump with the source set to the cursor and the dst
set to the DSQL. Line up the columns using DstLinks, prepare and pump the
data calling Execute.
That's it in a nutshell.
If you want more inf. as more specific questions.
HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com
INSERT statement. A datapump with the source set to the cursor and the dst
set to the DSQL. Line up the columns using DstLinks, prepare and pump the
data calling Execute.
That's it in a nutshell.
If you want more inf. as more specific questions.
HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com
----- Original Message -----
From: "Michael L. Horne" <guardian@...>
To: <ibobjects@yahoogroups.com>
Sent: Tuesday, January 30, 2001 1:26 PM
Subject: [IBO] Query on two DBs - ?how do I do it?
> Hello
>
> Using IBO, how do I setup a query that will combine
> data from 2 different DBs?
>
> 1. Setup Components?
> 2. Write the SQL?
>
> Thanks
> Michael L. Horne
>
>
>
>
>