DSXchange

How are you building the query? Can you try using generated SQL, where you enter the table name manually? If you use the SQL Builder, make very sure that you include the step of adding the table name.

Another possibility is that someone or something killed the main process of the job.

Please explain how this behaved in the previous version and how you allege it behaves differently in the new version.

You should be able to do this mass delete off the results of a Quick Find or Advanced Find in 8.x. You may also be able to do it by opening the detail view (the slide out) from the Repository tool in Designer.

Premium membership is the funding model that keeps DSXchange alive. Notice the lack of advertising? Premium membership is not expensive, at less than 30c per day. All of the premium membership revenue goes towards hosting and bandwidth costs of DSXchange. I counsel that you obtain a premium membersh...

Can u please share the code u developed to create the custom stage. Was it developed for Unix environment. That's a totally unreasonable request on two counts. First, it was SURA, not U, who developed the custom stage and, second, it's probably implementing some task that is subject to a non-disclo...

What NLS map are you using?

Do some research to learn which subdivision of ISO8859 includes Greek characters.

Not really. Column Analysis performs a huge amount of work. You can verify this by monitoring your Engine while Column Analysis is running. Some people like to profile fewer columns at a time to give the illusion of faster completion, but the total time is roughly the same. Of course, you can elect ...

I'd use a Transformer stage. Sort your rows as part of the selection process. Set up your "inputs" as job parameters.

Create a stage variable for each condition (result is true/false).

AND all these together to get the logical result. Use that as your constraint expression.

Clearly the database to which the DRS stage connects is not accepting the reject rows for some reason. Take a look at the data in the text file to see what the problem is.

They're not distinguished. Blank = space. Are you perhaps using "blank" to mean "zero length string"? These can only be stored as VarChar data type, which has a length designator ahead of the string itself (shown as the "prefix" in a record schema). A prefix of 2 indica...

Buy less gas, etc.

The capitalists continue to get richer, though.

Can you think of any other way to do this? If not, what you have is the best (only) way.

As blanks. A blank is a character with an ASCII or Unicode code point value of 32 (of course, there are also double-width space characters in other character sets, but let's not go off on that tangent - they just have different Unicode code points).

How much real memory (RAM) does your client machine have?