×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
Build the SQL in an RPG and then call DOCSQL.
Make life easy :-)
Regards,
Richard Schoen
RJS Software Systems Inc.
Where Information Meets Innovation
Document Management, Workflow, Report Delivery, Forms and Business Intelligence
Email: richard@xxxxxxxxxxxxxxx
Web Site:
http://www.rjssoftware.com
Tel: (952) 736-5800
Fax: (952) 736-5801
Toll Free: (888) RJSSOFT
------------------------------
message: 6
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?
LOL!
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
string.
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.
Regards
Vern
midrange.com
