Shell Programming and Scripting

I have situation

I have to load the datefile through a loader program, and that why I have one loader control file.
My datafile is having first line and last line and inbetween all the data which i need to load into oracle through Sql*loader.

I did not requires last line of data to be loaded into oracle , infact for first line I am able to skip through there inbuilt commond "SKIP =1"

I have tried couple of other options but seems Sql*loader does have limitation and cann't helps in skipping the last line.

alternatively, I am thinking to execute a shell script that remove the last line and put the file as it is with out changing the name and rest of data.

can any one tell me what is adject unix common which I need to fire before executing sql*loader.

I am enclosing my structure of data file:

Code:

03Feb02,14Feb02,A
2039380,AT7000,GB1200,NZD,123456789.00-,07Mar02,INVOICE REFERNCE VVVVVVV,10Feb02,,,EUR,57307148.03-,0.4641879,01,2
2039382,AT1234,GB5000,GBP,674.13-,17Mar02,INVOICE REFERNCE,02Feb02,,,EUR,1077.40-,1.5982100,01,2
................
....
039379,SG1111,GB5000,USD,1423456.00-,07Mar02,INVOICE REFERNCE MMMMMMM,11Feb02,,,SGD,2599168.60-,1.8259564,01,2
2039381,VN5100,GB5000,EUR,741852.00-,07Mar02,INVOICE REFERNCE ZXCVBN,08Feb02,,,SGD,1218046.80-,1.6419000,01,2
END

last line always identified by END.

following two lines will do the jo

Code:

sed -n '$!p' filename>temp
mv temp filename