Data extract file

Hi All,

The Data extract file should be in below format :

AA-BB-YYYYMMDD.TXT

YYYYMMDD - Is the date that the file was produced.

the same report is run more than one time a day, then fila name should should be amended as foolows:

AA-BB-YYYYMMDD-N.TXT

N - Is a sequential number for each file produced on a particular day

Please let me know if this can be achieved. if yes, how -- by using data base output or some business function.

Any help is highly appreciated

Regards
Bally

Hi Bally,

How do you produce the "Data Extract" files?
Using TC UBE, or UBE and with Open, Write, Close flat file operations, or other way?

Read you later,

Zoltán

Hi Zoltán

I am extracting the data file by using UBE.

Regards
Ganesh

Hi,
Could you be a bit more specific?
What is your exact problem?
Do you want to search for files with some special naming conventions from UBE?
I have created a lot of interfaces based on flat files with many naming conventions and other special solutions... Maybe I can be of some help.
Regards:
Gergely Pongrácz
e-Best, Hungary

Hi Bally,

by your reply to zoltan, I am assuming you are using Data Base Output to extract data to flat file. In such case the file name is specified at design time hence can not be changed at run time. But you can use flat file business function to copy your output file with a different name as formatted by the report and then delete the original flat file. Use 'B4700230 - Delete or copy flat file' in End Section event

Regards

Vjay