Search found 3329 matches

by Sainath.Srinivasan
Wed Mar 11, 2009 3:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Cff STage View data Problem
Replies: 4
Views: 1485

It means the RECORD_TYPE (or similar) column has different value that the ones given in expected list.
by Sainath.Srinivasan
Wed Mar 11, 2009 3:27 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Looping Function
Replies: 14
Views: 8499

Common mistake is using DCount. Use Count instead (if this is the issue).
by Sainath.Srinivasan
Wed Mar 11, 2009 3:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Looping Function
Replies: 14
Views: 8499

Common mistake is using DCount. Use Count instead (if this is the issue).
by Sainath.Srinivasan
Tue Mar 10, 2009 7:51 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Incrementing values in datastage going wrong
Replies: 13
Views: 10250

Being PX, you might want to consider where the data goes.
by Sainath.Srinivasan
Tue Mar 10, 2009 4:42 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Receiving a mail using datastage
Replies: 3
Views: 1555

DS as such may not be the best solution.

There are 3rd party tools which can synchronise with email and also download any attachments to process.
by Sainath.Srinivasan
Tue Mar 10, 2009 3:54 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sending Mail
Replies: 2
Views: 1026

To keep the same working mechanism, in your count agg job, add a row generator with a zero value in the column and funnel together.
by Sainath.Srinivasan
Mon Mar 09, 2009 10:58 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Invocation id for multiple instance jobs
Replies: 9
Views: 6187

Can you elaborate what you did so others can provide better response.

Can you run the same job from Director ?
by Sainath.Srinivasan
Mon Mar 09, 2009 9:45 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: determine deletes in server job
Replies: 5
Views: 1154

What are your source and target?

How have you worked your insert and updates? If you have located them, delete must be the rest.
by Sainath.Srinivasan
Mon Mar 09, 2009 7:56 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Lookup character strings
Replies: 17
Views: 6012

I think earlier I did not understand your requirement if full. If you need to identify and split into different sets, maybe you can create a temporary pattern file copy as sed -e 's/^/\^/' yourPatternFile > tempPatternFile sed -e 's/^/ /' -e 's/$/ /' yourPatternFile >> tempPatternFile sed -e 's/$/ /...
by Sainath.Srinivasan
Mon Mar 09, 2009 6:55 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Issue with date and timestamp
Replies: 2
Views: 1162

Try Time() instead of @Time
by Sainath.Srinivasan
Mon Mar 09, 2009 6:50 am
Forum: General
Topic: Ardent Datastage
Replies: 12
Views: 3092

Also several companies joined in the evolution cycle thus giving us more powerful datastage (with Orchestrate) and other products like MetaRecon, Integrity.
by Sainath.Srinivasan
Mon Mar 09, 2009 4:17 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Lookup character strings
Replies: 17
Views: 6012

Code: Select all

sed -e 's/^/ /' -e 's/$/ /' sourceDataFile | egrep -f patternFile
Note - prefix and suffix each char in pattern file with space. Or make another sed to do it.

I assume you do not want the "replacement word".