Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
mgendy
Premium Member
Posts: 44 Joined: Thu Sep 10, 2009 5:30 am
Contact:
Post
by mgendy » Sun Nov 01, 2009 8:07 am
Hi All,
i just have a little question , does Aggregator Stage min and max functions support time stamps , i tried to use it but it gives an error saying that couldn't convert from timestamp to dfloat , but i beleive that it worked with me before but in another envirnoment , i just ask to know the ability of doing that
Mohmmed Elgendy
Senior System Analyst
Data IntegrationTeam
Etisalat Egypt
+20 1118511161
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Sun Nov 01, 2009 8:59 am
The only way it might work is if you add the 'Preserve Type' option and it seems that wasn't added until the 7.5.2 release. Let us know.
-craig
"You can never have too many knives" -- Logan Nine Fingers
mgendy
Premium Member
Posts: 44 Joined: Thu Sep 10, 2009 5:30 am
Contact:
Post
by mgendy » Mon Nov 02, 2009 3:15 am
chulett wrote: The only way it might work is if you add the 'Preserve Type' option and it seems that wasn't added until the 7.5.2 release. Let us know. ...
yes yes yes , it is working now , many thanks chulett for your help
Mohmmed Elgendy
Senior System Analyst
Data IntegrationTeam
Etisalat Egypt
+20 1118511161
synsog
Premium Member
Posts: 232 Joined: Sun Aug 01, 2010 11:01 pm
Location: Pune
Post
by synsog » Wed Oct 20, 2010 7:50 am
Where to add this preserve type option? could you pls help me out? I need to perform the max funtion on string column. can i do that?
anbu
Premium Member
Posts: 596 Joined: Sat Feb 18, 2006 2:25 am
Location: india
Post
by anbu » Wed Oct 20, 2010 8:03 am
Yes you can do max on string. When you select Column for Calculation, you can see the Preserve type as one of the properties
You are the creator of your destiny - Swami Vivekananda
synsog
Premium Member
Posts: 232 Joined: Sun Aug 01, 2010 11:01 pm
Location: Pune
Post
by synsog » Wed Oct 20, 2010 8:06 am
anbu wrote: Yes you can do max on string. When you select Column for Calculation, you can see the Preserve type as one of the properties
could you please tell where do i get that? Please????
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Wed Oct 20, 2010 9:50 am
As noted, it's an additional property you can add, just like any of the other additional properties. What version of DataStage do you have?
-craig
"You can never have too many knives" -- Logan Nine Fingers
synsog
Premium Member
Posts: 232 Joined: Sun Aug 01, 2010 11:01 pm
Location: Pune
Post
by synsog » Wed Oct 20, 2010 10:46 pm
chulett wrote: As noted, it's an additional property you can add, just like any of the other additional properties. What version of DataStage do you have?
Its 7.5.1.
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Wed Oct 20, 2010 11:10 pm
I asked because, unless I was wrong back when I posted this:
chulett wrote: it seems that wasn't added until the 7.5.2 release
-craig
"You can never have too many knives" -- Logan Nine Fingers
synsog
Premium Member
Posts: 232 Joined: Sun Aug 01, 2010 11:01 pm
Location: Pune
Post
by synsog » Thu Oct 21, 2010 12:10 am
chulett wrote: I asked because, unless I was wrong back when I posted this:
chulett wrote: it seems that wasn't added until the 7.5.2 release
Thanks, is there any way out to get maximum value on string column?