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
how to connect to database using Basic language
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: how to connect to database using Basic language
Why?suri wrote:had to
There's a reason DataStage has the graphical interface, so you don't have to write code unnecessarily.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
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
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