Re: oracle and dbase "realtime"-transfer

From: Philip Chee <philip_at_aleytys.pc.my>
Date: Fri, 03 Nov 2000 14:57:36 GMT
Message-ID: <973263456.5452snx@aleytys.pc.my>

In article <8tubii$j5$1_at_news.seicom.net> dGrabenhorst_at_integrata.de writes:

>I need to update oracle-tables using dbase-files as sources every hour.
>The problem is, that the files are really large ones (about 10-30MB).
>ODBC is too slow.
>Until yet, I made it with an Centura application using ODBC and native-sql
>(but it's really slow, because of the ODBC-connection to dbase).

>Is it possible to import dbase-tables directly with sql-loader or

SQLloader has direct support for the dBase (xBase) .DBF file format using the following syntax in the control file:

INFILE "DBFFILE.DBF" "DB3 xx"

where xx is the record length of the xBase file.

Example:

dBase III file name is RRUNOUT.DBF
  last update was on 1/5/94;
  there are 1 records in the file;
  the header length is 194 bytes;
  the record length is 93 bytes.
dbf field information:

Table name: RRUNOUT
field name type length decimal

  1      RO_ECODE   C     1       0
  2      RO_EMSG    C     80      0
  3      RO_REPORTS N     2       0
  4      RO_PAGES   N     4       0
  5      RO_RIRECNO N     5       0

LOAD DATA
INFILE "RRUNOUT.DBF" "DB3 93"
APPEND
INTO TABLE RRUNOUT

   (RO_ECODE   POSITION(2:2) CHAR,
    RO_EMSG    POSITION(3:82) CHAR,
    RO_REPORTS POSITION(83:84) INTEGER EXTERNAL,
    RO_PAGES   POSITION(85:88) INTEGER EXTERNAL,
    RO_RIRECNO POSITION(89:93) INTEGER EXTERNAL)

If I remember correctly position(1:1) in each xBase record is reserved for the Tombstone marker.

Philip

---=====================================================================---

Philip Chee: Tasek Corporation Berhad, P.O.Box 254, 30908 Ipoh, MALAYSIA e-mail: philip_at_aleytys.pc.my Voice:+60.5.291.1011 Fax:+60.5.291.9932 Guard us from the she-wolf and the wolf, and guard us from the thief,

                  oh Night, and so be good for us to pass.

-- 
 þ 20355.61 þ Coming Soon. Mouse Support for Turbo Edlin!

Received on Fri Nov 03 2000 - 08:57:36 CST