Re: SQL using WITH/AS (Solved)

As with the delimited column name suggestion in my earlier reply,
that assists for reserved words as well. The use of a delimited
identifier can prevent such issues; e.g.:

with
temp (current) as (select intcol from qsys2/qsqptabl)
select * from temp where "CURRENT">0

For consistency however, perhaps better:

with
temp ("CURRENT") as (select intcol from qsys2/qsqptabl)
select * from temp where "CURRENT">0

To prevent ever having the issue arise for a previously functional
statement, due to a newly added reserved word, the delimiters can be
added to column names whenever\wherever. The delimiters are optional in
whatever context the usage as a column identifier can be safely assumed
by the parser\syntax-checker. Always best to review the list of
reserved words from the most recent release, to know what identifiers to
avoid or to delimit; e.g.: