Loading Fixed Width File using Teradata SQL Import

Database
Enthusiast

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!!!

4 REPLIES
Enthusiast

Re: Loading Fixed Width File using Teradata SQL Import

Can someone please explain me. Is there a way to IMPORT FIXED WIDTH FILE using Teradata SQL Import?

Enthusiast

Re: Loading Fixed Width File using Teradata SQL Import

Hi,

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.

Enthusiast

Re: Loading Fixed Width File using Teradata SQL Import

Hi Vikas....
Thanks for the reply...
Are you sure that this can not be achieved using SQL IMPORT? Because my TL told me to do that using SQL Import.
Enthusiast

Re: Loading Fixed Width File using Teradata SQL Import

yes i am sure.