I had similar kind of issue and one of the below functions. Please refer
ereplace(ereplace(echoProcDate.$CommandOutput,@FM,"")
CONVERT(Char(13),"",lnk.field)
Search found 4 matches
- Thu Sep 06, 2018 2:59 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Missing record delimiter "\n", saw EOF instead
- Replies: 9
- Views: 5159
- Thu Sep 06, 2018 2:53 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Find previous business day
- Replies: 7
- Views: 4176
Re: Find previous business day
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
SELECT CASE WHEN DAYNAME(CASE('#PprmCycledate#' AS DATE)) = 'Saturday'
THEN CAST('#PprmCycledate#' AS DATE) - 1 DAY
END A CycleDate FROM SYSIBM.SYSDUMMY1
- Thu Sep 06, 2018 2:44 pm
- Forum: General
- Topic: Datastage Audit Job
- Replies: 6
- Views: 3628
Datastage Audit Job
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
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
- Thu Sep 06, 2018 10:36 am
- Forum: General
- Topic: Datastage Audit Job
- Replies: 6
- Views: 3628
Datastage Audit Job
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?
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?