SQLLOAD Problem

Hi !

This data file comes from a download from a sqlbase database and has to be loaded into a table in an Oracle DB 7.1.6 . The problem is with a long datatype, the record in the data file ends with a double slash (ie. '//') and the long variable is the last field to be downloaded , all the other fields in the record are seperated with a comma (',')

Well can anyone suggest a way around to specify a termination of the record as the record can contain slashes ('/') as a part of the data and only double slashes ('//') mark the end of the record !

I tried specifying the field level terminated by clause but it rejects the inclusion of double slashes ('//') and expects a single character .

Thanks !

Mashya .
Pls cc to : mashy_at_null.net

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Fri Sep 25 1998 - 05:30:54 CDT