Solved! Go to Solution.
According to this post :
It should be working as long as your CR/LF is embedded in a delimited string.
Also, check for the TPT version you're using with command "tbuild -V" as TPT carries these features, not the database.
Thanks Walder for your quick reply,
We are using TPT version 16.10.00.05. Also, sorry i forgot to mention in original post that i have tested the CR/LF embeded in data using delimited data file and TPT option 'DELIMITED' and it workd fine. But this dosen't work with Fixed Width Data File. So based on the post it looks like Teradata TPT dosen't support CR/LF embeded in data for fixed width files. Is that right ?