importing integer values

Hi,

We are using Oracle 7.0.13 on a SunOS 4.1.3. and we are experiencing a small but annoying problem:

When we try to import a fixed format ascii file with integers at known positions we want to stop zero's and values greater than 31 from being read. SQL*LOAD is equiped to do this as says the manual.

Following the instructions of the manual 'Utilities User Guide' the following statements should do the trick:

pg 6.38

....

INTO TABLE dept

   WHEN deptno < 100

     ( etc..


     )

INTO TABLE emp

   WHEN empno > 1000

     ( etc..


     )

Problem is that an equivalent program and databasefile do not what we expect them to. Seems Oracle expects a string value. This would not be a problem if Oracle had the possibility to use larger then > and smaller then < operators in this context. This is not so.

Is there anybody out there who knows how to do this, or who can refer as to a FAQ with this question ?

Aad. Received on Tue Mar 22 1994 - 16:13:50 CET