sqlload: columns that are keywords

Hi,

  I'm trying to load into a table that has a column 'count'. Sql load responds with "Expecting column name, found keyword count". Is there any way to get sqlload to interpret 'count' as a column name and not as a keyword?

Thanks,

Sebastian.

p.s.

Here is the whole ctl file: LOAD DATA INFILE rmp.txt REPLACE INTO TABLE rmp FIELDS TERMINATED BY ' ' TRAILING NULLCOLS (chronology, collection, context, count, decoration, diameter, end_date, end_per iod, form, id, location, loc_id, method, more_info, notes, rmp.part, published, pub_ref, qsem, quanitifed, release, rmp_id, rmp_notes, start_date, start_period, sub_ware, variant, ware, weight)

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Wed Sep 02 1998 - 16:31:28 CDT