We are currently deploying a new user interface and navigational structure on our Community. These design changes align with our new Teradata Access portal and provide a more cohesive experience for our users.
'.IMPORT VARTEXT' interprets input file content as variable length characters. Please note that only acceptable datatype for VARTEXT are VARCHAR, VARBYTE, and LONG VARCHAR. If you use other data type to read VARTEXT(delimited) import file, import results are not guaranteed.
If you are able to export data, use data or indicdata mode. So that you can import to a table using same table datatypes.
Vj, Thanks for the reply ... can u clarify it a bit more... This is my BTEQ export script .logon server/uid,pwd database d1; .EXPORT indicdata file =c:\anantha\teradata\training\bteq_export_sample.txt .set separator '|' .set titledashes off select * from offshore_test; .export reset .quit -------
Output file is now like this ...䄀楮畲桤††††††ਠ䄀慮瑮慨††††††ਠ䄀慮瑮慨††††††ਠ䄀楮畲桤††††††ਠ
i used the same above Import script only with INDICDATA in the import line.. but it dint load and throwed error. Can u correct the script?