DSXchange

Some more details - The failed job will have only 7 entries - Main ones to notice are

- Start Job
- Load Environment Variables
- Failure (after waiting for 90 Minutes).


No "queries" are issued.... probably just trying to ping??

Version : 7.5.2 Server : Windows OS Issue : One of my sequencer triggers 4 jobs simultaneously out of which 3 complete , but 1 waits for ~90 minutes and then fails with ORA-03135: Connection lost contact. The job which fails is not the same one all the time , and in addition to that the error is spo...

that was short and quick...

thanks !!!

Hey All,

Quick Question - Is there a table or place in datastage which holds the information of the past runs of a job other than the job logs?

Thanks
Dk

This ws simple.. shud have saw the options before posting.....

I am trying to generate a flat file through datastage from a table. (table copy to a txt file). Has three columns and multiple rows. After every row it puts line ender (which is enter) and then the next row starts. (pretty standard). The requirement is that the last line should not have the enter , ...

Hey Guy ,

I have Datastage Installed on a Unix Box and now I have a requirement to write to a Windows Shared Folder. Any ways to establish this?

Thanks in Advance...

chulett wrote:Yup, the next 7th day of the month. ...

Thanks !! The most difficult question of the year

I am in process of scheduling a job to run on 7th Jan 2009. As far as I understand in order to do that I need to go to director and schdule it using following options --

Run job - Next
Day - 7
Time - 7:00 PM

As this is in Prod I just wanted to double check.

Sorry I must have clarified that... They do not want to use Windows Scheduler etc etc. I am aware of that Datastage uses the same , but we are gettign there... Will require some time to convince them.

Okay going back to the main question I blv Ftp is the only way I guess then.
Thanks !!

Need to automate this thts why need to do it in Datastage... Clients don't have an scheduler...

Is there any way to copy flat files from an Unix system to Windows through ASCL?

Thanks

chulett wrote: the first action must fail for the second to fire, so you typically choose whi ...

Got it... Thats wht I was missing.... First Action Fail.. I had not contraints/inique keys in my table. Will test it now...

In my target DRS I see two options - Insert or Update and Update or Insert. Whts the difference between these two? I thought they do the same thing till I see it in my database the rows are getting duplicate if I use Insert or Update.

The other option is very slow . Please suggest.

Awesome , thanks for the information !!!!