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.

Query selection criteria

Postby 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?
cbalint
 
Posts: 1
Joined: Thu Nov 01, 2012 7:34 am

Re: Query selection criteria

Postby 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
Sr. Product Specialist
(402) 944.4242
(800) 949-4696
Support_Rick
Support Specialist
 
Posts: 196
Joined: Tue Jul 17, 2012 2:12 pm


Return to Community Forum

Who is online

Users browsing this forum: No registered users and 1 guest

cron