0 - 2 of 2 tags for Fixed Width File loading
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

 

By rk_theprince, 17 Jul 2013 | Tagged: Fixed Width File loading loading using sql import
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(?,?,?...?);

By rk_theprince, 17 Jul 2013 | Tagged: SQL Import Table Loading Fixed Width File loading | 4 comments