DSXchange

You would send a single non-null field down another link to the Aggregator and tell it to count that. Doesn't even have to be a "real" field, you could hard-code a value.

While you are reading/processing it? Aggregator. Before or afterwards? Sequence job as noted.

It's related.

It is driven by the stage name, not the job or any other name. Do not try to type it in manually until you really know what you are doing, use the External Parameter Helper available under the ellipsis (...) to show it to you and select it from there.

OK... time to put Arnd's suggestion to work.

You may have missed it since we posted simultaneously but I did link you to the post I assume Ray was mentioning.

As you noted, this has nothing to do with DataStage or ftp and is what Excel does when it sees something that it "knows" is a number, it will convert it including removing any leading zeroes since they're just icky and get in the way. :wink: There's lots of information out there on how to ...

No solution yet, though.

Probably a silly question, but you don't mean you literally put the words "my server address" in the stage, do you?

And that "DoNothing" exit from the loop can be a Sequencer if you just want to stub it out or another string of stages if you need to do something afterwards - send an email, run more jobs, etc.

Or that.

That's because, by default, all your exit status indicates is the ability to execute the sqlplus command itself, it could care less what happens with the sql you run inside the session. You need to capture the output from the sql session which can be as simple as redirecting it to a flat file. Then ...

Hmmm... all the -21 means is "error when executing external command" so not all that helpful. Are you using attachment option built into the stage or doing something else?

That particular option simply says to run a single-threaded direct path sqlldr session. It implies something about any indexes but doesn't "skip" anything. Have a chat with your DBA if you are unsure how sqlldr and those kind of options work.

sri_vin wrote:Craig, The select statement doesn't work.

You do realize that still doesn't help, yes? What "doesn't work" about it? Are you getting errors? Invalid results? Crashes your server and kicks your dog?

There's no "else" to stopping. From your Execute Command stage, link a zero trigger to a stage after the End Loop. The >0 trigger goes to the End Loop stage.