DSXchange

I had similar kind of issue and one of the below functions. Please refer
ereplace(ereplace(echoProcDate.$CommandOutput,@FM,"")
CONVERT(Char(13),"",lnk.field)

If you have list of holidays loaded into a file or a table, do a lookup, you can use the below query in case of DB2 and write it to a file:

SELECT CASE WHEN DAYNAME(CASE('#PprmCycledate#' AS DATE)) = 'Saturday'
THEN CAST('#PprmCycledate#' AS DATE) - 1 DAY
END A CycleDate FROM SYSIBM.SYSDUMMY1

Thanks for your response.

In our project, we extract data from 3 different systems, source being DB2 and flat files. After loading the data, we have to enter the source and target count as below into a file.

SYS_NAME, Current_Date, Source Count, Target Count, Difference

Hi All,

I have a requirement of this. We extract data from DB2/ODBC and load data into table/file. We have to add audit details such as source record count,target record count and differences to the audit tables on a daily basis.Can you please suggest me on this?