What I was getting at, unless there are myriad columns involved, you can do
your formatting within the SELECT.
SELECT (Select (#1 +','+ #2 +','+ #3) from YourSourceTable
gives a CSV output.
----- Original Message -----
From: <[email protected]>
To: "RBASE-L Mailing List" <[email protected]>
Sent: Wednesday, January 06, 2010 2:51 PM
Subject: [RBASE-L] - RE: Gateway / Append command
John & Mike,
Yes, the OUTPUT ....APPEND does work as expected and that is not the issue.
If I use the OUTPUT command, I then need to use the UNLOAD command, but
it is limited in formatting options. I am creating EDI files that have a
multitude
of format requirements all in the same file. Some lines are fixed field
length while
others are delimited. The delimiters and EOL characters can change in the
file as
well. So I need to create one file, using multiple formats, etc. UNLOAD does
not handle them as well and GATEWAY EXPORT using an RGW file has many more
options. However it does not APPEND evidently, even though you can via the
Explorer option. Since this is an automatic program, I cannot use the
Explorer
option.
Anyway, I have worked around it via programming and am on to my next
project.
GATEWAY would have been a little simpler and cleaner, but in any case I have
completed the program.
Thanks all.
----- Original Message -----
From: "John Engwer " < jengwer @comcast.net>
To: "RBASE-L Mailing List" < rbase -l@ rbase .com>
Sent: Wednesday, January 6, 2010 1:00:14 PM GMT -06:00 US/Canada Central
Subject: [RBASE-L] - RE: Gateway / Append command
Bob,
I am jumping in late on this and I have not read all of the detail in the
responses.
Could you use the output FileName . TXT to create the file and then use the
output FileName . TXT Append to add to the file?
I use that method in some of my applications.
John
-----Original Message-----
From: rbase -l@ rbase .com [ mailto : rbase -l@ rbase .com] On Behalf Of
MikeB
Sent: Wednesday, January 06, 2010 1:12 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - RE: Gateway / Append command
Shouldn't you be able to replicate this with a SELECT?
----- Original Message -----
From: < ttc [email protected]>
To: "RBASE-L Mailing List" < rbase -l@ rbase .com>
Sent: Wednesday, January 06, 2010 11:08 AM
Subject: [RBASE-L] - RE: Gateway / Append command
I am not using Excel at all.
In Rbase I am creating a CSV text file with very strict formatting
parameters.
It is not used by Excel nor is Excel involved in creating it. I state that
it
is a CSV file where in reality it is simply a TEXT file. However GateWay
Export does not list . TXT but only a . CSV , which is fine.
I can create this CSV text file with a Gateway Export command line.
So far no problem.
I then need to add to this same file, at a later point in processing. So I
need
the Gateway Export command to do an APPEND to the end of the
previously created file. This is where the problem is, in that while the
DB Explorer version of Gateway Export has an APPEND option, I have
been unable to find a command line syntax for it. Evidently it does not
exist.
I will have to find another method of creating this text file other than
using
the Gateway command. This program will run 24/7 and must run without
user intervention or other outside influence.
There is always more than one way to accomplish a given result, I will just
need to move on in a different direction.
Thanks,
-Bob
----- Original Message -----
From: "Paul InterlockInfo " < paul @ interlockinfo .com>
To: "RBASE-L Mailing List" < rbase -l@ rbase .com>
Sent: Wednesday, January 6, 2010 9:21:29 AM GMT -06:00 US/Canada Central
Subject: [RBASE-L] - RE: Gateway / Append command
Is it Excel 2000 or 2007? What flavor is it?
Can you run any macros from Excel? On/at the workstation that does this
process.
Sincerely,
Paul D.
From: rbase -l@ rbase .com [ mailto : rbase -l@ rbase .com] On Behalf Of
ttc [email protected]
Sent: Wednesday, January 06, 2010 8:21 AM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Gateway / Append command
Thanks for the suggestions, but in this case, I need to be able to
simply add data to the end of a CSV file. This is being used in
conjunction with EDI and has strict parameters such as end of line
characters, character spacing, etc. etc. The Gateway Export command
allows for some formatting options via an RGW file that are desired/needed.
I tried using the OUTPUT ... AAPPEND and then UNLOAD Data.
While that does append to the end of the file, I do not have the formatting
options that are available in Gateway.
I am able to produce the exact output needed via Gateway Export, but I
cannot find the option to append an existing file. It is possible as there
is an APPEND option when using the DB Explorer bar, but I need to
use the command line.
An interesting note... when using the Gateway Explorer bar, and you
select CSV file type, check the APPEND option and then export, the
file is indeed appended. However if you select the USE EXPORT
WIZARD, check the APPEND option and then proceed using the
wizard and export the file, it does not append.
Any input on the GateWay Export line command and how to get it
to APPEND to an existing column would be greatly appreciated.
Thanks,
-Bob
