sql statement in odbc connector

pandujoy · Post by **pandujoy** » Wed Nov 11, 2009 11:33 am

Hi ,

I am new to datastage.....Just a small or may be foolish question...

Can we use a regular SQL statement in ODBC connector stage...When i mean regular SQl.....like if i am getting 3 fields form tabel A and 6 fields form table B....how to import the table definitions.

Or should i just join stage to join these two tables........cant i use them as a SQl query in ODBC connector stage.

thanks in advance

betterthanever · Post by **betterthanever** » Wed Nov 11, 2009 11:40 am

create the table def. from required fields if you want to run the join at the DB level..

chulett · Post by **chulett** » Wed Nov 11, 2009 11:43 am

That's exactly what it uses - "regular" sql. So if you need to join tables in your query, go for it.

pandujoy · Post by **pandujoy** » Wed Nov 11, 2009 12:13 pm

thanks for you reply.....so when you mean create table definition...all that i need is to import the table definitions of both the tables into the stage right?

richdhan · Post by **richdhan** » Thu Nov 12, 2009 3:24 am

Hi,

Yes you have to import the required columns from both the tables into the stage and use user-defined SQL.

My advise for someone new to DS would be

1. Do your homework before posting questions. Just go through the official documentation.

2. Always give it a shot. If it works good. If it fails then you can come back and do a search in DSXchange. The search is very extensive and most of the time you get answers from the search results.

All the best.

--Rich

dipakparekh · Post by **dipakparekh** » Thu Jan 07, 2010 7:17 pm

Hi did you get answer to your question. I have the same question actually.

chulett · Post by **chulett** » Thu Jan 07, 2010 9:35 pm

Then the same answer given here applies to you as well... as does the one you got in your own thread. If you still need help, please make sure and continue the conversation in the thread you started rather than here.

Thanks.