|
I'm trying to execute the following statement
LOAD HOLD_CLIENT FROM
D:\BBER\PROJ_WIA\CLIENT\DATA_EXTRACTS\CLIENT_2003_APR_B.csv AS CSV
W/this particular file, there are 288 records. The
target TABLE f/the LOAD is structured exactly as is the data, w/19 Fields (this
is just f/info) of NOTE Data-Type - this table was copied fm the one originally
created via UTILITIES|IMPORT/EXPORT|... New Table=Checked|TRUE, so that's why
the NOTE fields. Again, this is f/info, although I wonder if this has
anything to do w/executing this fm the command line.
Anyway, the command runs fine, LOADing the 98 records, but it
doesn't STOP execution, continuing to LOAD data, but fm where/what I cannot say,
until I press [ESC]. Then, it has literally K's of "garbage" records,
mostly w/NULL values, although it seems to keep populating at least one field
w/"8" the last character of the ID value of the last record in the CSV, which is
the last field in the record, so it seems to be re-loading the very last byte of
the CSV file w/o halting.
So, any thoughts? I'd really like to proceduralize this
task, but I'm not sure what to do now.
TIA,
Steve in Memphis
|
