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.
DataStage Server Edition 7.5.3 => Iconv not working with
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 26
- Joined: Fri Jul 13, 2007 6:33 am
DataStage Server Edition 7.5.3 => Iconv not working with
V.Sarat Srinivas
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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;
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Premium Member
- Posts: 1044
- Joined: Wed Sep 29, 2004 3:30 am
- Location: Nottingham, UK
- Contact:
Re: DataStage Server Edition 7.5.3 => Iconv not working w
"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.sarat.srinivas@tcs.com wrote:... Iconv
(lSrcToStgExtract.Line [7,2] : '/' :lSrcToStgExtract.Line [5,2] : '/' :
lSrcToStgExtract.Line [1,4], "D/E").
*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!
Phil Hibbs | Capgemini
Technical Consultant
Technical Consultant