Search found 53125 matches

by ray.wurlod
Mon Feb 08, 2010 12:39 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: String Comparision
Replies: 3
Views: 1152

The comparison is character-by-character. Therefore as soon as one character in the shorter string is "greater than" the corresponding character in the other string, previous characters having matched exactly, then the shorter string is "greater than" the longer. For example, &qu...
by ray.wurlod
Sun Feb 07, 2010 11:47 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: core.* files
Replies: 12
Views: 6072

Prevent the error by using date strings that match the format strings supplied.

It's no surprise that the log contents are in the core file - after all they are in memory having been transferred through memory to the conductor process which looks after all logging.
by ray.wurlod
Sun Feb 07, 2010 11:44 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: sort and hash partitioning
Replies: 4
Views: 2501

Sorting is required because of the way that the Join stage works. Even though the hash partitioning directs every row with value "X" to the same partition, there's no guarantee that they're adjacent rows in the data. Auto partitioning on a Join stage will give you "Hash". This ma...
by ray.wurlod
Sun Feb 07, 2010 11:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: I always get an error msg: ds_loadlibrary: error in dlopen
Replies: 15
Views: 6578

Actually there wasn't that much more, so I'm removing the Premium nature of that post.

Selamat jalan
by ray.wurlod
Sun Feb 07, 2010 4:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: calling jar file from DataStage
Replies: 6
Views: 4015

suman27 wrote:Thanks for all ur replies.
Ur? Ur was a city in ancient Babylon or thereabouts. The second person personal pronoun (possessive case) in English is spelled "your".
by ray.wurlod
Sun Feb 07, 2010 4:12 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Dynamic MetaData
Replies: 2
Views: 1201

Yes, but probably no. It depends on how dynamic you want to be, and how your job design needs to affect the data. A combination of schema files and runtime column propagation can mean that reasonably unspecified data can flow through but, as soon as you need to apply any kind of transformation, your...
by ray.wurlod
Sun Feb 07, 2010 12:27 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Dataset Query
Replies: 10
Views: 2586

To be honest, I don't recall. I vaguely remember that the configuration file with which the Data Set had to be read had to be "compatible" with the configuration file used when the Data Set was written.
by ray.wurlod
Sun Feb 07, 2010 12:25 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: String Comparision
Replies: 3
Views: 1152

You're almost there. Strings are compared character by character. If, when the end of the shorter string is encountered, no difference has been found, then the shorter string is "less than" the longer string.

No padding occurs.
by ray.wurlod
Sat Feb 06, 2010 6:45 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: I always get an error msg: ds_loadlibrary: error in dlopen
Replies: 15
Views: 6578

Well, U (one of our posters) may not mind, but I do. Premium memberships are one way that the hosting and bandwidth costs of DSXchange are defrayed. I do not intend to set any precendent that might prejudice this funding by bypassing it. The second person personal pronoun in English is spelled "...
by ray.wurlod
Sat Feb 06, 2010 6:41 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Get Running jobs list
Replies: 12
Views: 4160

Director would be a manual process and switching projects manually would take time. So I would prefer to use the ps unix command. But the question what I have for ps command is that, if the team has opened the jobs in designer, will this ps command bring those processes as well? Thanks These are ne...
by ray.wurlod
Fri Feb 05, 2010 5:43 pm
Forum: Site/Forum
Topic: Changed DSXchange Behaviour
Replies: 7
Views: 6441

Managed to reproduce the problem yesterday on a desktop machine in the bank where I'm currently working (using IE), and on a Mac iBook (using Safari). In even more wierdness, today the problem is different (on laptop using IE and wireless modem). Today, the orange "unread" icons all change...
by ray.wurlod
Fri Feb 05, 2010 5:40 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error: Server auth failed or EE authorization failed
Replies: 7
Views: 2016

Beware when upgrading to Information Server version 8 - you need to install the 64-bit WebSphere Application Server (and the C++ compiler) before installing Information Server itself.
by ray.wurlod
Fri Feb 05, 2010 5:37 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Generic Job -- Unable to see the log
Replies: 18
Views: 5290

What are the values of RTLogging and ORLogging in the DSParams file in your project? You may need to use the Reporting Console for Information Server, rather than Director, to view the logs.
by ray.wurlod
Fri Feb 05, 2010 5:36 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: replace string
Replies: 5
Views: 2080

We're getting close. Use Field() to isolate everything to the left of the first caret character. Put that in a stage variable. If there is a small, finite number of possibilities, for example three, you can use Index() and Field() functions to determine the first, second, third occurrences of left p...
by ray.wurlod
Fri Feb 05, 2010 5:32 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Get Running jobs list
Replies: 12
Views: 4160

Use Director status view, disable display of Category and sort by status (click in the grid row header to sort). You can print this report, or print to file.