Using DataMigrator - Version 7 Release 7.06.
Source is database table and destination is a flat file. For example, if the job name is 'ABC' and job run date is today (17/09/2015) then the naming convention for the destination file should be 'ABC-20150917.txt'. So how do I append the current date so that it dynamically added in destination file name.

This message has been edited. Last edited by: <Kathryn Henning>,

Can anyone help me on this topic?

Edit the .mas file in the DMC and add a global parameter to it. Then change the DATASET reference to the variable:

 DATASET='&&OUTFILE', $ 

Use a variable object in the process flow to set the value before the data flow object:

 &&OUTFILE = 'baseapp/ABC-' || &YYMD || '.txt' 

You can change 'baseapp' to any application name.

Here is a the real example of a .mas:

FILENAME=SAMPLE_HALFWIDTH_CSV, SUFFIX=DFIX    ,
 DATASET=&&OUTFILE, $
 VARIABLE NAME=&&OUTFILE,  DEFAULT='files/sample_20150901.csv', $
  SEGMENT=SAMPLE_HALFWIDTH_CSV, SEGTYPE=S0, $
    FIELDNAME=FIELD_1, USAGE=I3, ACTUAL=A1, $
    FIELDNAME=FIELD_2, USAGE=I10, ACTUAL=A8, $  

The set statement:

&&OUTFILE='files/sample_' || &YYMD || '.csv'