DSXchange

I, on the other hand, "have heard" that someone in Nigeria wants to deposit $40M into my bank account.

Please don't just go with "I have heard" - cite sources so you and we can check.

nandela.sudheer wrote:i need to know where it is stored "DSParams" file in datastage

Why?

Did you Search here for the answer?

Try setting Final Delimiter = End

These are the data files associated with YOUR Data Sets. It's your decision about whether or not they're still needed.

Tip: don't delete them directly. Use the Data Set Management tool or the orchadmin command to delete them, so that you don't leave orphans hanging around.

... which you can determine with an IsValid() function, probably in an If..Then..Else construct.

Use IsValid() to test whether the input is valid as an unsigned integer in an If..Then..Construct and set zeroes in the Else part.

Given that your operating system is Windows, you can only use version 7.5x2 for parallel processing capability unless you upgrade to any version 8.

Please post the precise data type of both input columns and of any output columns derived from either.

Try using CAST rather than CONVERT.

There IS NO documentation.

A Search will reveal the reasons.

Essentially, though, IBM regard the "internals" as their intellectual property.

There are two schemes of parallelism. Pipeline parallelism (the one implied by the original question) and partition parallelism (the one implied by Craig's response to Oritech's unrelated question). You can read about both in the Parallel Job Developer's Guide. To address the original question, idea...

Let's just stay with "network node name" for now - "server" is ambiguous in the current context. Network node names occur in the hosts file or are decodable through services such as DNS (domain name service). It depends on your particular installation, and is not part of DataStag...

Use a user variable in a sequence, pass it to other components as a parameter/argument.

Why don't you think an environment variable would be safe?

It (the output from LIST.READU INTERNAL) is a dynamic array. You have to extract the date from the dynamic array using DataStage BASIC.

You are at the forefront of those trying to understand the relationships between tables in the unified metadata repository. Good luck.