In server job we use Iconv and Oconv to do conversion of date and then compare between the internal values..
how can ido the same in parallel extender...
tried using DatetoString but does not work for me
please help
How to convert DATE in internal format for comparison
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Without using a stage type that supports BASIC expressions (such as the "BASIC Transformer" stage), the parallel extender does not support the concept of an internal format for dates.
You could, of course, create a buildop that uses substringing techniques to decompose the dates into "days since a certain day zero" and (perhaps a separate buildop) to compare them.
You could, of course, create a buildop that uses substringing techniques to decompose the dates into "days since a certain day zero" and (perhaps a separate buildop) to compare them.
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.
Re: How to convert DATE in internal format for comparison
Hi,
Try "JulianDayFromDate", it is a kind of internal date.
Good luck
Matthieu
Try "JulianDayFromDate", it is a kind of internal date.
Good luck
Matthieu
Re: How to convert DATE in internal format for comparison
ashcar wrote:In server job we use Iconv and Oconv to do conversion of date and then compare between the internal values..
how can ido the same in parallel extender...
tried using DatetoString but does not work for me
please help
We can still use Iconv and Oconv in parallel extender by using shared container. It will incorporate the functionalities into parallel extender. Other functions available are JulianDayfromDate DateFromJulianDay.