SQL Loader questions...

From: Duncan Hodson <dch_at_tronze.demon.co.uk>
Date: 1998/03/10
Message-ID: <889561428.521.0.nnrp-04.c2debfb5@news.demon.co.uk>#1/1

Hello all...

Question 1 : Is it possible to invoke SQL Loader from SQL Worksheet?
Question 2 : Is it possible to invoke SQL Loader from a PL/SQL script?
Question 3 : Is it possible to invoke SQL Loader using a C routine calling

some DLL or inbuilt library?

Our situation is that we have a large amount of data to be imported into an Oracle table, and the most efficient way is to use SQL Loader. Our 4GL development
environment (Uniface) has support for loading flat text files but it's performance
leaves quite alot to be desired - Uniface took 1.5 hours where SQL loader took 20 mins!

There is a command in Uniface which allows the execution of SQL commands to the current database connection, and we need to use this connection to load data in from our text file.

The ideal solution would be to invoke the loader script using the SQL command, although we do have experience of writing DLL's for use with uniface and would welcome any
suggestions of how the loader can be invoked using C.

Thanks for your help

Duncan Hodson
Welcom Software

--

======


=== Check out Fred's Litter Tray

=== www.tronze.demon.co.uk

======

Received on Tue Mar 10 1998 - 00:00:00 CST