DSXchange

here is a workaround based on your statement. We expect only 1 per day Get the name of the latest available file in your folder with a Unix command whichever you are comfortable of, or if you are cleaning the files after processing then take the file name(s) that are not processed. This should be go...

Am curious about the solution that you used.

It tells the datastage in what language it has to read/write with OS data.
Say like if you want to write french character in to the OS. You must mention that the data is having french language so that it gets written in proper format

What we need to think of is what we will be doing with the multiple records after the lookup. Are you going to take the maximum of date. If there are overlapping timelines in the lookup data, guess it will not be meaningful and giving proper results to us. (It is totally a invalid data, at some poin...

Oops . regret team.

What is the target data type?

Guess you are trying acheive this?

array size = buffer_size/row length.

Ok let me ask like this
CLOB parameter is IN OUT,
what is the value that is actually being passed (IN)
what is the derived Output value (OUT)
or it is both same?

My first question was that what is the length, but didnt hear anything from OP.
But why the error is thrown at some other line?

Yes craig it was less than 4k. But the error shown is reverse of what is happening.

One more question. Do you have Oracle native installed?

Can you check code.at line mentioned in error 167.
I have successfully implemented with varchar.

CLOB can hold up tp 4gb but can you judge what will be the length of input column, Varchar should hold good. Check whether the error is during call of procedure or within procedure

Try with Unknown datatype.

Then setnull should be working in your version. Can you try this make the parameter as true. Use setnull instead of space and check whether it.works as expected

Also in the director, for the run, check the monitor. How many records are read from the sequential file stage. It should be zero. Correct?