DataStage Server Edition 7.5.3 => Iconv not working with

[sarat.srinivas@tcs.com]

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.

[ray.wurlod]

Please try the following experiment. In the Administrator client's Command window execute the following query and let us know the result.

Code: Select all

SELECT EVAL "ICONV('2010/02/03','D/E')" FROM VOC FIRST 1;

[PhilHibbs]

... Iconv
(lSrcToStgExtract.Line [7,2] : '/' :lSrcToStgExtract.Line [5,2] : '/' :
lSrcToStgExtract.Line [1,4], "D/E").

"D/E" means "Date with forward slashes in the locale's default layout", so a US environment will expect 12/31/2009 whereas a UK environment will expect 31/12/2009. Perhaps your project settings are different from what they used to be.

*Update*: Also, if you write a routine that uses "D/E", when you test it in Designer it will use your PC's setting but when you run the job it will use the DataStage setting. Very annoying!