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
