Re: SQLRPGLE & JSON CTE Statements -101 Error

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Need to see the code...

Charles (yes the same one)

On Wed, Jun 24, 2020 at 4:22 PM Baeten, John <John.Baeten@xxxxxxxxxx> wrote:

> 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.
> --
> This is the RPG programming on IBM i (RPG400-L) mailing list
> To post a message email: RPG400-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/rpg400-l
> or email: RPG400-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/rpg400-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.
>
> Help support midrange.com by shopping at amazon.com with our affiliate
> link: https://amazon.midrange.com