I have got a tab delimited file from a customer, and I have to import this
file into a db2 table. Is there a way to do this without changing the tab
character to something different? And if so, how do I specify coldel in the
import statement?

Regards
Odd B Andersen
ErgoGroup AS
Oslo, Norway

Odd Bjørn Andersen wrote:[color=blue]
> I have got a tab delimited file from a customer, and I have to import this
> file into a db2 table. Is there a way to do this without changing the tab
> character to something different? And if so, how do I specify coldel in the
> import statement?
>
> Regards
> Odd B Andersen
> ErgoGroup AS
> Oslo, Norway[/color]

IMPORT FROM FILE.DEL MODIFIED BY COLDELX09 (thats x zero nine)
INSERT INTO....

Try using a third party tool like WinSQL
(http://synametrics.com/winsql). It can move data from text files to DB2
as well as the other way around.


Odd Bjørn Andersen wrote:[color=blue]
> I have got a tab delimited file from a customer, and I have to import this
> file into a db2 table. Is there a way to do this without changing the tab
> character to something different? And if so, how do I specify coldel in the
> import statement?
>
> Regards
> Odd B Andersen
> ErgoGroup AS
> Oslo, Norway
>
>[/color]