Search found 37 matches

by s_porkalai
Thu Oct 14, 2010 6:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Uninstall Datastage Client
Replies: 1
Views: 1733

Uninstall Datastage Client

How to uninstall Datastage Client through command line?

i have uninstalled XMLPackClient using the below command.
msiexec /x XMLPackClientSetup.msi /q

Similarly is there any command to uninstall Datastage client?
by s_porkalai
Fri Dec 26, 2008 11:47 pm
Forum: General
Topic: Job Sequencer status Finished
Replies: 10
Views: 19133

Hi, There is no trigger page in both the jobs and all are running parallel. The Exception Activity stage is independent and it is not connected with jb_16 and jb_25. You can see the First run's Job log, The child sequence has raised an ABORT "Attempting to Cleanup after ABORT raised in stage sq...
by s_porkalai
Fri Dec 26, 2008 1:29 am
Forum: General
Topic: Job Sequencer status Finished
Replies: 10
Views: 19133

Hi dhanashreepanse,
I tried running the Child sequencer alone, the sequence getting aborted in the first run and getting finished in the second run(i,e i have restarted the sequence) even though the job is in aborted state.
by s_porkalai
Fri Dec 26, 2008 1:26 am
Forum: General
Topic: Job Sequencer status Finished
Replies: 10
Views: 19133

Hi Ray,
The option "Automatically handle activities that fail" has been set both in Parent & Child sequence. Still the Parent sequencer is getting Finished (i,e during second run). I want the Parent sequencer to be in Aborted/restartable state whenever the jobs are aborted.
by s_porkalai
Wed Dec 24, 2008 3:25 am
Forum: General
Topic: Job Sequencer status Finished
Replies: 10
Views: 19133

Yes, jb_16 and jb_25 are Job Activity stages.

The Execution Action has been set to "Reset if required, then run" for the two Job Activity stages and the child sequence.
by s_porkalai
Wed Dec 24, 2008 1:59 am
Forum: General
Topic: Job Sequencer status Finished
Replies: 10
Views: 19133

Job Sequencer status Finished

I have two sequencers, Child sequencer (sq_Child05) and Parent sequencer (sq_Parent). Parent sequencer | | Child sequencer | | | | jb_16, jb_25 The child sequencer that calls two jobs jb_16 and jb_25. In the child sequencer i'm using Exception Handler stage that goes to a notification activity stage...
by s_porkalai
Fri Dec 12, 2008 12:08 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Want to sort the data without using sort stage
Replies: 4
Views: 2503

Hi

This was an interview question i had faced. If you can solve it, please send me the answer.
by s_porkalai
Thu Dec 11, 2008 4:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Want to sort the data without using sort stage
Replies: 4
Views: 2503

Want to sort the data without using sort stage

Hi,

Anyone pls suggest me the way to sort the data without using sort stage. This was one of the interview questions i was faced with.

Thanks in advance
by s_porkalai
Mon Jul 07, 2008 6:20 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: to destructively read from an MQ in server edition 6.0
Replies: 0
Views: 791

to destructively read from an MQ in server edition 6.0

Hi

Is it possible to read data from an MQ destructively in server edition 6.0 .
I had searched for the option in the stage properties, but I did not find any such option to destructively read from the MQ . Is there a way to destructively read the data from the MQ stage?
by s_porkalai
Sun Jun 22, 2008 10:42 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: messages getting truncated when writing into MQ
Replies: 3
Views: 1978

But the truncation happen only in some data which got transformed in first job. remaining data is entering the queue as whole
by s_porkalai
Thu Jun 19, 2008 6:12 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: messages getting truncated when writing into MQ
Replies: 3
Views: 1978

messages getting truncated when writing into MQ

Hi All, I have two jobs as below running in sequencer. 1. teradataenterperise->transformer->odbc-teradata 2. teradataenterperise->MQ->column export->MQ When the messages are entering into MQ it is getting truncated. we first add the APT_PADCHAR='0X20' in the second job. now only some records which u...
by s_porkalai
Thu May 29, 2008 7:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to get the status of last run of the job running in loop
Replies: 1
Views: 1117

how to get the status of last run of the job running in loop

Hi We have a sequencer which is running in a loop. each loop will start its run based on a output from a unix script. The problem here is when the job aborts the exeception handler is sending a mail with the status of job in all the previouse loops. so the mail is looking so big. is there any chance...
by s_porkalai
Wed May 28, 2008 10:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unknown Block Format
Replies: 1
Views: 1505

Unknown Block Format

Hi, i'm getting the following error... main_program: Ascential DataStage(tm) Enterprise Edition 7.5.2 Copyright (c) 2004, 1997-2004 Ascential Software Corporation. All Rights Reserved main_program: orchgeneral: loaded main_program: APT configuration file: /Ascential/DataStage/jobdir/config.apt main_...
by s_porkalai
Wed Apr 23, 2008 12:57 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: IF then else not working in transformer
Replies: 6
Views: 3979

we have tried with all the options - trim ,peek, squote. but the result is same . and the data we view through peek state is correct only.


one intersting fact is when we use alpha function on link1.col1 it is giving result as 0, eventhough there is no non alphabet characters in the incoming data.
by s_porkalai
Tue Apr 22, 2008 3:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: IF then else not working in transformer
Replies: 6
Views: 3979

No all the iterations are working with the same data. even when i try to run the job in sequencer using start loop and end loop ie startloop -> job-> endloop | | |---------------| activity 'if condition' is working fine for first few iteration in loop but it is giving ' UNKNOWN' after several runs