Re: DataManager Load

Yes it is.
You can use sql loader from command line. first you need to creat a control file.
aard.ctl is your control file which contains:

    load data
    infile 'aard' The actual datafile name is aard.dat oracle will put the .dat at the end of it. If datafile is not in the same directory then enter the path as well

    insert it could be insert or append     into table aard
    fields terminated by '|'
    (

    ar_key,
    ar_bacat,
    ar_lib,
    ar_oms
    ar_date  date "DD/MM/YYYY" NULLIF ar_date=BLANKS,   if you have a column

    )

then
enter command line
sqlload userid=user/password_at_connect string control=aard.ctl direct=true bad=badfile.bad loag=logfile.log
direct =true is fast but you need to build the index(s) direct =FAlse is sllow updates the index(s) as inserts. Tom

Karen Schmidt <Kschmidt_at_audg.gov.ab.ca> wrote in message news:8cbsln$af0$1_at_is-news.gov.ab.ca...
> I am running Oracle 7.3. Using DataManager's loader to load a csv file
> into the database. Is it possible to run the loader from sql or the
command
> line (or batch file) ?
>
> Thanks....
>
>
Received on Tue Apr 04 2000 - 07:05:14 CEST