Re: SQL Loader and Delimited Text files

From: Ed Bradt <ebradt_at_lilly.com>
Date: 1997/06/18
Message-ID: <33A7E18A.1208@lilly.com>#1/1

Gary Smith wrote:
>
> Can someone tell me if it is possible to import tab delimited text files
> with SQL Loader in 7.3? I have a line like
>
> FIELDS TERMINATED '\t'
>
> in my control file but SQL loader doesn't like that. How can I specify Tab
> delimited fields.
>
> Thanks
> Gary.

try TERMINATED BY X'n' where X (must be uppercase) tells loader to interpret the following '' enclosed value as a hex character represention and n is the hex value for the delimiting character (tab is 9 if I remember right).
Ed Received on Wed Jun 18 1997 - 00:00:00 CDT