Home > Archive > Cobol > May 2005 > DTS
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| I have a question regarding DTS in SQL Server, I am trying to match
tables that are present in Databse A to Database B. I Know to match the
columns but I am not aware of how exactly can i transfer values of
tables present in databse A to tables present in database B.
Is there anyone who can help me with this.
Thanks in advance
Kelly
| |
| Frederico Fonseca 2005-05-24, 8:55 pm |
| On 24 May 2005 15:17:34 -0700, "Kelly" <vkforfun@yahoo.com> wrote:
>I have a question regarding DTS in SQL Server, I am trying to match
>tables that are present in Databse A to Database B. I Know to match the
>columns but I am not aware of how exactly can i transfer values of
>tables present in databse A to tables present in database B.
>
>Is there anyone who can help me with this.
And what does this have to do with COBOL?
But you do that with an insert or/and an update sql statement.
DTS package creator is very helpfull on this, so do try it out
Frederico Fonseca
ema il: frederico_fonseca at syssoft-int.com
| |
| Richard 2005-05-25, 3:55 am |
| > I Know to match the
> columns but I am not aware of how exactly can i transfer values of
> tables present in databse A to tables present in database B.
I think that you are asking how you access the data items from two
tables in a single select via a cursor.
Something like:
DEFINE ... CURSOR FOR
SELECT * FROM A, B WHERE A.value > 1000.00 and B.code = A.code
FETCH ... (A.code, B.name) INTO :code, :name
|
|
|
|
|