<http://schema.org/articleBody>
"&amp;lt;disclaimer&amp;gt;I posted this message on comp.sys.ibm.as400.misc too: sorry for the cross-post, but that newsgroup seems a bit negleted&amp;lt;/disclaimer&amp;gt; I'm trying to support AS400 database in Activiti (http://www.activiti.org). This open source project creates lots of query like this: SELECT SUB.* FROM (select RES.* , row_number() over (Order by A.field1) rnk FROM (select A.field1, B.field1 from A inner join B on A.X = B.Y) RES ) SUB WHERE SUB.rnk &amp;gt;= ? AND SUB.rnk &amp;lt; ? Unfortunately this query fails with msg SQL500..."^^<http://www.w3.org/2001/XMLSchema#string>
<http://archive.midrange.com/midrange-l/201210/msg01047.html>