DSXchange

Its great Then It will be happy weekend for me

Thankyou

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 t...

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

Hi
Can we invoke Shell Scripts from NT Client as Before and After Routines.

Thanks in Advance
Surya

Hi, Can any one explain how to give all permissions to the read only Datastage Objects ? I used below commands to make DS_OBJECTS read only. Job designs Code: UPDATE DS_JOBOBJECTS SET READONLY = 'RO' WHERE READONLY = 'NRO'; Routines Code: UPDATE DS_ROUTINES SET READONLY = 'RO' WHERE READONLY = 'NRO'...

Hi,

I want to know where and when to use unix shell scripting and stored procedures in datastage.



Thanks
Suresh

Thanks for the replies.



Suresh

Hi,
I would like to know is Hash table can be used as left outer join.
If yes, please give a small example.


Thanks
Suresh

Hi Guru's
I want to know is mainframe supports parallel extender, if yes how.


Thanks
Suresh