Re: sqlldr question- imbed functions fail

From: Dmitry <support_at_ispirer.com>
Date: Fri, 2 Mar 2001 16:57:06 +0200
Message-ID: <97occ7$q5sgc$1@ID-75577.news.dfncis.de>

Hi,

Syntax is wrong for SQLLoader. Use:

 load data
 infile 'proc_data.txt'
 badfile 'proc_data.bad'
 discardfile 'proc_data.dsc'
 append into table genotest
 fields terminated by "#" optionally enclosed by '"'  (PPID,

   Plate,
   Read1,
   Read2,

   Dated DATE "DD-MM-YY")

Also set direct path option to false.

--
Dmitry
www.ispirer.com - Database migration tools and services for Oracle and IBM
DB2.



"Zhiliang Hu" <zhu_at_genomicfx.com> wrote in message
news:3A9ED80E.1792CBFA_at_genomicfx.com...


> I tried a "to_date" function in SQL Loader (sqlldr) with the

> control file as follows and it failed.  Any suggestion is

> very much appreciated!

>

> ----------------------

> load data

> infile 'proc_data.txt'

> badfile 'proc_data.bad'

> discardfile 'proc_data.dsc'

> append into table genotest

> fields terminated by "#" optionally enclosed by '"'

> (PPID,

>   Plate,

>   Read1,

>   Read2,

>   Dated "to_date(Dated, 'DD-MM-YY')"

> )

> ----------------------

>

> it complains:

> SQL*Loader-417: SQL string (on column DATE_TYPED) not allowed in direct

> path.

>

> Any suggestion to overcome this?

>

> Thanks in advance!

>

>

Received on Fri Mar 02 2001 - 08:57:06 CST