SQLLOAD a formated report into a varchar

From: <mark_greenhalgh_at_usa.net>
Date: 1997/09/26
Message-ID: <875305027.25175@dejanews.com>#1/1

  I'm trying to load a formated report into a varchar(2000) field and I'm   losing all of my linefeeds. Is there a way to do this ? I need to keep   the format of the report.

  Mark Greenhalgh
  IDX Systems Corporation
  mark_greenhalgh_at_usa.net

  control file:
  OPTIONS (direct=true)
  RECOVERABLE
  LOAD DATA
  INFILE '/orahome/oracle/magload/security1.txt'   BADFILE '/orahome/oracle/magload/bad_security.dat'   DISCARDFILE '/orahome/oracle/magload/bad_security.dis'   TRUNCATE
  CONTINUEIF NEXT (1:2) != '%%'
  preserve BLANKS
  INTO TABLE swb.a_security
  FIELDS TERMINATED BY'~'
  trailing nullcols
  (

          acompanyid integer external,
          anote char(2000),
          ASECURITYID     sequence(1,1),
          ADATECREATED    sysdate,
          ACREATEDBY      constant saint,
          ADATELASTEDITED sysdate

  )

  datafile:

  %%acompanyid~man(1) man(1)

  NAME     man - Displays reference pages

  SYNOPSIS   man [-] [-M | -P search_path] [-t] [-l] {[section[suffix]] title...}...

    man [-M | -P search_path] -f title ...

    man [-M | -P search_path] -k keyword ...

  STANDARDS     Interfaces documented on this reference page conform to industry   standards as follows: %%acompanyid~man(1) man(1)

  NAME     man - Displays reference pages

  SYNOPSIS   man [-] [-M | -P search_path] [-t] [-l] {[section[suffix]] title...}...

    man [-M | -P search_path] -f title ...

    man [-M | -P search_path] -k keyword ...

  STANDARDS     Interfaces documented on this reference page conform to industry   standards as follows:

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet

Received on Fri Sep 26 1997 - 00:00:00 CDT