-
I have an unload file from an informix database that I am trying to use as my infile for sqlloader. When I run sqlloader I am receiving an error in regards to my date field. The format of my date in the unload file is 08/20/2002 and this file is | delimited. Please Help!!!!! I need to know what to put in my control file to deal with this non-oracle formated date.
-
try using:
load data
infile my_file.txt
into table tab_name
append
fields terminated by ',' optionally enclosed by '"'
(
date_column date 'mm-dd-yyyy'
)
cheers,
R.
-
Hi,
I ment fields terminated by '|'
cheers,
R.
-
