Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> SQL*Loader WHEN clause and greater or less than...
We're running SQL*Loader version 7.1.6.2.0 and I'm having a problem loading data with a greater than or less than in the when clause.
I'm trying to load data into a table and my data file is like this:
3
15
8
9
10
(They are two characters, like '10' and '15', or a space and a character,
like ' 3' and ' 8' and ' 9'.)
My control file is like this:
load data
infile 'mcb.dat'
append
into table mcb
(store_cd position(1:2) integer external)
If I try a when clause like:
when store_cd < 10
I get an error that says "Illegal combination of non-alphanumeric characters" and the carat points to the space after the < .
If I do this:
when store_cd > 10
I get the same error, but curiously the carat points exactly to the > and not the space after.
I've removed the spaces after the operators, used single or double quotes around the 10, changed the datatype to character, tried to play with to_number and to_char functions, etc., and nothing works. But, an '=' or '!=' or '<>' work OK, but that's not what I'm after.
In the Oracle Server Utilities guide for 6.0, it has an example of using '<', but the same example in the 7.3 guide has been altered by Oracle and just uses '=' and '!='. Did Oracle remove functionality from SQL*Loader and it won't support less than and greater than in a when clause in version 7.X? Is there any way to alter the syntax to get the same result as less than (<) or greater than (>)?
Thanks in advance!
-- Matt Brennan SQL*Tools Specialist GERS Retail Systems 9725-C Scranton Road San Diego, California 92121 1-800-854-2263 mbrennan_at_gers.comReceived on Fri May 29 1998 - 00:00:00 CDT
(Original email address is spam-blocked.)