Bob, to the best of my knowledge a table name is allowed in gateway syntax.
GATEWAY IMPORT CSV D:\TEMP\FNAME.TXT CREATE AAA GATEWAY IMPORT CSV D:\TEMP\FNAME.TXT APPEND AAA GATEWAY IMPORT CSV D:\TEMP\FNAME.TXT REPLACE AAA If you check the syntax diagram it says "tblview" which means table name or view name. The only problem I see is your are loading a one column table using a CSV syntax. I find it strange that you would have a "ONE COLUMN" CSV input file. CSV usually implies multiple columns. Also make sure your values in the imput file are enclosed in " characters. You might want to post about a dozen lines from your input file to see if we can spot what you problem is. Jim Bentley American Celiac Society [EMAIL PROTECTED] tel: 1-504-737-3293 --- On Tue, 7/8/08, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > From: [EMAIL PROTECTED] <[EMAIL PROTECTED]> > Subject: [RBASE-L] - Load versus Gateway issue > To: "RBASE-L Mailing List" <[email protected]> > Date: Tuesday, July 8, 2008, 6:16 PM > I am having an issue with Gateway and perhaps someone can > see the problem: > > R>LOAD edisplit FROM podata.001 using edidata > R>sel count(edidata) from edisplit > count (edi > ---------- > 3515 (Correct value) > R>del rows from edisplit > R>gateway import csv podata.001 append tempsplit > R>sel count(edidata) from edisplit > count (edi > ---------- > 1649 (Should be 3515) > > tempsplit is a temp view of edisplit having the one column > edidata. > I do not see where the Gateway import option allows you to > specify > a column to load so I had to use the temp view. EdiSplit > has 5 columns > but I only want to load one. > > ????? > > Thanks, > -Bob > > > -- > Thompson Technology Consultants > LaPorte, IN 46350 > 219-363-7441
