DSXchange

Funny (to me anyway) that neither reply so far has even attempted to answer the question as posted.

Unless someone here knows for certain, I'd suggest you contact your official support provider and ask them then let us know what the answer is.

There should be (I believe) an option to reference the sql filename in the stage and have it read it in at runtime. You need to do something like prefix it with {FILE} but I'm not positive of the syntax. A search with the proper terms should turn something up as we've discussed this before.

I don't believe so. Let's see what others think.

It would be helpful if you detailed the job design and expanded on what exactly "congestion in netezza box" means and how it seems to be affecting your job.

... and the resolution was?

Suggestion. Next time you find an old similar issue, do what you did here - start a new post and reference the older post. Do not 'hijack' the older post and for goodness sake please don't do both as you did today.

If you are saying your account there is disabled, have your DBA fix that for you.

If there is, it would have to come from the ODBC vendor I would think. That or perhaps you should contact your official support provider and get their help.

I'm not really suggesting anything, just trying to point you to posts which talk about loops and how to handle the counter properly so you could figure out your next steps on your own. Did you check them out? In the meantime... I'm a little lost on what you are trying to accomplish with the UserVari...

So... in case it's still unclear what needs doing here... your final UNIX command that gets run after the two "halves" in the stage are put together need to look like one of these two: cd \The\Director\Where\TheFile\Lives && wc -m Reject_UK_VAT.txt -or- wc -m \The\Director\Where\Th...

Yes. In PX it would be directly from the stage, source or target, not off the Transformer like you would do in the Server product.

To quote some old movie: They have chosen... poorly.

This should help with the $Counter question, there are plenty of others out there if you search:

viewtopic.php?t=111013

This one might help as well:

viewtopic.php?t=127425