Hello,
i have created one control file with below script and this control file is mapped with concurrent program XYZ which is running fine..
Here in concurrent program, i have input parameter file ABC_DDMMYYYY.csv.
if i run this program individually which is working fine. if i schedule this program then it doesn't make increment into file name.
e.g. Today 24th July ... File name should be ABC_24072018.csv, independent this is running fine.
suppose i schedule this request for 25 jul, 26 jul, 27 jul, it doesn't change the file name automatically e.g. file name should be changed ABC_25072018.csv for next run.
Program Input Parameter : $INT_TOP/data/ABC24072018.csv
Could you please suggest on this. is there anyway it can incremented when i am scheduling
OPTIONS (SKIP=1)
load data
INFILE *
APPEND into table ABC
FIELDS TERMINATED BY ','
OPTIONALLY ENCLOSED BY '"'
TRAILING NULLCOLS
(
EIN
, SOURCE
, LOAD_DATE
, SOURCE_CREATED_BY
, SOURCE_LOAD_DATE SYSDATE
, SOURCE_LAST_UPT_DATE
, STATUS_FLAG
, ERROR_MESSAGE
)
Regards
D.K