SQL Loader Window Won't Close

From: Kimberly Lord <lordkimberly_at_worldnet.att.net>
Date: Mon, 27 Jan 2003 22:04:42 GMT
Message-ID: <_1iZ9.6165$rq4.557742_at_bgtnsc05-news.ops.worldnet.att.net>



Hi,

[Quoted]     I am calling the sqlldr80.exe from a vb exe using the shell command. Everything is working ok except the dos sql loader window stays open. I don't know what is causing this. If I call the loader from start, run the [Quoted] same thing happens. What kind of command closes the sql loader.Here is the [Quoted] control file I am using:

load data
infile
'D:\CODARVectorData\Predictions\2003\January\21\04\Tot_FRNT_03-01-21_0400_25 F.dat'
Append into table PREVECTORDATARECS
fields terminated by ','
(
FK_VECTORID,
LONGITUDE,
LATITUDE,
U,
V,
UPRIME,
VPRIME,
SITESUSED
)

[Quoted] The vb exe runs hourly on a windows2000 server. So it is not possible to manually close the windows.
Pleas offer any suggestions.
Thanks,
Kim Received on Mon Jan 27 2003 - 23:04:42 CET

Original text of this message