Steve,
A few things to consider when IMPORTing/EXPORTing data as CSV.
01. Database CHARacter SETting for QUOTES
02. CSV file settings for QUOTES
Check to make sure that QUOTE SETings are correct.
Hope that Helps!
Of course the Next Generation R:BASE 7.0 for Windows includes the OPTION to SET your own QUOTE SETtings for GATEWAY EXPORT and GATEWAY IMPORT commands.
Very Best R:egards,
Razzak.
Unbounded Possibilities with Industrial-Strength, True-Relational and Multi-User Database Management System.
At 10:25 AM 9/25/2003 -0500, J. Stephen Wills wrote:
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.
