At 11:08 AM 1/6/2010, Bob Thompson wrote:
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.
Bob T., Mike B., Paul B., Paul D., Duey, et al.
I have been monitoring this thread with interest and couldn't resist
to step in.
Did you know that you can use the OPTION "MERGE_DATA ON" to fully
automate the entire routine to APPEND to an existing file?
Here's how:
01. Start R:BASE 7.6 (Build:7.6.8.30111), Turbo V-8 (Build:8.0.22.30111),
or R:BASE eXtreme 9.0 (32) or (64) (Build: 9.0.1.10111).
02. CONNect to your database, define the string, and then use the updated
command with correct syntax, as follows:
GATEWAY EXPORT CSV test.txt +
SELECT Controlno856, Txt1,Txt2) FROM tmp997 +
OPTION MESSAGES ON +
|SHOW_PROGRESS ON +
|QUALIFIER &vQualifier+
|MERGE_DATA ON
RETURN
-- Notice the last parameter "MERGE_DATA ON".
That's all there is to it!
Remember, this is the R:BASE you have always wanted.
Very Best R:egards,
Razzak.
