Build the SQL in an RPG and then call DOCSQL.
Make life easy :-)
RJS Software Systems Inc.
Where Information Meets Innovation
Document Management, Workflow, Report Delivery, Forms and Business Intelligence
Web Site: http://www.rjssoftware.com
Tel: (952) 736-5800
Fax: (952) 736-5801
Toll Free: (888) RJSSOFT
date: Fri, 30 Mar 2012 13:34:37 -0500
from: Vern Hamberg <vhamberg@xxxxxxxxxxx>
subject: Re: Is there a better way to run SQL in a CL pgm?
Joel, you may know that our DOCSQL utitlity, which you are using, does
use STRQMQRY - it is just so generic that you have to build up the whole
There are very nice ways to get quotes in the right places by using a
custom *QMQRY - it's pretty easy - and one of the tricks is to use a
substitution variable, similar to Michael's suggestion - but for a
single quote - then you use that variable &QT, say, everywhere and it
just gets handled. There have been other posts here about that - here's
where I learned that trick.