I've tried this - not working. But if you observe the records are enclosed with double quotes (" "). In the table I don't want those double quotes obviously. For example - first column has a length of CHAR(32) - DEFINE also CHAR(32) without quotes. It'll throw an error - as with quotes it's CHAR(34) - but I want only the record - not quotes. Please help in this case!!!
For the posted scenario recommended way is to use AXSMOD, by using it you can remove the double quotes("). For detail over AXSMOD you can always refer to Teradata documents.
Another way is to use Mload for such requirements (works for TD 12.0 and above) Here 1. In layout define first field from 2nd position and for last field give extra length. 2. use delimiter as "," (combination of 3 characters, supported by TD 12.0 and above) 3. For last record, you have to use substr (to let off the last ")