Problem in importing data from text file to teradata database using bteq
When i export the data from a table to any text file using bteq then data is written correctly in text file. But when i again import the same data from text file (skipping the title line) to same table, data is inserted successfully but some garbage value instead of the actual data. I am using normal select and Insert command for a single data only.
Re: Problem in importing data from text file to teradata database using bteq
The USING phrase must describe the input data, not the table. You used REPORT format for your export, so that data is CHAR not INTEGER. If you are using the default INTEGER format '-(10)9', then your USING needs to say CHAR(11).