Search found 53125 matches

by ray.wurlod
Tue May 03, 2011 8:27 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Remove hash
Replies: 7
Views: 2603

Why did you post this in the parallel forum?
by ray.wurlod
Tue May 03, 2011 2:52 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Warnings while using Reject link in the ORACLE CONNECTOR
Replies: 3
Views: 2950

You can't. You could use a message handler to demote it to informational, but that can't be conditional.
by ray.wurlod
Tue May 03, 2011 2:49 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: current date () - 6 months
Replies: 17
Views: 6812

priyadarshikunal wrote:Depends on the definition on 6 months.
No it doesn't. I understand the requirement to be "the date 6 months prior to current date".
by ray.wurlod
Tue May 03, 2011 2:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Concept question: Use of Parameter Sets from Connection Def.
Replies: 4
Views: 2061

That you'd have to ask the designers. You can meet some of them at the Information on Demand conference in October.
by ray.wurlod
Tue May 03, 2011 2:44 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: DEFFUN error
Replies: 13
Views: 4683

That's not a log, that's the source code of your Transformer stage.

There's nothing obvious there. What does your support provider advise?
Have you tried building a second copy of the job (or a simplified version) to see whether the problem is reproducible?
by ray.wurlod
Tue May 03, 2011 2:39 pm
Forum: General
Topic: Looping through a text file
Replies: 7
Views: 3102

Since you're on Windows \n probably isn't your line terminator. Leaving that aside, I have always preferred to translate the line terminator into a different delimiter (such as pipe or some other printable character) so that it can be clear in the Start Loop activity what the delimiter is. So an Exe...
by ray.wurlod
Tue May 03, 2011 5:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Clearing orphan datastage processes
Replies: 1
Views: 1458

The period is primarily driven by the TCP wait timeout. If there are any connected processes to port 31538, even if they're in a SLEEP_WAIT or other "waiting to finish" state, then dsrpcd (the listener on that port) can not shut down. If you kill dsrpcd it won't restart (unless you reboot ...
by ray.wurlod
Tue May 03, 2011 5:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Concept question: Use of Parameter Sets from Connection Def.
Replies: 4
Views: 2061

It's not buggy but it is limited in only allowing you parameters for the properties on the Connection portion of the Connector stage properties. It would be nice if you could add other parameters but, for now, that's not possible. My current practice therefore is to have two parameter sets, one link...
by ray.wurlod
Tue May 03, 2011 5:36 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Variables DSWaitStartup and DSWaitResetStartup
Replies: 4
Views: 3427

If your server is heavily overloaded it doesn't really matter what you set your startup wait value at.
by ray.wurlod
Tue May 03, 2011 5:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Data string does not match format error???
Replies: 5
Views: 6782

Or none in the format string. They have to match.
by ray.wurlod
Tue May 03, 2011 5:34 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: current date () - 6 months
Replies: 17
Views: 6812

How about DateFromDaysSince() with an offset of -183 ?
by ray.wurlod
Mon May 02, 2011 7:57 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Quick question on querying DS_JOBS table
Replies: 17
Views: 13434

With "=" as the operator only the "full path" will work.

That's why I suggested the LIKE operator.
by ray.wurlod
Mon May 02, 2011 7:54 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Source table has 3 columns and target table has 1 column
Replies: 5
Views: 2817

What is the mapping to each of the target columns?

You're doing way too much work, but we need to know what has to go into each target column before being able to help further.
by ray.wurlod
Mon May 02, 2011 4:24 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Abnormal termination of DataStage -- Fault type is 6
Replies: 5
Views: 5069

Not without consulting that manual, which I'm not in a position to do right now.