IConv function behaving differently in DS 7.5.2 and 7.5
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 158
- Joined: Tue Mar 15, 2005 3:16 am
IConv function behaving differently in DS 7.5.2 and 7.5
Hi
I am using IConv to find out the difference between two dates (i.e Date1 and Date2) in terms of days, as follows:
IConv(Date2,"D")-IConv(Date1,"D")
The format of dates in 7.5 are as follows:
Date1 format
YYYYMMDD
(Integer datatype)
Date2 format
"MM-DD-YYYY"
(char datatype)
We migrated our jobs to DS 7.5.2, then these two formats are not working with DataStage 7.5.2.
I tested that the following version is working fine with DS 7.5.2
"DD-MM-YYYY"
(char datatype)
I want your confirmation whether it works differently with the two versions.
I need your help in Date1 format. We are passing it as an argument (integer), How do I use IConv for this.
Thanks
Sai
I am using IConv to find out the difference between two dates (i.e Date1 and Date2) in terms of days, as follows:
IConv(Date2,"D")-IConv(Date1,"D")
The format of dates in 7.5 are as follows:
Date1 format
YYYYMMDD
(Integer datatype)
Date2 format
"MM-DD-YYYY"
(char datatype)
We migrated our jobs to DS 7.5.2, then these two formats are not working with DataStage 7.5.2.
I tested that the following version is working fine with DS 7.5.2
"DD-MM-YYYY"
(char datatype)
I want your confirmation whether it works differently with the two versions.
I need your help in Date1 format. We are passing it as an argument (integer), How do I use IConv for this.
Thanks
Sai
-
- Participant
- Posts: 158
- Joined: Tue Mar 15, 2005 3:16 am
I would think the solution would involve a call to your official Support provider. I was only able to check 7.5.1A here and it returned the expected value.
Interesting... just saw Ken's question between previews. Curious to see if that will affect the answer.
Interesting... just saw Ken's question between previews. Curious to see if that will affect the answer.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
Sai,
This is hit and trial solution,Please use Oconv function with different options for the value 14567 in 7.5.2 version and check out for which option it returns you value 20071118 or 2007 11 18 and then use that option.
if it didnt work then please contact ascential suport for this problem.
I hope this will help.
Cheers,
ZDC
This is hit and trial solution,Please use Oconv function with different options for the value 14567 in 7.5.2 version and check out for which option it returns you value 20071118 or 2007 11 18 and then use that option.
if it didnt work then please contact ascential suport for this problem.
I hope this will help.
Cheers,
ZDC
Zero Degree Consulting
Well, NLS makes ICONV/OCONV work differently. During the upgrade, maybe they installed NLS support by accident, which now makes ICONV/OCONV behave differently than its non-NLS mode.
I'm waiting to hear this answer, because anything else is guess work. In general, avoid the "D" option and try to explicitly state the format when known. "D-YMD[4,2,2]" is always better than just "D".
I'm waiting to hear this answer, because anything else is guess work. In general, avoid the "D" option and try to explicitly state the format when known. "D-YMD[4,2,2]" is always better than just "D".
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
-
- Participant
- Posts: 158
- Joined: Tue Mar 15, 2005 3:16 am
-
- Participant
- Posts: 158
- Joined: Tue Mar 15, 2005 3:16 am
-
- Participant
- Posts: 158
- Joined: Tue Mar 15, 2005 3:16 am
Hi
I just found that NLS button in administrator is enabled in new DS Server 7.5.2. Where as it is disabled in our previous DS server 7.5.
Taken that NLS is installed in my new machine, To make IConv to work, What should I need to do.
I mean, To get correct ouput from IConv for 20071118, What exactly I need to do
Thanks
Sai
I just found that NLS button in administrator is enabled in new DS Server 7.5.2. Where as it is disabled in our previous DS server 7.5.
Taken that NLS is installed in my new machine, To make IConv to work, What should I need to do.
I mean, To get correct ouput from IConv for 20071118, What exactly I need to do
Thanks
Sai
Not positive, but pretty sure one way to check is to see if you have an entry for NLSMODE in your $DSHOME/uvconfig file. No mention = not installed. If it is there, then seeing it set to 1 shows it as enabled, while 0 is disabled.
If you do have it installed and enabled and can afford to experiment a little: shutdown DataStage, change the value, 'regen' and then restart. Let us know if the behaviour changes back.
If you do have it installed and enabled and can afford to experiment a little: shutdown DataStage, change the value, 'regen' and then restart. Let us know if the behaviour changes back.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 158
- Joined: Tue Mar 15, 2005 3:16 am