Hi, I have a contrived SQLLDR control file below to import data into
an Oracle database based on the first few characters for each line in
the file 'test.dat'. Of course there is no operator LIKE as part of
the WHEN clause (but it works conditionally when I use = or <> in
place of LIKE, of course not giving me the desired input). Anything
obvious I am missing or am I looking at other alternatives (like using
a file containing a subset of test.dat with the entries I need to
import etc). No obvious alternatives stick out to me in a90192.pdf.
Currently using Oracle 8/9 on a Winboxes.
Thank you
Barry
LOAD DATA
INFILE 'c:\test\test.dat'
INTO TABLE tblTest
REPLACE
WHEN relevantInfo LIKE '876%'
FIELDS TERMINATED BY ',' optionally enclosed by '"'
( relevantInfo CHAR
otherInfo CHAR
)
Received on Thu Jun 05 2003 - 04:48:59 CDT
