Multiple Queries For Odbc Import

[noblenull]

It would be great if I could have multiple queries in 1 ODBC import. For example, now if you enter 2 queries seperated by ; in the Migration Toolkit, you only get one mappable result on the “Select Tables” screen.

[peterlaursen]

I'm sorry but I don't understand this.

Could you specify where you enter that query?/those queries?

What is the ODBCsource that you import from?

Could you paste in an example? or provide a screen-dump?

And what do you want to accomplish with that can't be accomplished by now?

[noblenull]

peterlaursen wrote on Sep 23 2005, 07:51 PM:

I'm sorry but I don't understand this.

Could you specify where you enter that query?/those queries?

What is the ODBCsource that you import from?

Could you paste in an example? or provide a screen-dump?

And what do you want to accomplish with that can't be accomplished by now?

[post=”7296″]<{POST_SNAPBACK}>[/post]

Say for example, I want to select a customer name based on order date.

I would do something like:

select name from customers where orderdate > '9/23/2005';

I then want to update ALL of the prices from my inventory table.

select model, price FROM inventory;

Currently, it is not possible to do both of these things in 1 job (as far as I know).

[Ritesh]

Yes, you are correct. You can import data from two results in one job session. You will need to have two job sessions.

I have written this in the TO-DO list of SQLyog but I cannot guarantee which version will have this feature.

[Author]

Posts