I want the output of dates from particular range in a specific format
date1: 2019-06-18(from Table) date2: 2019-06-22(systemDate)
Output will be:
2019-06-19,2019-06-20|2019-06-20,2019-06-21
Date 1 will be fetched from the table. Once we get the dates, I need to use this date in processing stage and will compare it with date2 i.e current system date. After comparision ,I need the o/p as above. I am having trouble to get the o/p in that format 2019-06-19,2019-06-20|2019-06-20,2019-06-21( in same column if possible, otherwise I will combine the column to one).
i was trying to Use while loop in Transformer stage.
Print date in particular range in Datastage
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 3
- Joined: Sat Jun 22, 2019 10:50 am
- Location: Pune
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Moderator: please move this post to the parallel forum
This looks like it would be easily managed using looping within a Transformer stage. The exit condition from the loop would be that the test date has reached the current date.
The documentation on looping shows examples of building a delimited string. The rest is straightforward date manipulation (plus converting dates to string to get the required format).
If you want more specific help, please post what you have tried, the result you obtained from it, and any other pertinent information.
This looks like it would be easily managed using looping within a Transformer stage. The exit condition from the loop would be that the test date has reached the current date.
The documentation on looping shows examples of building a delimited string. The rest is straightforward date manipulation (plus converting dates to string to get the required format).
If you want more specific help, please post what you have tried, the result you obtained from it, and any other pertinent information.
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.