Search found 53125 matches

by ray.wurlod
Thu May 07, 2009 4:26 pm
Forum: General
Topic: Datastage certification cost
Replies: 12
Views: 12539

That cost entitles you to ONE attempt. The same cost applies to each additional attempt. Make sure to do your preparation.
by ray.wurlod
Thu May 07, 2009 4:24 pm
Forum: IBM QualityStage
Topic: QualityStage-Standardize Problem
Replies: 4
Views: 1900

Which Rule Set are you using here? The things you've listed can not be standardized with a single rule set - are you talking about USPREP for example? In that case the separator literal must be of the form ZQnameZQ.
by ray.wurlod
Thu May 07, 2009 4:23 pm
Forum: IBM QualityStage
Topic: QualityStage Match Process Error
Replies: 7
Views: 5429

Please advise HOW this issue was resolved.
by ray.wurlod
Thu May 07, 2009 4:22 pm
Forum: IBM<sup>®</sup> DataStage TX
Topic: Need support information on datastage TX/mercator 6.7
Replies: 7
Views: 6788

So, what you're telling us is that your employer has transferred you into a new role without any intention of providing training for that role?
by ray.wurlod
Thu May 07, 2009 12:40 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Can't able to start the server
Replies: 13
Views: 17972

What other log files exist under C:\IBM\WebSphere\AppServer/profiles/default\logs\server1 ?

Does any of these contain useful information?

Rather than waiting for those occasions that we post, do involve your official support provider - after all, you're paying them to support you.
by ray.wurlod
Wed May 06, 2009 11:21 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Problem with hex '00' characters
Replies: 9
Views: 9207

APT_STRING_PADCHAR will not help. Try a Trim() function with Char(0) as the second argument.
by ray.wurlod
Wed May 06, 2009 11:17 pm
Forum: General
Topic: Getting part of a filename
Replies: 16
Views: 7262

It was an example. I sometimes require my interlocutors to think.
8)
by ray.wurlod
Wed May 06, 2009 11:15 pm
Forum: General
Topic: Loop Iteration Number in Sequencer
Replies: 9
Views: 2183

But the question leads to an epiphany. Why not solve it from the other end, so to speak? Set up the "list of things" as a delimited string as before. In a User Variables activity create a variable that contains the number of things in that list of things (the number of delimited fields, if...
by ray.wurlod
Wed May 06, 2009 11:06 pm
Forum: General
Topic: Getting part of a filename
Replies: 16
Views: 7262

Folder stage gives the option of fully qualified pathname or not. Choose not. Then, for example, apply an "MCN" Oconv() to the file name to get the numeric portion.
by ray.wurlod
Wed May 06, 2009 11:04 pm
Forum: General
Topic: Loop Iteration Number in Sequencer
Replies: 9
Views: 2183

$Counter contains one "thing" off the "list of things".

That's what you're missing here.
by ray.wurlod
Wed May 06, 2009 8:39 pm
Forum: General
Topic: Why IBM sucks and DataStage will never be the leading tool
Replies: 16
Views: 9925

I have been given to understand that "Microsoft sucks" has been elevated to the status of "axiom".
:wink:
by ray.wurlod
Wed May 06, 2009 8:37 pm
Forum: General
Topic: Loop Iteration Number in Sequencer
Replies: 9
Views: 2183

You don't need a routine - you could use that expression directly in an expression.

If you do use a routine there's a much nicer solution that uses the Locate statement.
by ray.wurlod
Wed May 06, 2009 8:34 pm
Forum: Site/Forum
Topic: DSXchange integration with Twitter
Replies: 4
Views: 4103

Almost none of the responses I put onto DSXchange is short enough to use this technology. Plus I don't use it personally. Phone or SMS is good enough for the few communications I need to have.
by ray.wurlod
Wed May 06, 2009 6:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to get the last business day of the given month.
Replies: 8
Views: 2583

Indeed, at least one Friday is a holiday in Christian cultures, and Friday is not a business day in Islamic cultures. A Time (or Calendar) dimension is the preferred solution. A Time dimension at daily granularity might even include a "last business day of month" column if that makes good ...
by ray.wurlod
Wed May 06, 2009 6:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Preserve Partitioning option when using multiple stages
Replies: 6
Views: 2802

It's a good question, naive or not. The answer is no. Therefore you are going to wear the warning, and might choose to incorporate a message handler to demote it.