Re: Updating Database Table From Text File

From: Gary E. Grant <ggrant_at_crl.com>
Date: Wed, 15 Sep 1999 18:09:30 -0700
Message-ID: <37E0434A.FBE135DB@crl.com>

Sqlloader can do what you want.

Courtney Wright wrote:

> I'm using Designer Forms 4.5.
> I'm accessing a text file using the Text_IO Built-ins. The text file
> contains information that needs to be plugged into an Oracle database table.
> To update the Oracle table, I'm using SQL; Update...Set...Where etc. Is
> this the most efficient way to go about this? Without the Update SQL line
> included, the procedure takes a few seconds to run (8-12). Adding the line
> of SQL adds minutes on to the time it take for the procedure to run. (The
> SQL line is in a loop and is run 20 or so times) Here's my code:
>
> Note: Loop does not run 1000 times. It goes through 20-30 times.
>
>
>
> Is the another, more efficient way of updating records from a text file? Or
> can this code be modified to only called the 'Update' SQL line once?
> Courtney

--

Always glad to be of service,

Gary :-)

---

"There is nothing more difficult to take in hand, more perilous to   conduct or more uncertain in its success, than to take the lead   in the introduction of a new order of things."

• Niccollo Machiavelli, The Prince, 1513

Received on Wed Sep 15 1999 - 20:09:30 CDT