Print date in particular range in Datastage

Post questions here relative to DataStage Server Edition for such areas as Server job design, DS Basic, Routines, Job Sequences, etc.

Moderators: chulett, rschirm, roy

Post Reply
shivam5483
Participant
Posts: 3
Joined: Sat Jun 22, 2019 10:50 am
Location: Pune

Print date in particular range in Datastage

Post by shivam5483 »

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.
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply