Search found 53 matches

by shrinivas
Tue Mar 24, 2009 11:26 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequence get stopped automtically
Replies: 5
Views: 2409

Hi guys ya I am using terminator stage (or Stop stage ) in the seq. and the condition for Tremination is when the dependent job fails. But no job is as such failed in my sequence . Its just sending a stop request to all the jobs in the sequence.
by shrinivas
Tue Mar 24, 2009 6:57 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequence get stopped automtically
Replies: 5
Views: 2409

Sequence get stopped automtically

My sequnce is getting stopped after few jobs run with out any warnings . I am getting a info in my Log stating " Stop request detected for the Sequence 'SEQUENCE NAME'; After this all other jobs running in sequence are getting stopped. Really dont know what is leading this. All the jobs are sim...
by shrinivas
Wed Aug 29, 2007 6:44 am
Forum: General
Topic: abort job in a single warning
Replies: 5
Views: 3024

Thanks Mohdsuf, its working for me .
by shrinivas
Wed Aug 29, 2007 5:16 am
Forum: General
Topic: abort job in a single warning
Replies: 5
Views: 3024

I searched the site . but no where I am getting how to set the warn limit in jobs .every body here is dicussing that we can do it thru warn limit settings but nobody is telling How to fix that settings . May be I missed some messages.
by shrinivas
Tue Aug 21, 2007 8:42 am
Forum: General
Topic: abort job in a single warning
Replies: 5
Views: 3024

abort job in a single warning

Hi ,
How can I abort a job when it throws a warning . I know we can set the warn limit to 1 . But i dont know how to set it when I run the job thru sequence.Is it a job level setting .
Or is there any other work around .
by shrinivas
Thu Aug 16, 2007 8:25 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Folder stage Pattern
Replies: 7
Views: 3090

So is that mean there is no other way ..
by shrinivas
Tue Aug 14, 2007 2:13 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Folder stage Pattern
Replies: 7
Views: 3090

Folder stage Pattern

Hi Guys , I am facing one issue while using Folder stage to read a particular pattern files .I am explaining my problem with an example . I have two files of pattern ABC_MMDDYY and ABC_DEF_MMDDYY. What I need is I have to pick all the files with pattern ABC_MMDDYY . SO what i did in the folder stage...
by shrinivas
Thu Jun 14, 2007 9:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Restartablity of sequence
Replies: 7
Views: 3565

Putting Unconditional trigger will always abort my job after running the job C . But what I need is If Job B fails ,run the Job C and then only aborts the sequence . If Job B is run succesfully then Run job C and End the sequence as completed succesfully. Correct me if I am wrong .
by shrinivas
Thu Jun 14, 2007 9:06 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Restartablity of sequence
Replies: 7
Views: 3565

Thanks guys .....I got my solution from your replies. What I have done is A---->B---->C----> Terminator Activity I am using Check point in the sequence. I removed check point from the Job C . Trigger for the Terminator Activity I have customed the condtion to check the failed status of job B. So eve...
by shrinivas
Thu Jun 14, 2007 7:59 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Restartablity of sequence
Replies: 7
Views: 3565

Restartablity of sequence

Hi Guys , I have problem on restarting sequnce. My Sequence structure is like this A---->B---->C My requirment is that If my Job "B" fails the Job "C" should be run but the sequence should be restartable from job "B" . That means whatever the result of Job "B"...
by shrinivas
Fri Jun 01, 2007 4:53 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Hash file Create, delete file and Clear file Options
Replies: 2
Views: 1965

Hash file Create, delete file and Clear file Options

Hi Guys, I have a confusion about how to use Clear file, delete file and Create file options for a Hash file. My confusion is which combination of options gives me better performance each time I run the jobs. My most requirements are like to clear the hash file before writing. So shall I tick the Cr...
by shrinivas
Fri May 18, 2007 8:02 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Writing in to a sequential file trhru routine
Replies: 22
Views: 10674

One more thing I can see only thr CR value thru the Iconv funvtion. and as the last column is numeric in the destination file . the nueric value is becoming character value ...... when i try to read the destination file and insert the data in to a table , it throws an error that "value is an in...
by shrinivas
Thu May 17, 2007 12:00 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Writing in to a sequential file trhru routine
Replies: 22
Views: 10674

One more thing I would like to specify ....
When I am reading the Destiation file (i.e the file created in the routine) in a job I am reading it as Unix file (Line termination Unix style) as I am not able to read it as DOS Style temination.
by shrinivas
Wed May 16, 2007 11:48 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Writing in to a sequential file trhru routine
Replies: 22
Views: 10674

Hi guys , Here I ma puttinf my total code ...My OS is Windows at present . When I will move this code to production , Its going to be Unix .... ******************************************************************************************************************************** **Input to the routine is a...
by shrinivas
Wed May 16, 2007 6:49 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Writing in to a sequential file trhru routine
Replies: 22
Views: 10674

I tried ur sugegstion but no improvement ,The problem is what ever I write in to a sequntial file it append the CR in to the last character of the last record .
Can u get me the syntax with an example . from which I can match it my code