Search found 53125 matches

by ray.wurlod
Tue Oct 07, 2008 12:32 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Automate metadata creation
Replies: 5
Views: 1541

Looks like the DSX file might have become corrupted. What's been used to open it since it was exported?
by ray.wurlod
Mon Oct 06, 2008 11:46 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Enabling Bulk Mode in DRS
Replies: 7
Views: 1279

You might like to mark the thread as Resolved.
by ray.wurlod
Mon Oct 06, 2008 11:45 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Writing Array values into a Sequential File
Replies: 3
Views: 1180

To obfuscate the cp command. Whatever the goal was, it's been reported as Resolved.
by ray.wurlod
Mon Oct 06, 2008 9:05 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Enabling Bulk Mode in DRS
Replies: 7
Views: 1279

The dynamic RDBMS Stage takes advantage of the native interface of the database. You can also load data in bulk mode.

Read that as meaning that you can load data in bulk mode if you use some other stage type than Dynamic RDBMS stage - that is, one of the bulk loader stage types.
by ray.wurlod
Mon Oct 06, 2008 6:47 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Writing Array values into a Sequential File
Replies: 3
Views: 1180

RT_BP809 is not a hashed file. Or even a hash file. And attempting to open it to a misleading file variable name is Bad Practice. Ans contains the source code generated by compiling the Transformer stage. Because RT_BP809 is a directory, then JOB.1228413061.DT.148684468.TRANS1 is already a sequentia...
by ray.wurlod
Mon Oct 06, 2008 5:25 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Reject record with NULL from src loads to a mandatory column
Replies: 2
Views: 984

WHY does it "come through as zero"? That is, what configuration of your job specifies that null is to be converted to zero? Hint: look very closely at all the column properties of whatever stage type connects to your source.
by ray.wurlod
Mon Oct 06, 2008 5:23 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Clear the rows before inserting depending on non key coloumn
Replies: 18
Views: 3824

"Share" in what sense? It's a database table in the DataStage Repository database.
by ray.wurlod
Mon Oct 06, 2008 5:23 pm
Forum: IBM QualityStage
Topic: Name Standardization - How it works?
Replies: 5
Views: 3709

You DO have overrides. It is accessed from the Rules menu. There are limits. For example, how should you parse FF (for example ELTON JOHN)? The default out of the box is {FN} {LN}. Run the Rules Analyzer over WORKER JOHN SMITH (or anything else that generates WF+ pattern). What fields do the data ge...
by ray.wurlod
Mon Oct 06, 2008 3:48 pm
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: SQL Server Connection error
Replies: 1
Views: 1327

They are not errors. They are informational alerts.
by ray.wurlod
Mon Oct 06, 2008 3:44 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: deleting a category from Admin or UV
Replies: 4
Views: 1261

Yes, but don't. Use the GUI client. There's no point re-inventing the wheel, and there are so many things have have to be checked, as well as the necessity to cascade the delete to all objects in that category in both the local repository and the common repository.
by ray.wurlod
Mon Oct 06, 2008 3:42 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: blink error not in log
Replies: 5
Views: 1728

Get a premium membership.

Premium membership is one of the mechanisms through which the hosting and bandwidth charges incurred by DSXchange are defrayed. It's not expensive, at less than 30c per day.
by ray.wurlod
Mon Oct 06, 2008 3:39 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Regarding Encrypted Parameters
Replies: 5
Views: 1511

Already did.
by ray.wurlod
Mon Oct 06, 2008 3:39 pm
Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
Topic: Problem with multiple instance jobs
Replies: 1
Views: 1084

Do you have fix pack 1a installed?
This is a roll-up of quite a number of bug fixes, and is pretty much essential.
by ray.wurlod
Mon Oct 06, 2008 3:36 pm
Forum: IBM QualityStage
Topic: Name Standardization - How it works?
Replies: 5
Views: 3709

USNAME out of the box expects a comma in lastname, firstname. You can amend the rule set using various techniques - to drop the W token I would suggest an input pattern override.
by ray.wurlod
Mon Oct 06, 2008 8:22 am
Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
Topic: Passing Set of values from a data base table to Sequence Job
Replies: 7
Views: 1552

... which is exactly what I suggested when you asked about four values.