>I am appending Data in a cursor from Text File using Append from abc.txt SDF. The problem is that, of around 700000 records certain records have length of 255 and 256 Characters and therefore the last one o two digits or few characters are not appended properly.
>
>Is there any way like when I append and of the length exceeds 254 Character than the rest of the digits are appended in my next Field(column) or any other Idea to solve such Issue
>
>Regards
Why can't you create a table that has another column next to it, and then combine the two into a memory variable for processing?
CREATE CURSOR c_loader ( cLine c(254) )
CREATE CURSOR c_loader ( cLine c(254), cOverflow c(254 )
APPEND FROM abc.txt SDF
lcLine = RTRIM(c_loader.cLine + c_loader.cOverflow)