DSXchange

Hi Sunil , Without a backup of your old job then I think you're out of luck. Importing a job (or any other object, for that matter) into the repository replaces identically named objects irreversibly. Are you sure you definitely don't have a DSX somewhere that contains the prior job definition? Do y...

You might want to start with one of Vince's excellent blog entries ...

http://blogs.ittoolbox.com/bi/websphere ... reer-16570

Hi Akhila -

You don't need to use a function, just specify the appropriate precision and scale in the metadata of your output link. In your case you will want a scale of 3 for your output decimal column.

John.

It looks as though you've run out of disk space (The first message is "No space left on device".) Speak to your system administrator.

The Modify operator is more fully (i.e. correctly!) documented in the Orchestrate Operators Reference.

1. What's the problem with dsjob. Are you getting an error message? You'll find plenty of posts on this topic on dsxchange. 2. So you want to 'parse' a list of parameter values? Presumably there are a variable number of parameter rows, with each row containing a set number of parameters for the spec...

What are your rules for joining the data?

From your example we could infer you are intending to join Ascending ENO on descending SAL - Right?

J.

Glad you got it working.

You might want to set this topic to 'Resolved'.

A Full Outer join delivers rows from the LEFT dataset which don't match the RIGHT, and vice-versa. This means you NEED to be able to differentiate which input links each row originated from. A common approach is to use a downstream transformer to check which key columns contain nulls and execute som...

I think Bob is referring to the use of a comma as a decimal delimiter (as commonly used in mainland Europe)

J.

So, if I understand correctly, you want the first 3 rows of a Col1/Col2 key par to go to File1, and the remainder to File2? If so, try the following ... Use a Sort stage to sort your input by Col1 and Col1. Add a 'KeyChange' column (generated by the sort stage) to indicate a change in Col1/Col2 valu...

Does the help not clarify it for you? :- "Use a right-justified comparison for numeric strings, use a left-justified comparison for text strings. For mixed strings, take care. For example, a right-justified comparison of the strings AB100 and AB99 indicates that AB100 is greater than AB99 since...

You can find source code for two parallel routines here:

<a href="viewtopic.php?t=106358">pxEReplace</a> and <a href="viewtopic.php?t=107882">matchRegexp </a>

HTH,
J.

Would "Read the manuals" be too obvious a suggestion? The Parallel Job Developers Guide is a good place to start. Do you have access to a working DataStage installation? If so, I assume you're on a project and can tap the knowledge of your co-workers - at least some of whom, I hope, are NO...

You could pass your file via a 'Filter Command' to translate the multi-character delimiters into something you'd prefer. Remember to check the box on the Stage/General tab to enable Filter Commands.