I'm facing an issue with the result of Date Conversion function .
I processed the same input file in different servers .In one server i'm having a version Datastage 7.5.1 .And another server i'm using Datastage 7.5.2 . But i'm getting diferent ouptut values for one of the field (DAY_OF_WEEK )
In the Transformer we are having the below function.
Oconv(Iconv(to_trans_juliandate.INV_DATE_JUL, "DYJ"), "DW")
Will these DateConverison functions results differenent values for Differen versions of datastage . (7.5.1 and 7.5.2 )
For Example ::
The INV_DATE_JUL column contains the 2009326 value . After applying the above function it gives output value as 1 in server having datastage version 7.5.2 and 7 in another server.
Could you please help me in getting the correct output value.
Ouptut value different for different datastage versions
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 425
- Joined: Sat Nov 19, 2005 9:26 am
- Location: New York City
- Contact:
This is not a QS question but ...... both output are correct ... nothing wrong with the Iconv/Oconv function
Looks like one of your server (result 1) is having NLS enable where Sunday is the first day of the week. The other server ( result 7 ) is not having NLS enable and Monday will be the first day of the week hence Sunday will result in weekday number 7
If you want to have same results disable the NLS functionality for the Date/Time locale. Job property --> NLS page --> Date /Time = OFF
Looks like one of your server (result 1) is having NLS enable where Sunday is the first day of the week. The other server ( result 7 ) is not having NLS enable and Monday will be the first day of the week hence Sunday will result in weekday number 7
If you want to have same results disable the NLS functionality for the Date/Time locale. Job property --> NLS page --> Date /Time = OFF
Julio Rodriguez
ETL Developer by choice
"Sure we have lots of reasons for being rude - But no excuses
ETL Developer by choice
"Sure we have lots of reasons for being rude - But no excuses