DSXchange

i guess. see am guessing, i guess. ok Sequential_File_0,0: Consumed more than 100,000 bytes looking for record delimiter; aborting Sequential_File_0,0: Import error at record 0 What is the first record in your head file. Does it have column header. Do it have more than 100,000 character. And what is...

Why dont you give trim(varahcar column).
is it a fixed lenght or delimited file?

What is the value of the environment variable NLS_LANG?

Is it going to insert always? Do you have any surrogate key or increasing sequence number in the table? If that is the case get the max number before load and have a filter in between dataset and connector stating key greater than max. And what is the database that you are loading? Does it have tabl...

what is the default code page ?
Please post a table that has SrcSysCode column

Hmm i expected this. Can you explain how we are acheiving it in higher version

If you are in version 8.5 and above,you can use the power of transformer caching.

this is a good solution and workable.
For the issue that you are facing can you post the structure of the table that is throwing warning,
and also In the odbc connector what is the character set that you have provided

yeah you know the data very well. you can repeat the function any number of times. guess 25 will be better

There must be a size for the input column so we can somehow conclude the value N.
And in the above solution irrespective of any number of words in input it will gives us result

For now i can think like this. Considering the maximum number of words as n. LEFT (FIELD (lnkIp.ip_column, " ", 1), 1) || LEFT (FIELD (lnkIp.ip_column, " ", 2), 1) || LEFT (FIELD (lnkIp.ip_column, " ", 3), 1) . . . || LEFT (FIELD (lnkIp.ip_column, " ", N), 1) ...

is space only the delimiter for the words?
is three words the maximum?

are u mentioning anonymous blocks here

what is the xpath for termRef

Please post the Xpath and key column defined

Ray, 15 Minutes is it configured somewhere or its common? What is happening actually. Are there any process that cleanups the lock record in Xmeta