RE: RE: Database Output
I am not too familiar with the AS/400 these days Chris, so I'm not sure how
my comments will translate to your system - we are using NT machines.
Assuming your AS/400 can see the whole network, and potentially create files
using UNC file names such as \\myserver\mycsvfile.csv then you should be ok.
The 'Export to Flat file' bsfn requires the string you would like to export
and the file name(and another parm which you seem to need to pass, but seems
to do nothing). If the file does not exist, the file will be created which
the first call to the bsfn is executed, if it does exist, lines will be
appended. Therefore, you can call the function over and over and build up a
csv file. Each line will need to be formatted manually in your program
using concat statements. Concat your first field to be output, then a
comma, then the second field etc..., then output the line using the bsfn.
So the trick is not to use database output at all, as this will not allow
you to control the file name and location(not in my version anyway).
We then use processing options so we can soft code the file location...
Hope this helps
Tom Brown
OW 733.1
NT Servers
Oracle