CTL & WHEN CLAUSE Oracle

[einyel]

Hi all,

I load a flat file into a table via CTL (loader).
This flat file contains records for years 2001, 2002, 2003, 2004, 2005 and I only have to load records till current year.

Example
LOAD DATA
INFILE 'D:\TRANSFER\BBMF04.TXT'
INTO TABLE SIFI.COMMITMENT_INPUT &quot;&quot;&quot;&quot;&quot;WHEN (31:34) <= CURRENT YEAR &quot;&quot;&quot;&quot;&quot;
FIELDS TERMINATED BY ';' OPTIONALLY ENCLOSED BY '&quot;'
( IAN POSITION(16:30) CHAR &quot;TO_NUMBERIAN)&quot;,
AÑO POSITION(31:34) CHAR &quot;TO_NUMBERAÑO)&quot;,...and some other fields....


My question is:
Is there any way I can put a when clause to filter only the desired records till current year ? or do I have to build a work table?

Thanx in advance

Angel

 

[lewisp]

I'm no sqlldr expert, so I cant help you with any control file syntax. However, my suggestion is to load your data in full into a temporary table then use a database procedure to load only the data you require into your main table.

 

[einyel]

That was my thought... : (

Thanx

Einyel
Functional&Technical Cognos Consultant