Thanks, Razzak, but all those are a-okay. That is, there are no QUOTES in the ASCII-CSV file ... umm, if this is so, then should I have set the QUOTES CHAR to a NULL before the LOAD? I'd love to know.
However, when I executed this using GATEWAY, as I recalled you, Et Al., having advised once in the distant past, everything worked fine. Thanks, Steve in Memphis ----- Original Message ----- From: "A. Razzak Memon" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, September 25, 2003 10:39 AM Subject: [RBASE-L] - Re: Problems with LOAD ... AS CSV? - Razzak's Reply > > 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. >
