Post any question you may have in regards to GoAnywhere Director and let our talented support staff and other users assist you.
- Posts: 1
- Joined: Thu Nov 01, 2012 7:34 am
I have several IBM Queries that are scheduled to run in Linoma that utilize date selection criteria. Most run on the first of the month with record selection of new records added to the file from the previous month. I have three Queries that run on Monday morning that select the newly added records from the prior week.
I'm currently manually updating the selection criteria on each query. Is there a way of automating selection criteria using Go Anywhere?
- Posts: 592
- Joined: Tue Jul 17, 2012 2:12 pm
- Location: Phoenix, AZ
If you're asking can GoAnywhere generate the dates you need (Date of 7 days ago) .. or, (Month - 1), etc ..
Then, the answer is yes. And, these values can be passed into your IBMi Queries.
This can be accomplished by creating variables like this:
<format outputVariable="DTE_yyyyMMdd" pattern="yyyyMMdd" month="-1" />
<format outputVariable="lastweek" pattern="yyyy-MM-dd" dayOfMonth="-7" />
Lead Solutions Consultant
Return to “Community Forum”