DSXchange

It won't be DataStage that's "not allowing".

Odd. Are you looking for one total, a running total, or ?? It's not clear what you need, can you post the output for your sample input?

dsuser7 wrote:Please mail me at ds.user7@yahoo.com, if your response is lengthy

Sorry, but that's not how things work here.

Note that whatever value you set in the Administrator becomes the value used in any new jobs added after that, in case that wasn't clear.

Have you read the stpstage.pdf documentation? A proc needs to be written in specific ways to be usable with the stage, your issue may lie there. Check the Additional Database Specifics section in particular.

The 'performance statistics' shows how many rows were successfully sent to the target, not how many tried to go. BIG difference. So you've got enough valid data to satisfy the constraint but there's something wrong with one or more fields that the database doesn't like. "Blanks" aren't necessarily a...

There's no way around needing that drive 'mounted' in some fashion so the UNIX system can see it, as far as I know - NFS, Samba (etc) is needed to read it directly from that share. Or just FTP it.

Post your actual unedited constraint, things are obviously slipping through it that shouldn't. And then explain in words what the business rule should be.

Seems to be a continuation of this post:

http://www.dsxchange.com/viewtopic.php?t=123855

Why not simply ask your team mates what they did to get it successfully installed? Or as Arnd noted, state the actual problem that you had.

Still, not supported. For whatever that is worth to you.

Yes. Failure before job will stop the job execution, both failures will set the job status to Aborted.

You do realize that Windows XP is not supported for the server component, yes? Client, sure, but server - no.

What database? Suggest you read the Additional Database Specifics section of the stpstage.pdf document for your particular database.

Gonna need a lot more information. What variables did you setup in the Administrator? How are you using them in your job? What role does your dsenv file play in all this?