DSXchange

However, much like you can launch a sqlplus session and run a query from the command line, you can so something similar with 'dssh' as long as your hashed file is account-based.

I would work with my DBA, if I were you, ask their help in getting things setup properly for sqlplus.

Your biggest issue, IMHO, is the fact that you think you have Arabic data in your US7ASCII-based Oracle database. As noted, it cannot.

Have you tried simply using them in your reject processing rather worrying about what you think you see in them? Any issues? What does the log file say is the reason they were rejected?

That depends entirely on how you are viewing the file. I use putty for my UNIX sessions and it allows me to select / switch charactersets on the fly.

I searched as well. Here's one of several:

viewtopic.php?t=120271

For Windows I would assume it's a service so you'd need to verify that it is running. For UNIX, a process started via the PXEngine/java/jobmoninit script.

I also asked you to post it in the proper forum when you did so... and you did not. Why is that so hard?

Yes, you can tell it to 'cycle' through a list of values from what I recall.

chulett wrote:Suggest you repost this in the proper (Enterprise) forum and... finish your sentence.

So... in case that was unclear: Post this again in the Enterprise Edition forum, this one is dedicated to QualityStage issues. That and post a complete description of your issue when you do so.

All columns defined in the stage must be bound into the sql, hence the methodology that I suggested.

Hmmm... ok. Then please mark the post as Resolved using the button at the top of the page!

Why does your job have any kind of "out link" on the UV stage? All you'd really need is something to feed the UV stage - typically a Transformer that's playing the role of Row Generator - and the UV stage with a single input link. Me, I would pass a single row in with a single field having...

That's definitely the kind of thing I would report to my official support provider... something like that should never be "undefined".

Check out the RESIZE command. Not sure the purge affects the OVER.30 and DATA.30 goes down in Page Size increments but resize should get both, I do believe.

What does it say when you hover over the warning symbol?