CPYTOIMPF in a CL using a variable

[Muskalane]

Hello, I'm trying to rename a file using a variable in the CPYTOIMPF command. I want to append the current date.

CPYTOIMPF FROMFILE(QTEMP/B1183) +
TOSTMF('tmp/B1183_&DATE.csv') +
MBROPT(*REPLACE) STMFCODPAG(*STDASCII) +
RCDDLM(*CRLF) STRDLM(*NONE) FLDDLM(',')


It's not working and my file name ends up B1183_&DATE.csv. I'm not very familiar with this command.

Does anyone know a workaround?

Thank you so much.
Muskalane

 

[mikrom]

First you have to compose the CSV-filename something like this

/* Create CSV file name from date */
CHGVAR     &CSVNAME VALUE('B1183_' *CAT &DATE *CAT '.csv')

and then use it in the command

CPYTOIMPF  FROMFILE(QTEMP/B1183) +                   
           TOSTMF(&CSVNAME) +         
           ...