but the above script prefix each line with 2 junk characters. I cannot cast the output as char(xxx) as it will increase the size of the output file. I tried using Vartext format in the script, but that too is not supported in the ttu7 version that I have. So I tried using the Outmod, but I am not sure how can I use outmod in teradata.
have u got any concrete solution to the Problem as i am also facing the similar Issue.. Exported file contains two byte of Junk character.. Is Vartext is supported in TTU V 8 and above ?? i am getting an internal error while running through vartext.. any help in that regard is highly appritiable
FastExport does not support VARTEXT output. Depending on the size of the file, perhaps using some other utility or tool would work better for you.
Or if you concatenate all the fields to a single delimited text string in FastExport (as in the original post in this thread) you can use a simple OUTMOD to strip the leading two-byte length field from each record.