DataStage Server Edition 7.5.3 => Iconv not working with
Posted: Tue Feb 02, 2010 1:32 am
Hi,
We are in the process of testing the DataStage Server Upgrade from
7.5.1 A to 7.5.3 & found that Iconv is not working at all using the
format as "D/E".
We have the date in the Input File as "YYYYMMDD" &
this needs to be loaded to DATE datatype of Teradata Target table. In
the DataStage Job, we have used the transformation as Iconv
(lSrcToStgExtract.Line [7,2] : '/' :lSrcToStgExtract.Line [5,2] : '/' :
lSrcToStgExtract.Line [1,4], "D/E"). This transformation is not working
on 7.5.3 rather the same is working alright on 7.5.1 A.
Please let us know the fix for this. Also, do let us know if this is a KNOWN ERROR on 7.5.3.
Thanks in advance !
Sarat.
We are in the process of testing the DataStage Server Upgrade from
7.5.1 A to 7.5.3 & found that Iconv is not working at all using the
format as "D/E".
We have the date in the Input File as "YYYYMMDD" &
this needs to be loaded to DATE datatype of Teradata Target table. In
the DataStage Job, we have used the transformation as Iconv
(lSrcToStgExtract.Line [7,2] : '/' :lSrcToStgExtract.Line [5,2] : '/' :
lSrcToStgExtract.Line [1,4], "D/E"). This transformation is not working
on 7.5.3 rather the same is working alright on 7.5.1 A.
Please let us know the fix for this. Also, do let us know if this is a KNOWN ERROR on 7.5.3.
Thanks in advance !
Sarat.