× 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.



David, the procedure simply removes the "outside" quotes, not the inside
ones. If the string doesn't have any surrounding quotes then no harm.

RUNSQL2 CMD('update truc set ma=''hello'' where myzone = ''blah blah''')
REXX session:
'update truc set ma=''hello'' where myzone = ''blah blah'''
update truc set ma=''hello'' where myzone = ''blah blah''
Press ENTER to end terminal session.

One extra call in the REXX and problem solved. In my opinion the extra
flexibility and validation the command interface provides offsets
working with quotes.

Good luck and have fun with REXX.

Loyd Goodbar
Business Systems
BorgWarner Shared Services
662-473-5713
-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of David FOXWELL
Sent: Monday, October 13, 2008 10:55 AM
To: Midrange Systems Technical Discussion
Subject: RE: REXX QIBM_REX_FIND_SRCMBR

Thanks Lloyd,

I'll be sticking to my original command with a CL as a CPP. Imagine this
command :
RUNSQL2 CMD('update truc set ma=''hello'' where myzone = ''blah blah''')
etc, it's simply unworkable.

But thanks for the interesting REXX functions that I completely ignored
the existance of until now.




As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.