Re: Dynamic flat file name
******************************************************************
The information in this e-mail is intended only for the named
recipient and may be privileged or confidential. If you are
not the intended recipient please notify us immediately and
do not copy, distribute or take any action based on this e-mail
[email protected]
******************************************************************
Hi Carlos,
The way I get round this is to output to the specified filename from my Table Converter (same for UBE I think) but have this table converter wrapped in a UBE which takes this file and renames it when the TC is finished. This is allowing me to call the TC multiple times in one run and output different named files each time. Business Function B0500180 'Operating System File Operation...' is handy for doing the file rename. (Thats in Xe, don't know if it is in earlier releases, if not I have C code to do the same thing if you need it)
Hope that helps
Barry
Hi list,
Client would like to be able to have a dynamic flat file name created each
time he performs the database output and runs a report. For example, when
doing a normal database output, you must specify what will be the name of
the flat file and where it will be created. Run a report and the flat file
is created. If you were to run the report again, the client would like to
have a new flat file name created automatically(i.e. flatfile1.xls,
flatfile2.xls, flatfile3.xls).
Suggestions?...
Thanks...
Working at Miller Group, Edinburgh, Scotland
OneWorld Xe sp13 - Oracle - on Solaris and NT