SQL LOADER Problem : WHEN CLAUSE NOT WORKING PROPERLY
From: Umesh Limaye <ulimaye_at_poci.amis.com>
Date: 1998/07/11
Message-ID: <35A7A38F.168146B5_at_poci.amis.com>#1/1
INFILE 'M:\DATA\ACTUAL~1\Forecast\forecast.CSV'
Date: 1998/07/11
Message-ID: <35A7A38F.168146B5_at_poci.amis.com>#1/1
Any comments or suggestions, please e-mail them to ulimaye_at_poci.amis.com
Thanks.
Umesh
- SQL LOADER CONTROL FILE ------------------------------------
INFILE 'M:\DATA\ACTUAL~1\Forecast\forecast.CSV'
REPLACE
INTO TABLE FORECAST_INFORMATION
WHEN (IsForecast='Y')
FIELDS TERMINATED BY ","
TRAILING NULLCOLS
(IsForecast CHAR "RTRIM(LTRIM(:IsForecast))", BU CHAR) -- ----------------- END OF CONTROL FILE --------------------
Data File is like this . . .
Few lines like first two shown here start with a leading space.
I am trying to figure out how to get them in.
Y,CA
Y,CA
Y,TGP Y,TGP Y,TGP ________________________________________
Umesh Limaye'
American Microsystems Inc.
2300 Buckskin Road
Pocatello, Idaho 83201
e-mail: ulimaye_at_poci.amis.com Received on Sat Jul 11 1998 - 00:00:00 CEST