How to get the records from SQL server Table through routine

chitravallivenkat · Post by **chitravallivenkat** » Tue Jun 20, 2006 11:25 pm

Hi to all,
Can anybody tell how to get the records from SQL server table through routines?
if possible, pls send the routine.

then can anybody tell any good documentation for Basic codes (to write a routine) to read and improve my datastage knowledge to write a routine.

Pls help.

Thanks.

Venkat.

ray.wurlod · Post by **ray.wurlod** » Wed Jun 21, 2006 12:55 am

Welcome aboard. :D

You need to access SQL Server through the ODBC driver. Problem is, the one you have is not licensed for your use in code, only for use from the ODBC and Dynamic RDBMS stages. You will find that it works for 30 days, then fails with a message telling you to buy a licence from Data Direct.

Given that caveat, you write a routine using BCI functions. Effectively you would be programming using the ODBC API, but in DataStage BASIC. There is a manual downloadable for free from IBM should you wish to pursure this further.

But, and it's a big but, why do you want to write code to do what DataStage can already do?

chulett · Post by **chulett** » Wed Jun 21, 2006 7:06 am

ray.wurlod wrote:But, and it's a big but, why do you want to write code to do what DataStage can already do?

Just wanted to make sure Ray's Big But was shown to the public.