Database Software

Hi there,

I have an issue whereby I am loading in a csv file, and I have the 'fields terminated by '|' ' clause at the top of the file.
As part of the ctl file I am assigning a number of variables which I obviously do not want to load in as part of the csv.

However, the systems seems to insist that there is a delimiter present for each of these variables.

Is there a workaround for this?

If I paste TERMINATED BY '|' after each single field (apart from the variables) it works ok but I don't want to have to do this for all load files.
Any ideas?
Cheers!