Search found 53125 matches

by ray.wurlod
Thu Aug 25, 2011 3:14 pm
Forum: General
Topic: Error in Installing DataStage 8.1 in AIX
Replies: 3
Views: 2709

Check that the machine is correctly recorded in Yellow Pages
by ray.wurlod
Thu Aug 25, 2011 3:43 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Issue In Reading and Inserting CLOB Column
Replies: 2
Views: 1268

Make sure that the receiving field is large enough for the data you're sending to it.
by ray.wurlod
Thu Aug 25, 2011 3:42 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Subtraction of values using Stage variables in a transformer
Replies: 4
Views: 2457

It's very straightforward. Show us what you've attempted, and explain why it's not producing the expected output.
by ray.wurlod
Thu Aug 25, 2011 3:40 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Internal Error: (destConcField->fixRunAnchor_f)
Replies: 10
Views: 6342

So it could be ANY active stage (any active stage effects a transfer from its input to its output)?
by ray.wurlod
Thu Aug 25, 2011 3:39 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Comma seperation in the amount value
Replies: 1
Views: 1633

Really 100,000,0.00 ?

I would have thought 1,000,000.00 (Western) or 10,00,000.00 (Indian) only.

In any case, if source and target are both VarChar, then it's simply a matter of manipulating substrings and concatenating comma characters where appropriate.
by ray.wurlod
Thu Aug 25, 2011 3:36 am
Forum: General
Topic: Common Warehouse Metamodel
Replies: 4
Views: 2070

MetaStage stopped existing with version 8.0.
by ray.wurlod
Thu Aug 25, 2011 1:28 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Writing in multiple files according to column value
Replies: 6
Views: 4103

This is most easily accomplished with a server job and a Folder stage.

You may be able to encapsulate the Folder stage in a server Shared Container and use that in a parallel job - though that's not something I've tried.
by ray.wurlod
Thu Aug 25, 2011 1:27 am
Forum: General
Topic: Folder to Folder copy in Designer client
Replies: 6
Views: 2567

You cannot move folders. You can, however, multi-select all the objects in a folder and drag-and-drop them to a different folder.
by ray.wurlod
Thu Aug 25, 2011 1:26 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Sparse lookup on Mainframe db2 using Db2 connector
Replies: 9
Views: 4395

Not directly.

If you have a local DB2 instance, you may be able to map the mainframe DB2 through that.
by ray.wurlod
Thu Aug 25, 2011 1:24 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Internal Error: (destConcField->fixRunAnchor_f)
Replies: 10
Views: 6342

Exactly this issue, with exactly this set of error messages? Using exactly the same version that Lance was using on exactly the same hardware?
by ray.wurlod
Thu Aug 25, 2011 1:22 am
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: NLS error
Replies: 2
Views: 1926

When you say "worked fine in 7x" was this with exactly the same data?

The error message suggests that there's an unmappable character in or near row number 11.
by ray.wurlod
Thu Aug 25, 2011 1:18 am
Forum: General
Topic: log
Replies: 6
Views: 1699

The easiest way is to use the DataStage API. There is a DataStage BASIC version and a C version of this API.

I'm wondering how you queried the RT_STATUSnnn table when no column names/definitions exist for these tables.
by ray.wurlod
Thu Aug 25, 2011 1:16 am
Forum: General
Topic: Different values from shmtest
Replies: 2
Views: 905

1) The values returned by shmtest are affected by everything happening on the machine at the time. Presumably your total load varies over time.

2) Leave the settings at their default values unless advised to change them by IBM support.
by ray.wurlod
Wed Aug 24, 2011 4:13 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Error Scenarios
Replies: 3
Views: 1089

A useful specification, which should allow you easily to implement the job sequence to bring about the required functionality. Well done.
by ray.wurlod
Wed Aug 24, 2011 4:09 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Internal Error: (destConcField->fixRunAnchor_f)
Replies: 10
Views: 6342

Why do you guess that a Funnel stage is involved?