Query selection criteria

Post any question you may have in regards to GoAnywhere Director and let our talented support staff and other users assist you.
2 posts Page 1 of 1

cbalint

Posts: 1
Joined: Thu Nov 01, 2012 7:34 am

Post by cbalint » Fri Sep 27, 2013 2:18 pm
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?

Support_Rick

Support Specialist
Posts: 590
Joined: Tue Jul 17, 2012 2:12 pm
Location: Phoenix, AZ

Post by Support_Rick » Fri Sep 27, 2013 2:59 pm
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:

<timestamp version="1.0">
<format outputVariable="DTE_yyyyMMdd" pattern="yyyyMMdd" month="-1" />
<format outputVariable="lastweek" pattern="yyyy-MM-dd" dayOfMonth="-7" />
</timestamp>
Rick Elliott
Lead Solutions Consultant
(402) 944.4242
(800) 949-4696
2 posts Page 1 of 1