RRN, PARTITION, and NODENUMBER functions with Common Table Expression (CTE) argument changes

RRN, PARTITION, and NODENUMBER functions with Common table expressions might trigger a CPD43AD.

Before IBM® i 7.2, a stated restriction that an RRN, PARTITION, or NODENUMBER function could not have as an argument a common table expression whose outer fullselect includes an aggregate function, a GROUP BY clause, a HAVING clause, a UNION, INTERSECT, or EXCEPT clause, a DISTINCT clause, a VALUES clause, or a table-function was not fully enforced. Starting in IBM i 7.2, the restriction is enforced via SQLCODE = -5001. The joblog will show that the SQL5001 error is preceded by a CPD43AD diagnostic message with reason code 3.