SQLRPGLE & JSON CTE Statements -101 Error

I am able to run the SQL statement in ACS Run SQL Scripts, but when I add those same statements to the SQLRPGLE program I get the following SQLCOD error. The SQLSTATE code is 54011 which states: Too many columns were specified for a table, view, or table function.



Can someone tell me if there is something that needs to be turned on our system to be able to run these in an SQLRPGLE program?



-101 THE STATEMENT IS TOO LONG OR TOO COMPLEX

Explanation

DB2(r) cannot process the statement because it exceeds the system limits for length or complexity. Enabling parallelism will increase the complexity of the statement.

System action

DB2 cannot process the statement.

Programmer response

Divide the statement into shorter or less complex SQL statements.

If the statement enables parallelism, try disabling parallelism. You may do this by using the DEGREE(1) bind option for static SQL, or by setting the CURRENT DEGREE special register to '1' for dynamic SQL.



CONFIDENTIALITY NOTICE: This e-mail communication and any attachments may contain proprietary and privileged information for the use of the designated recipients named above. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.