how to connect to database using Basic language

[suri]

Hi,

I had to write a routine to connect to database and pull data for manipulation. Can any one explain me with example how to connect to oracle database using Basic language.

Thanks
Suresh

[chulett]

Yuck! BCI functions, ODBC and the need to buy licensed drivers. Do it in a DataStage job instead. Why do you think you "need" to do this in a routine?

[ray.wurlod]

had to

Why?
There's a reason DataStage has the graphical interface, so you don't have to write code unnecessarily.

[suri]

Hi Ray,
I have a select which does select with in select on same table and limits the output Values and basing on these values i have set business rules basing on i will populate 60 target columns.

Sel col1,col2,col3 From Table1 for col 4,col5,col6,col7,col8 these columns are refered as Table2, if this statement gives more than 32 write to reject.
Basing on 32 Values we write set of conditions and populate 60 Target columns
Source DataBase is ORACLE.

Thanks
Suri

[kduke]

User defined query should be able to do anything you want.

[martin]

This has to read every record....its loop ....User defined SQL work for performing loop

Thanks

[kduke]

If you search here there has been code posted which can open an ODBC connect, allocate memory to the SQL statement and then loop through it like cursor in PLSQL. If you cannot find it then I will post some code tonight.

[suri]

Its great Then It will be happy weekend for me

Thankyou

[chulett]

Not really... you'd still have to buy ODBC drivers, unless you already have. The drivers that ship with DataStage are only licensed for use within jobs, not via the BCI functions.