Search found 53125 matches

by ray.wurlod
Tue May 18, 2010 11:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML Input server job finished with no output
Replies: 6
Views: 1946

How?

The convention here is that, when you mark a thread as Resolved, you make a post indicating the means by which it was resolved.

This assists future searchers.
by ray.wurlod
Tue May 18, 2010 11:46 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Substring and trim funcations in modify
Replies: 3
Views: 1498

Operator combination will mean that the three stages will execute in the same single process.
by ray.wurlod
Tue May 18, 2010 11:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Configuration file not used
Replies: 10
Views: 2628

No, it just ignores everything after the point where it's informed (by the second "}") that the definition has ended. Same rules as in C or C++.
by ray.wurlod
Tue May 18, 2010 11:43 pm
Forum: General
Topic: IOD EMEA 2010 Day One
Replies: 5
Views: 1779

"Getting a guernsey" comes from the game of rugby union. When a player is selected to be a member of a team, the player gets a guernsey (= shirt, but tougher to rip) in which to play. It is very much English! Just not American so much. You can work out how it extends into the metaphor that...
by ray.wurlod
Tue May 18, 2010 11:40 pm
Forum: General
Topic: fail to connect to ole server
Replies: 5
Views: 1754

I like to blame Windows for this one. The DataStage clients use objects exposed by an OLE server (more than one actually) and Windows sometimes "loses the handle".
by ray.wurlod
Tue May 18, 2010 11:39 pm
Forum: IBM QualityStage
Topic: US Address Standardization
Replies: 2
Views: 1911

I take it you don't want to create your own rule set and modify the Pattern Action Language.

You could use an input pattern override with a pattern that begins with the literal. I am not sure how you need to handle GONZALEZ in your example.
by ray.wurlod
Tue May 18, 2010 11:37 pm
Forum: Site/Forum
Topic: Business Glossary and FastTrack forums
Replies: 8
Views: 6851

Separate ones would be even better. I think we are soon to have an explosion in Business Glossary "how to" and "best practice" issues.
by ray.wurlod
Tue May 18, 2010 10:15 am
Forum: General
Topic: IOD EMEA 2010 Day One
Replies: 5
Views: 1779

IOD EMEA 2010 Day One

Day One is for Business Partners, and is mostly about selling strategies. I won't bore you with lots of detail about that. Possibly the most interesting point from today is that IBM is moving towards a whiteboard-based selling strategy - as a direct reaction to customers' increasing resistance to Po...
by ray.wurlod
Tue May 18, 2010 10:10 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: sequencial file is getting created with dsadm owner.
Replies: 2
Views: 1296

Actually I suspect that your DataStage Credentials section in Web Console for Information Server (Administration tab, Domain Management section) maps all, or at least default, users to dsadm.

The fix is to create proper DataStage credentials.
by ray.wurlod
Tue May 18, 2010 10:09 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Packed column from DB2/400
Replies: 37
Views: 6558

Lose the quotes from around the third and fourth arguments of the Field() functions - these must be integers.
by ray.wurlod
Tue May 18, 2010 10:07 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Substring and trim funcations in modify
Replies: 3
Views: 1498

As a general rule the modify operator does not support nested functions.

You can use two modify operators, but need a copy operator between them (either explicitly or implicitly).
by ray.wurlod
Tue May 18, 2010 10:06 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Configuration file not used
Replies: 10
Views: 2628

Sainath has it. You have closed the configuration before it ends. Your configuration file should probably appear as: { node "node1" { fastname "DatastageETL" pools "" resource disk "/dataarea" {pools ""} resource scratchdisk "/scratch" {poo...
by ray.wurlod
Tue May 18, 2010 10:04 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: write a variable block file
Replies: 5
Views: 1839

Would Kim be distressed if I mentioned the Grand Inquisitor?
:wink:
by ray.wurlod
Tue May 18, 2010 10:03 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: extended ascii char as a delimiter in sequential file stage
Replies: 3
Views: 1238

Then you might care to mark the thread as Resolved
by ray.wurlod
Tue May 18, 2010 6:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Two Nodes not working
Replies: 18
Views: 6394

None of those is the score. The score is a single event in the log. The first line of the event is of the form "This job has 42 datasets". You don't get the score automatically - you have to set the environment variable (preferably added to the job as a parameter) APT_DUMP_SCORE to True. T...