Re: SQL-Loader-Problem

christian.guenther_at_mch.sbs.de wrote:
>
> Hello,
> is there a possibility to say Sql-Loader to change a value, that is in
> the INFILE a NULL-Value to another value, for example to a space??
> I read the manual, but didn't find anything.
You can change the value with a function like NVL(), for example:   job integer "nvl(:job,0)"
For more information refer to ULCASE7.CTL in your RDBMSxx/loader subdirectory.
> ANother prolem I have is, I trie to skip columns in a datafile.
> My datafile looks like that:
> field1;;field2;;field3;;field4....
> The Field delimiter I use is ';'. I always have two semicolons,
> because I save an excel-spreadsheet as csv(comma seperated
> values)-file and in this excel spreadsheet, I have between two columns
> with data always an empty column.

 Why don't delete this column(s) temporary?
> Is there anybody, who have an idea??

HTH
  Harry

-- 
                                                      ///
  Hiroshima '45   Chernobyl '86   Windows '95        (O O)
-------------------------------------------------oOO--(_)--OOo---------
  "There is more than one way to do it!"

(Remove -NOSPAM- from my email address)