Hi All
I have one file (File 1) which unloads data from a table whenever a request comes.
The file contains a 10 digit id. Say 0000000090
I have another file (File 2) which contains the below query.
The query is " WHERE I_CAMPAIGN = 0000000080 "
I want to sort these two files and create another output file such that the resulting file contains
WHERE I_CAMPAIGN = 0000000090
The requirement is to just replace the campaign_id in second file with the new campaign_id of first file whenever a new request comes.
Can anyone please help me to solve this.
OPTION COPY
INREC BUILD=(C'" WHERE I_CAMPAIGN = ',1,10,C' "')