I want to load everything where position 143:150 is like M***103. The stars can be any sign, but only three positions are allowed there, no less, no more. I tried with Like 'M%103', but SQL Loader says: only = and <> allowed.
I have a data file where the date is situated in the header. But i want to get this date into every line that i load from the file.
Anyone got an idea?
The important part of the control file:
INTO TABLE SALES_INCOMING_STAGING
WHEN (1)= '1' AND (143:150) = 'M***103'
TXDATE POSITION(4:9) Date 'YYMMDD',