I have a table with 50 columns. The Source File is Fixed Width File and I have to load that source using Teradata SQL Import.
Where should I select "Fixed Width" while importing and How should I write the query?
I have written query like this
INSERT INTO <TABLE NAME> (COL1,COL2....COLn) VALUES(?,?,?...?);
But it is saying "Wrong number of data values in input"
I have to use SQL Import only to do this task.
Thanks in advance!!!
You cannot import or export Fixed Width File using Teradata SQL because SQL assistant accepts delimited file only.
you can use bteq import if file is small else TD load utility depending upon table volume and usage.