Search found 53125 matches

by ray.wurlod
Mon Jan 21, 2008 7:35 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: error while compiling transformer stage
Replies: 1
Views: 875

The system, as it tells you, can not find 'D:/PROGRA~1/MKSTOO~1/etc/cxx.ccg'.

What values have you set for APT_COMPILER and APT_LINKER environment variables?
by ray.wurlod
Mon Jan 21, 2008 7:29 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reusability
Replies: 3
Views: 1117

Place the stages in your template job, but do not provision them with metadata. Create a Template from that.

Then, when you create jobs from the template, either load the metadata or - if it is possible given your stage type selection - use the Schema File property duly parameterized.
by ray.wurlod
Mon Jan 21, 2008 7:25 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: XML file processing with missing elements
Replies: 5
Views: 1446

In XML a data element is (simplistically) a container for zero or more data attributes . In DataStage, a Data Element is a great way to attach more information to a column about its purpose and other business metadata. One can perform Usage Analysis on a Data Element, for example to answer the quest...
by ray.wurlod
Mon Jan 21, 2008 7:20 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: How to make the connection between datastage and DB2
Replies: 1
Views: 767

There's quite a lot to do. There's even a separate document about it, which should be available for free from your support provider.
by ray.wurlod
Mon Jan 21, 2008 7:15 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequentail file-Missing Column
Replies: 3
Views: 913

Map empty string means to write out an empty field - between two adjacent delimiters. Pad with empty string means to fill the designated field width with Char(0) characters - these are ASCII NUL bytes. Because C strings are NUL-terminated, these may look like empty strings in some viewers which is w...
by ray.wurlod
Mon Jan 21, 2008 7:08 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: returned null - error
Replies: 1
Views: 639

Welcome aboard.

Questions about parallel jobs should be posted in the parallel forum. When you do, please paste the exact error message (copy and paste it).
by ray.wurlod
Mon Jan 21, 2008 7:04 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: How to run SELECT from command line
Replies: 8
Views: 2813

Code: Select all

DSHOME=`cat /.dshome` ; export DSHOME
. ${DSHOME}/dsenv
cd ProjectDirPath
${DSHOME}/bin/dssh "SELECT NAME FMT '40T' FROM DS_JOBS WHERE JOBTYPEIND = '2';"
by ray.wurlod
Mon Jan 21, 2008 6:56 am
Forum: General
Topic: .DSX and XML
Replies: 4
Views: 1244

It's possible, but I am not going to set the precedent. Premium membership is one of the ways that the hosting and bandwidth charges incurred by DSXchange are met. It's less than 30c per day and good value with it.
by ray.wurlod
Mon Jan 21, 2008 4:38 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Two Different Server Installations on Same Unix Box
Replies: 14
Views: 4244

It's obvious from a number of posts in the past that a DataStage server machine can deliver an infinite supply of CPU, memory and other resources, so go ahead and throw more and more demands for resources at it. It'll cope!
Not.
by ray.wurlod
Mon Jan 21, 2008 4:36 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Sequentail file-Missing Column
Replies: 3
Views: 913

Doesn't your F1 key (help) work?
:roll:
by ray.wurlod
Mon Jan 21, 2008 4:35 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: What is tracemode
Replies: 1
Views: 687

It doesn't mean anything in parallel jobs. You have marked your job type as parallel. In server jobs it is a sum of powers of two associated with the stage tracing options on the Tracing tab of the Job Run Options dialog. Trace mode 1 also occurs if you're running in the Debugger, since it uses the ...
by ray.wurlod
Mon Jan 21, 2008 4:33 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Metadata Tables
Replies: 1
Views: 836

No.
by ray.wurlod
Mon Jan 21, 2008 4:32 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: LKP Job Got Aborted
Replies: 1
Views: 872

There is no "solution". Possibly there was a network interruption. Unless it occurs consistently there's no way to tell the cause.
by ray.wurlod
Mon Jan 21, 2008 4:30 am
Forum: General
Topic: .DSX and XML
Replies: 4
Views: 1244

DSX is more compact because it uses fewer tags. Therefore it is a smaller image, and emails faster.

Microsoft insists that the .dsx suffix means that it is a Visual Basic Designer Binary file, but they've been wrong in the past.
by ray.wurlod
Mon Jan 21, 2008 1:49 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Parse error on case string
Replies: 1
Views: 926

Post the design of your Switch stage.

Are your case values all in output link order? Do all those for output port #0 first, then all the values for output port #1 and so on. I've never seen this documented as a requirement, but grouping them thus does seem to help.