SQL*Loader WHEN clause and greater or less than...

From: Matt Brennan <mbrennan_at_gers.antispam.com>
Date: 1998/05/29
Message-ID: <01bd8b3e$1ad2d5a0$049a0580_at_mcb>#1/1


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.com

(Original email address is spam-blocked.)
Received on Fri May 29 1998 - 00:00:00 CEST

Original text of this message