Search found 53125 matches

by ray.wurlod
Wed Oct 17, 2012 2:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: To get data before commas and pipe
Replies: 5
Views: 1890

With a BASIC Transformer stage you can use multi-value-handling functions such as Fields().

Code: Select all

Convert(@FM, ",", Fields(Convert("|", @FM, InLink.TheString), ",", 1, 1))
by ray.wurlod
Wed Oct 17, 2012 2:19 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Paraccel or Kognitio Compatibility with DS
Replies: 1
Views: 899

Short answer is no. But if you can find an ODBC driver for them, DataStage can use that.

Stay tuned for new name for Netezza to be announced at IOD2012.
by ray.wurlod
Wed Oct 17, 2012 2:15 pm
Forum: General
Topic: deleting jobs manually as they are locked in xmeta.
Replies: 4
Views: 2370

No. If there are no abandoned locks it will do nothing.
by ray.wurlod
Wed Oct 17, 2012 5:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: input file data sort order and output file data order
Replies: 3
Views: 1186

Text file or hashed file?
by ray.wurlod
Wed Oct 17, 2012 5:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: input file data sort order and output file data order
Replies: 3
Views: 1186

If it's a server job why did you post it in the forum for parallel jobs?
by ray.wurlod
Wed Oct 17, 2012 5:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: if then else
Replies: 4
Views: 1262

In an expression IF must have THEN and ELSE. There is no END IF.
by ray.wurlod
Wed Oct 17, 2012 5:31 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Number of Input and output rows are not same in Hashed file
Replies: 3
Views: 1613

Welcome aboard.

If the key is the same as that of a row already in the hashed file a destructive overwrite occurs. That's the way hashed files work.
by ray.wurlod
Wed Oct 17, 2012 5:29 am
Forum: General
Topic: Add Checkpoints so sequence is restartable on failure
Replies: 8
Views: 3303

What is causing the sequence to abort when one of its jobs aborts? Is this how you've set the automatic error handling?
by ray.wurlod
Wed Oct 17, 2012 5:28 am
Forum: Site/Forum
Topic: 40k+ users
Replies: 18
Views: 21443

Why? "More than 30,000 Users" remains correct, does it not?

Changing it would involve someone the website currently doesn't have to wade through reams and reams of PHP code finding the reference to the animated image.
by ray.wurlod
Wed Oct 17, 2012 12:56 am
Forum: General
Topic: Add Checkpoints so sequence is restartable on failure
Replies: 8
Views: 3303

Did you recompile the sequence? This will remove all checkpoints.
by ray.wurlod
Wed Oct 17, 2012 12:43 am
Forum: General
Topic: Peanuts
Replies: 1
Views: 874

Peanuts

Early notice - "they" are producing a new Peanuts movie in late 2015.
http://kirkstonetech.com/movie/press.html
by ray.wurlod
Tue Oct 16, 2012 3:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Server to Parallel job conversion
Replies: 6
Views: 2354

The first thing to consider is whether it makes sense to undertake the "conversion". Server jobs are not going away. And they are more efficient for small data volumes than are parallel jobs. Other than that, the best way to convert is, indeed, to analyze the logic of the server job and to...
by ray.wurlod
Tue Oct 16, 2012 3:11 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Oracle Connector Import Converts Date into Timestamp
Replies: 3
Views: 1262

All DATE data types in Oracle have a time component.
by ray.wurlod
Tue Oct 16, 2012 3:08 pm
Forum: General
Topic: ISA Lite shows missing libXp.so.6 library
Replies: 2
Views: 1237

Does your shared library search path (LD_LIBRARY_PATH) include the parent directory of this library?
by ray.wurlod
Tue Oct 16, 2012 3:07 pm
Forum: General
Topic: Query XMETA for bulk job statuses
Replies: 2
Views: 892

Re: Query XMETA for bulk job statuses

iShoreETL wrote:I am aware this information is stored in XMETA database (which we have in SQL Server).
What makes you think that this is the case? Can you provide a reference?

Last time I looked (version 8.7) job status was still stored in RT_STATUSnnn in the local (project) repository.