Search found 13 matches

by maypandh
Thu May 05, 2016 12:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: join stage performance
Replies: 2
Views: 2467

While fetching data from a sequential file specify option Read From Multiple Nodes.Also specify Keep file partitions as True.
by maypandh
Mon May 02, 2016 9:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Wild card character not working
Replies: 10
Views: 5587

Re: Wild card character not working

Hi,

Read files with file name as SRS_*.csv and read method type as file pattern.
by maypandh
Mon May 02, 2016 11:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: handle multiple reject links in parallel jobs
Replies: 9
Views: 4243

Hi,

If user wants consolidated rejected records from both jobs can you set reject link dataset update policy in append mode.

So single .ds file will be created and all records are getting captured in same dataset.
by maypandh
Mon May 02, 2016 11:29 am
Forum: General
Topic: Parallel job runs, but fails from sequence job
Replies: 5
Views: 4376

Hi,

Is job is having lot of warning messages?

Have you executed sequence in no limit option mode.
by maypandh
Mon May 02, 2016 12:37 am
Forum: General
Topic: Unable to send mail using notification activity -job aborted
Replies: 11
Views: 5962

Hi Julio,

Thanks a lot !! :)

Given logic worked fine & able to send mails to different id's.
by maypandh
Fri Apr 29, 2016 9:29 pm
Forum: General
Topic: Unable to send mail using notification activity -job aborted
Replies: 11
Views: 5962

Hi Julio,

I had already tried that option as to capture output from command output to a user variable then bypass that variable as a input to notification mail activity.

But still got same issue.
by maypandh
Fri Apr 29, 2016 12:04 am
Forum: General
Topic: Unable to send mail using notification activity -job aborted
Replies: 11
Views: 5962

Hi Craig,

I tried with comma separated but still facing same issue as Parameter 2 ('') does not start with a keyword.

Kindly suggest any alternative way.
by maypandh
Thu Apr 28, 2016 10:29 am
Forum: General
Topic: Unable to send mail using notification activity -job aborted
Replies: 11
Views: 5962

In Notification Mail Activity stage while sending mails, in recipient addresses can be space separated.

As I have tested with only notification activity stage with space separated between mail ID's.
by maypandh
Thu Apr 28, 2016 7:31 am
Forum: General
Topic: Unable to send mail using notification activity -job aborted
Replies: 11
Views: 5962

Unable to send mail using notification activity -job aborted

Hi All, Scenario :: I want to collect recipient addresses from a file then for those addresses which are mentioned in MailList file I want to send emails. So I have created one shell script called through execute command activity which is fetching data from file & echoing output as mail addresse...
by maypandh
Tue Apr 19, 2016 1:16 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to compare multiple records in a file parallely
Replies: 7
Views: 3778

Thanks Ray.

Given approach is working fine.
by maypandh
Mon Apr 18, 2016 9:34 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to compare multiple records in a file parallely
Replies: 7
Views: 3778

It worked on single node in sequential mode.

Need to capture overlapping records in reject file.
by maypandh
Mon Apr 18, 2016 12:38 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to compare multiple records in a file parallely
Replies: 7
Views: 3778

Yes tried in parallel mode of execution using hashing mechanism but didn't got expected output.
by maypandh
Mon Apr 18, 2016 10:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Unable to compare multiple records in a file parallely
Replies: 7
Views: 3778

Unable to compare multiple records in a file parallely

Hi All, Scenario : For a source input records having same key fields if there are multiple entries in source then load only those record in target where there is no clash in end dates between those records. For ex. Case 1 : Valid Case (Load both records into target) ID,DED_ACC_KEY,EFF_DT,END_DT 1,10...