I have one query
Which is a join of table A and Table B.
select store,sum(amt) from table A and table B where
A.fld1 = B.fld1
A.fld2 = B.fld2
A.fld3 = b.fld3
AND A.fld3 between date range
group by Store
order by store.
I need to run this query in a batch mode,just by changing the date range.how can i run this query in WRKQRY Tool.
iam doing now in STRSQL which runs intercativley for an hour.
So i wanted to run in batch and saev the result sets in one file.
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!
No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.
Your password has been sent to:firstname.lastname@example.org
To follow this tag...
Thanks! We'll email you when relevant content is added and updated.
Share this item with your network: