I read Rob’s great article
and was able to use RUNSQL like this:
RUNSQL SQL('DELETE FROM QTEMP/FILEA WHERE JOJOB = ''TJOBC''')
Now, I’m using this select statement:
where joentt = 'CA'
and jojob = 'QZLSFILET'
and jopgm = 'QLESPI'
What’s the syntax of the RUNSQL that would delete based on that
select, if possible?
This mailing list archive is Copyright 1997-2013 by MIDRANGE dot 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 here. If you have questions about this, please contact