DSXchange

Put B and C in a second sequence job and call that sequence job in your first sequence job. SOmething like A---->D Execption Handler----->Terminator D= B ------>C ------>C----->Terminator Activity Make the first sequence job that contains A and D restartable. And the second one remains without havin...

If your source is equally huge, go for a join stage to join the records. If your source is small, go for a sparse lookup.

Why are you getting warnings in the first place? As advised, remove the warnings. Dont set it to unlimited or you will, more than likely, fill up the space pretty fast and cause corruption.

As a test, try giving a hard-coded value to the Trim() function.

Minhajuddin wrote:Is that right Chulett?

If I may Craig,
Yes, that is correct, Minhajuddin.

Yes. You can pass TRUNCATE command in the OPEN/CLOSE command. It will be the most performant operation.

You can also pass the truncate command in the OPEN/CLOSE command of the enterprise stage.

Yes. That will work too. But still not quite like the matches function. But Count() and Index() they both will work, if you want to find a particular substring in a string.

Use Index() function. That should work.

StringToDate() should not have converted that string. I believe you have discovered a glitch. I advise to contact support about this behaviour.

Well as I said, it helped someone here to stop and start the server. Try that.

Unfortunately that does not work. Thats really odd. But the following works to remove tabs.

Reset the job and see if any additional message pops in the log that starts with "From previous run..."
There is another poster here who bounced the server to get rid of this problem. Search on the error message.

That is not correct. The conversion mask should be of the string and not of your expected date format. The date format will be determined by the default of your target stage or default set in the administrator.
Can you please tell how would you mask '0101254300150' ?

I tested all scenarios of Trim. It works for me on parallel. I am on 7.5.1A on HP-UX.