Search found 53125 matches

by ray.wurlod
Tue May 25, 2010 2:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: phone number
Replies: 6
Views: 2354

This particular operation is not possible in the Modify stage.
by ray.wurlod
Tue May 25, 2010 12:01 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Invalid character(s) ([xC0]) found converting string issue
Replies: 5
Views: 3193

Is this a binary (numeric) field that you're trying to read as a character string?
by ray.wurlod
Tue May 25, 2010 12:00 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Does Datastage V8.0.1 oracle stage support oracle 11g
Replies: 4
Views: 2476

Oracle 11g for the repository (XMETA) is supported in the next version (that's 8.x where x > 1).
by ray.wurlod
Mon May 24, 2010 2:15 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: What are dstage_wrapper_trace_2.log files?
Replies: 1
Views: 1599

There is no issue, and therefore there is no "solution". Up to 20 of these dstage_wrapper_trace logs are written into the ds_logs directory in the home directory of dsadm. It's simply a matter of "that's how it works". The message about duplicate xmeta.bootstrap.properties is spu...
by ray.wurlod
Mon May 24, 2010 2:10 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: 'Unit Of Work' commits?
Replies: 6
Views: 2476

The Distributed Transaction stage (version 8.1.2 and later) allows for transaction grouping, two-phase commit and lots of related things.

(I have to check which of this functionality is currently available and which is in the next release. But I am not currently able to do so.)
by ray.wurlod
Mon May 24, 2010 2:08 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to read "36,6"&#1072;&#1087;&#1090
Replies: 2
Views: 1022

Consider using a server job. Parallel jobs - in version 8.0.1 particularly - are notoriously flaky at handling quotes in data. Server jobs are much more robust. Even there, however, a partially-quoted field such as "36,6"апт is going to be challenging to handle. Is there any chance that th...
by ray.wurlod
Mon May 24, 2010 3:47 am
Forum: General
Topic: Creation of DSN Connection
Replies: 1
Views: 819

DataStage does not recognize User DSNs - you must use a System DSN or a file DSN.

Secondly, as well as setting up a DSN, you may need to record the fact of that DSN's existence in a uvodbc.config file.
by ray.wurlod
Sun May 23, 2010 3:58 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Column names with -
Replies: 12
Views: 3879

No it doesn't, but there's nothing to prevent you from mapping from the database name to a DataStage-legal name. For example, when selecting, use the database name in the Derivation column (the name may need to be in double-quotes).
by ray.wurlod
Sat May 22, 2010 9:30 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Performance tuning in DS for Join..
Replies: 4
Views: 2154

DataStage is unnecessarily re-sorting your data. Add a Sort stage to each input link to the Join stage. In each Sort stage specify "don't sort (already sorted)" for the sort key columns.
by ray.wurlod
Sat May 22, 2010 9:28 am
Forum: General
Topic: IOD EMEA Day Two
Replies: 11
Views: 6814

Futures

The usual caveat from IBM to begin with - what follows is an indication only of what's on plan - nothing is promised for sure, and there is no legal obligation incurred, blah, blah, blah. Second, there's a long open beta to happen before the next version of Information Server (Stewart Hanna said he'...
by ray.wurlod
Sat May 22, 2010 2:21 am
Forum: General
Topic: IOD EMEA Day Two
Replies: 11
Views: 6814

I have not forgotten you all, but it's been a hectic three days. Right now I'm posting from Rome airport, but there's only 30 minutes before my flight departs. Essentially the message builds on previous IBM direction. "Building a smarter planet" has morphed, at least for customers and busi...
by ray.wurlod
Sat May 22, 2010 1:44 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: istool - custom path
Replies: 8
Views: 2592

Perhaps search for *.isx then.
by ray.wurlod
Sat May 22, 2010 1:41 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Strange Error (Unable to determine current working director)
Replies: 2
Views: 1305

Make sure your PWD environment variable is set, even if it value is "." (current directory).
by ray.wurlod
Sat May 22, 2010 1:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Existing issue with Trim function but a weird scenario
Replies: 9
Views: 22597

APT_STRING_PADCHAR has always been 0x00 out of the box. I can therefore only assume that someone at your site has modified it previously.