sql*loader v1 vs. v2

From: <go_brien_at_my-dejanews.com>
Date: Mon, 15 Mar 1999 16:37:56 GMT
Message-ID: <7cjd12$1sf$1@nnrp1.dejanews.com>

SQL*Loader question
I have a ctl file that read a .dbf (dbase file) with no problem under oracle6/sqlloader v1. It does not work in Oracle7. How do I modify it so that Oracle7/sqlloader v2 will correctly load the data into Oracle7? Here is the v1 version of the control file: LOAD DATA
INFILE "ACS.DBF" FIXED 573
APPEND
INTO TABLE ACS
(STANDARD POSITION(2:17) CHAR,

    IN_DATE       POSITION(18:25) CHAR,
    TIME       POSITION(26:33) CHAR)

Please note that in this dbf file there is some header information which SQL*loader seemed to "know" was header info and did not load it into the table. Sqlloader v2 incorrectly tries to load this info into the table!

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Mon Mar 15 1999 - 10:37:56 CST