An observation - somebody please explain :-)

In the earlier thread, the solution to Anurag's problem suggested by Jurij works fine, but only if you use a fixed format input file with a control file like the following:

LOAD DATA
INFILE 'c:\tmp\tt.dat'
APPEND
INTO TABLE tt
WHEN C3 = "REGROLL"
(c1 POSITION(01:05) CHAR,
c2 POSITION(06:12) CHAR,
c3 POSITION(13:20) CHAR,
c4 POSITION(21:27) CHAR,
c5 POSITION(28:36) DECIMAL EXTERNAL,
c6 POSITION(37:45) DECIMAL EXTERNAL)

INTO TABLE tt
WHEN C3 = "REGROLL2"
(c1 POSITION(01:05) CHAR,
c2 POSITION(06:12) CHAR,
c3 POSITION(13:20) CHAR,
c4 POSITION(21:27) CHAR,
c5 POSITION(28:36) DECIMAL EXTERNAL,
c6 POSITION(37:45) DECIMAL EXTERNAL)

The input file used is:
tt.dat
------------
MBOC YR_1991REGROLL BSPSIEB 1.000000 1.000000
ALLEPYR_1991REGROLL COFYE 24.00000024.000000
ALLEPYR_1991REGROLL1COLOP 48.00000048.000000
ALLEPYR_1992REGROLL2COEPAM 8.000000 8.000000
ALLEPYR_1991REGROLL3COEPAM 9.000000 9.000000
---------------------------------


Now, if I try to do the same thing using a free format input file (FIELDS SEPARATED BY WHITESPACE) it does not seem to work! The control file used is:

LOAD DATA
INFILE 'c:\tmp\tt.dat'
APPEND
INTO TABLE tt
WHEN C3 = "REGROLL"
FIELDS TERMINATED BY WHITESPACE
(c1,c2,c3,c4,c5,c6)

INTO TABLE tt
WHEN C3 = 'REGROLL2'
FIELDS TERMINATED BY WHITESPACE
(c1,c2,c3,c4,c5,c6)

The input file used is:
tt.dat
--------------------
MBOC YR_1991 REGROLL BSPSIEB 1.000000 1.000000
ALLEP YR_1991 REGROLL COFYE 24.000000 24.000000
ALLEP YR_1991 REGROLL1 COLOP 48.000000 48.000000
ALLEP YR_1991 REGROLL2 COEPAM 8.000000 8.000000
--------------------------------------

Only the first WHEN clause is satisfied.

Now, I know that I am missing something - question is what?

Can somebody explain please?

-amar