All Forums Database
rk_theprince 7 posts Joined 05/10
17 Jul 2013
Loading Fixed Width File using Teradata SQL Import

 

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 must sign in to leave a comment.