Search found 53125 matches

by ray.wurlod
Fri Jun 22, 2012 3:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: C++ compiler problem
Replies: 11
Views: 7493

What are the values of the system environment variables INCLUDE, LIB and LIBPATH ? Have you installed the Platform SDK as per the installation instructions?
by ray.wurlod
Fri Jun 22, 2012 3:21 am
Forum: IBM<sup>®</sup> DataStage TX
Topic: How to code for trimming variable length of text
Replies: 3
Views: 9519

What the OP really wants, vamsi.4a6, is a WebSphere TX map. This is NOT a requirement for a DataStage solution. That's why it's in the TX forum.
by ray.wurlod
Fri Jun 22, 2012 3:19 am
Forum: General
Topic: How to read .spps data using Datastage?
Replies: 2
Views: 1236

Start with "get the metadata for .spps data" (whatever that is). That should give you sufficient clue. It may be more maintainable to separate the reading and parsing phases, by reading each line as a single string and performing the parsing step(s) in a downstream Transformer stage.
by ray.wurlod
Thu Jun 21, 2012 11:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: External Target Stage
Replies: 13
Views: 5044

The reverse sounds pretty horrible too!
:twisted:
by ray.wurlod
Thu Jun 21, 2012 11:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: usage of cdc project-urgent!
Replies: 2
Views: 1380

Welcome aboard.

Please do not mark your posts "urgent" on DSXchange. We are all volunteers, who will post as and when (and if) we can.

If you need fast answers, sign up with your official support provider for priority support, and learn just how much "urgent" costs.
by ray.wurlod
Thu Jun 21, 2012 11:46 pm
Forum: General
Topic: Junk characters in the mail
Replies: 8
Views: 2571

On UNIX you can probably get away without mentioning an SMTP client; each UNIX machine can typically act as its own mail client, unless that functionality has been specifically disabled.
by ray.wurlod
Thu Jun 21, 2012 5:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Decimal To String Error
Replies: 8
Views: 3294

srinivas.g wrote:column_name[1,4]-1:'-':field(column_name,'-',2):'-':field(column_name,'-',3)
What would this give if the date were 2012-02-29?
You need to think through your "solutions" more thorougly.
by ray.wurlod
Thu Jun 21, 2012 5:39 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Order the records based on Date Value
Replies: 11
Views: 3768

If you want to use Min and Max on dates in the Aggregator stage you have to set the Preserve Type property.
by ray.wurlod
Thu Jun 21, 2012 5:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to get last value in each row
Replies: 7
Views: 2706

Code: Select all

Field(InLink.TheString, delimiter, Count(InLink.TheString, delimiter) + 1, 1)
by ray.wurlod
Thu Jun 21, 2012 5:31 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: how to get last value in each row
Replies: 7
Views: 2706

Code: Select all

Field(InLink.TheString, delimiter, Count(InLink.TheString, delimiter) + 1, 1)
by ray.wurlod
Thu Jun 21, 2012 5:05 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Generic CDC Update and Delete Jobs
Replies: 4
Views: 2205

Which (exact) stage type are you using?
by ray.wurlod
Thu Jun 21, 2012 4:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Time data type internal representation
Replies: 3
Views: 1153

I'm not aware of any public documentation. Sounds like a good question for IBM, maybe through developrWorks, maybe through a PMR. Maybe some kind (and knowledgable) IBMer will pick up this thread.
by ray.wurlod
Thu Jun 21, 2012 4:41 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: IPC timeout issue
Replies: 5
Views: 2452

First question is about resources. Are the production and non-production environments identical (CPU power, memory, disk space)?

Buffer sizes propagate when objects are newly created but not otherwise. There's no link - last one configured wins.
by ray.wurlod
Thu Jun 21, 2012 4:38 pm
Forum: General
Topic: JobControl (fatal error from @Coordinator)
Replies: 6
Views: 4462

Are the subsidiary Job activities set up for "reset if required, then run"?
by ray.wurlod
Thu Jun 21, 2012 4:36 pm
Forum: Data Quality Best Practices
Topic: Publishing from Development Glossary
Replies: 10
Views: 29884

The readme for the rollup patch indicates that patch JR41793 is included.

The joys of being on the bleeding edge!