Skip to main content

I’m trying to make a migration job where the filename should be in the format of: ‘A12 2021 Voucher.csv’

So the format is like this: AhMM] AYYYY] Voucher.csv

I did try to change the dateformat to ‘MM YYYY’ and use &DATF, but then the dateformat is changed for the lines inside the file as well. This is not something I would like to do.

 

Anyone any suggestions on how to make the filename as described without changing the dateformat inside the file lines?

Hey ,

I have a same requirement to read Dynamic File Names through a Migration Job and appreciate if you could share  details if you manage to get this working.

Thanks

Bhagya

 

 


Hi,
Please try this.
 



/Malan Jayanka


Old question but for information it is possible to dynamically name the created file in these ways:

 

&DATF Date in same dateformat as migration header
&DATE Date in format YYYYMMDD
&USER The User name of the current user
&GUID Guid
&TIME Time in format hh24iss
&SEQN Sequence Number

 


Hi,
Please try this.
 



/Malan Jayanka

Tried in IFS Cloud and it is not working.


Hi,
Please try this.
 



/Malan Jayanka

Tried in IFS Cloud and it is not working.




What is the cloud version that you tried?
Please refer the below tech doc link

Write Data to File - Technical Documentation For IFS Cloud

 

 


 

To read the data from the csv using dynamic file name, which is not working, says the error message

 

 


My Cloud version is 23R2


Reply