DSXchange

Hi
Thanks for a great reply. But the problem is how I know the database is down or it is alive from my job. As once if I know that than I can send the mail using the sendMail function in datastage. So the problem is to caputure whether the database is alive or down.
Thanks

HI
I really can not understand your problem.But any way If u want to run the job than compile it first in your designer. Now go to DIrector.Select your job and select run command from the menu and your job will run

Thnx

HI I am facing a problem. I am creating a job where I fetch the data from the database and doing some operation and than again insert into the database.The database I am using is oracle9i. The oracle database is present in some remote mechine. My job runs fine.But job fails when the database is down...

Hi all, Please give the solution for my doubt. If iam having the sourceformat like SRepresent jan feb march 1 120 130 120 2 100 900 500 3 300 400 500 I want target in the folloring format SRep Month Sales 1 Jan 120 1 feb 130 1 march 120 etc.. Please let me know how i can do this. Thanks, Niranjani.

HI Ray
I want to know about Universe.So could u please put some light in this area.
Thanks
Niranjani

Pls help if anyone knows:
1. In UNIX,tried to connect DB2 with BCI function(SQLConnect).
2. Failed with error message:
"SQLSTAT=IM003,CODE=80,[DataStage][SQL Client][ODBC]Specifed driver
could not be loaded"
3. What is wrong?
4. Pls advice the entries of uvodbc.config

Hi
Can any one tell me what are the importtant tables present in UV.How many difault tables created in UV and what is their functionalities

Hi Can any one tell me what exactly a dynamic Hash File.Is this the file is created at compilation time or in run time.When the hash file is going to create? Secondly if I specify during,during creation of Hash file to use account name than where it is saved means where in the hard disk.I have insta...