James,
Thanks for the reply.
It is not that Gateway does not allow a table, it does not allow to specify
what column in the table
you want to load. My table has 5 columns, of which I want to load only one
column.
The file that I am loading is not really a CSV file, but that is the closest
option I see in Gateway.
The file is an EDI text file with typical lines such as:
BSN*001*023456*20080708*20080813**175
N1*OB*0923
LIN*001*VP*705*SK*500123*UP*04355980512
REF*SAN JOSE*CA*99999*ABC
Each line can and does have a different number of fields.
I load the entire line into a single column text field then cursor through
the table.
EDI has a specified format such that BSN line contains certain data, N1 line
contains
different data, etc. etc. However, not all transactions have the same
number of lines,
or even the same segments. I will leave it to say that this is the way it
is done.
So one must load the "line" of data into a single column and parse out what
is needed.
This is all rather easy. However, if I use the Load command to load the
file, I do get all
the records loaded. However, the LOAD command sees the space in "SAN JOSE"
as
a delimiter and drops the rest of the data. I.E. the line REF*SAN
JOSE*CA*99999*ABC
gets loaded into the table only as REF*SAN Everything after the space gets
dropped
for some reason.
If I use GATEWAY, the above line gets loaded perfectly, however only less
than
half of the file gets loaded. I get no errors and all seems to work OK,
just the file
does not all load.
I tried GateWay on a regular view versus temp, a temp table and a permanent
table.
They all acted the same, only 1649 rows added. Using the LOAD command on
either permanent or temp tables adds all records, but anything with a space
malfunctions.
-Bob
----- Original Message -----
From: "James Bentley" <[EMAIL PROTECTED]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Tuesday, July 08, 2008 7:15 PM
Subject: [RBASE-L] - Re: Load versus Gateway issue
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
--
No virus found in this incoming message.
Checked by AVG.
Version: 7.5.526 / Virus Database: 270.4.6/1538 - Release Date: 7/7/2008
7:40 AM
