Search found 42 matches

by gowrishankar_h
Tue Oct 08, 2013 8:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: MQ stage Reject Link
Replies: 6
Views: 3024

MQ stage Reject Link

Hi, I have a senario like i need to write the record in MQ. If Queue manager is down then the job should not abort. I tried with below approach but no luck. I have created reject link in the MQ stage and ticked the below checked box for the reject condition. 1)Connection failure 2)reject failure etc...
by gowrishankar_h
Thu Oct 03, 2013 8:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Dropping column depend on condition
Replies: 5
Views: 3835

This is my design DS--->transformer---->mQ Mq table definition will be as below. B1-- column name coming frm transformer which value is not null(Say A3) B2-- A3 length B3-- A3 value. In order to do so i need to filer colum which is having null values. I need to take the column name and length also i...
by gowrishankar_h
Thu Oct 03, 2013 7:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Dropping column depend on condition
Replies: 5
Views: 3835

Dropping column depend on condition

Hi . I have a list of column as below. A1 A2 A3 A4 A5. I want to check the condition like if A1 is not null then send that column to next stage else drop.(i need to check this condition in all incoming input column which will be more then 100+) If A1 and A2 columns having null values then oly follow...
by gowrishankar_h
Thu Oct 03, 2013 7:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Any stage to read or write OAG message
Replies: 7
Views: 2862

Performance is not generally a reason to choose the MQ Connector --- the environment is. If you are receiving the messages via MQ, then great --- use the MQ Connector --- it will read your incoming ... Thanks...but i want to know Mq connector will do parellel loading when queue is used as target.
by gowrishankar_h
Tue Oct 01, 2013 8:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Any stage to read or write OAG message
Replies: 7
Views: 2862

expert please let me know will Mq connector will run only in sequential or it will run in parellel also?
by gowrishankar_h
Mon Sep 30, 2013 8:46 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Any stage to read or write OAG message
Replies: 7
Views: 2862

Will the Mq connector will run in parallel and unix script will run on header note...so it will be good performance if we use Mq connector...am i right..
by gowrishankar_h
Sat Sep 21, 2013 7:50 am
Forum: General
Topic: Sequence not passing multi-instance invocation id
Replies: 4
Views: 2285

the main sequence is calling 6 sub-sequences and some parallel jobs... for all sub-sequences I am able to get the invocation id but not for the parallel jobs...
by gowrishankar_h
Sat Sep 21, 2013 4:42 am
Forum: General
Topic: Sequence not passing multi-instance invocation id
Replies: 4
Views: 2285

yes i am passing..
by gowrishankar_h
Sat Sep 21, 2013 3:04 am
Forum: General
Topic: Sequence not passing multi-instance invocation id
Replies: 4
Views: 2285

Sequence not passing multi-instance invocation id

Hi,

I am calling around 20 parallel jobs in a sequence which all are multi-instance enabled. but when I run the sequence the invocation id is not setting for any of the jobs. Help me to identify what could be the issue.

Thanks,
Gowri
by gowrishankar_h
Sat Sep 07, 2013 12:59 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Any stage to read or write OAG message
Replies: 7
Views: 2862

Any stage to read or write OAG message

Hi, Its there any stage to read or write OAG message?.I need to read the mainframe file from cff stage and do required transformation and compose OAG message and write it to a queue. Its better to use MQ connector to write in queue or to use unix scriipt to write in queue..Which will be better and w...
by gowrishankar_h
Sat Sep 07, 2013 12:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Any way to get the count of particular column
Replies: 1
Views: 1035

Any way to get the count of particular column

Hi, I have requirement like to read a different dataset and filter a different column with hard coded value and write the count of those column in a separate dataset. example: I have 2 dataset, 1) dataset1 (col1,col2,col3,col4) 2) dataset2 (col21,col22,col33,col44) i need to read those 2 dataset and...
by gowrishankar_h
Tue Sep 03, 2013 12:23 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: HTML generation
Replies: 2
Views: 1371

HTML generation

Hi,

I want to generate a html file from the out of transforemer....It they any way or stage to generate this like xml generation from xml output stage?


Thanks,
Gowri
by gowrishankar_h
Tue Aug 27, 2013 12:07 am
Forum: General
Topic: Is there a maximum number of stage variables?
Replies: 6
Views: 2813

Thanks...

Will it hit performance if i use more stage variable?
by gowrishankar_h
Mon Aug 26, 2013 10:24 am
Forum: General
Topic: Is there a maximum number of stage variables?
Replies: 6
Views: 2813

Is there a maximum number of stage variables?

Hi,

I just wondered how many stage variage can we have in a single transformer.I have almost 75 stage variable need to use?

Thanks,
Gowri Shankar H
by gowrishankar_h
Tue Aug 13, 2013 7:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Implicit conversion from source type, Possible range limit
Replies: 4
Views: 1617

Re: Desing change

You can change the datatype length by using modify stage or transformer stage then this warning wont occur...