DSXchange

You have mapped a col defined as string (char or varchar) to a col defined as date. Check it in the transformer stage. You may need any conversion function.

Is your transformer the very last stage before writing to the target file?

You need to take the rightmost char to check whether it is a sign. Try using what you have learnt earlier.

Maybe a simple Trim(YourNumber, ',', 'A')

If the comma symbol is not in the data, then a direct move will suffice.

You can. But it depends upon the method you chose in the source.

Search for forum.

You need to see from where the 'with NC' appeared from?

As CHullet sugested, get on to reading the docs.

I will suggest you to search the forum before posting a question.

Did you try using Pivot or hash files?

Use @date instead of the parameter.

Note - Pl post in the appropriate forum.

KDuke,

The question from the o/p (as I read it) was 'The range check cannot be done using hash file? Is this assumption correct?'

I believe he is correct as we need to make it adaptable to UV stage to facilitate this process.

Hash file reference must work fine. It happens when you use non-DS connections.

NOTFOUND is known to return incorrect values.

You are right that it cannot be done directly in hash file.

What other database you are using? You may be able to include it in your normal db space.

Doing the source is the best.

Complicated and bottle-neck SQL can be enhanced and new stages be created in DataStage. But nothing can be said without seeing and understanding the SQL and data.