I have installed the Teradata Express 12.0 in my PC for R&D purpose. I have executed the FastExport utiliy. I wanted to Xport the data to Windows notepad. The Utility is working fine, it is fetching the correct number of records from the Teradata Database but the BYTE data from the Teradata to the notepad is in unreadable format.
I ran the utility with the default Character Set specification - ASCII and also executed the same by setting the Character Set specification to UTF8. But still the data in the notepad is in unreadable format.
I am not getting the BYTE data in Teradata Database in a readable format in the notepad. I hve come across the UDF --> udf_toChar_mk183200 to convert BYTE to VARCHAR but dont know how to use it in the FastExport Job script. Can anyone tell me how to go about it.