Razzak, You guys are so far foward thinking that you are operating 5 days in the future.
Jan -----Original Message----- From: "A. Razzak Memon" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Wed, 06 Jan 2010 15:14:58 -0500 Subject: [RBASE-L] - RE: Gateway / Append command 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.
