DSXchange

Sorry but what aspect of this do you need help with? It all looks pretty straight-forward to me as you basically have the derivation expressions spelled out for you in the requirements you've been given. Do the calculations in stage variables and then set up the derivations for the two "AMT&quo...

Just because it's valid COBOL syntax doesn't mean the stage supports it. We've seen those kind of issues before here, best to check with IBM as you noted.

Initial Value of GroupNumber = 1

Prefer any flavor of UNIX.

Well... you can certainly filter using constraints in a transformer and then put the results into a hashed file to perform the lookup against in a subsequent transformer.

I'm curious... are we resolved here now?

ds_8112 wrote:( I mean from the end loop activity stage we can have only one link back to the start loop activity stage)

Not true. That link back to start is created automatically but you can certainly create links that go onwards from that stage to whatever you need to do once the loop finishes.

... and make liberal use of Preview until everything really lines up properly when posted.

Just to complete this, the CWD or Current Working Directory of any running job is the base Project directory of the job. That is where it is looking for your file.

The type function can't find "tableNotFound1.txt" - fully path it or "cd" to the directory where it lives first to use that relative path.

Wanted to check as you can't execute a command on a drive letter without switching to that drive first. What does the .bat do? Guessing the error is from an internal step as the error would be different if it wasn't finding the batch file itself: 'whatever' is not recognized as an internal or extern...

So then we're resolved it would seem.

I understand what it could be, would like the original poster to clarify what it actually is. And don't read too much into examples posted, as many times they are made up and can differ from reality, especially when they start with "for example" or "something like this". :wink: A...

What drive letter is DataStage installed on - something other than D:?

Do you have any options to override the default behaviour of the ORDER BY clause? Don't know squat about DB2 but I saw mention of a COLLATION_KEY option...