SQL0101 in an SQLRPGLE program

Hi List

I am trying to prepare the following SQL statement in an SQLRPGLE program and am getting the error SQL0101 SQL statement too long or complex.

with t1 as (select distinct aydotc
from acbdxtr
join ayagnt
on abdbrok = ayagnt
where abdrcty in ('PR')
and abdlnbs = 'R*'
and ABDGLDT between 00000000 and 99999999)

values (select count(*) from t1) into ?

If I strip out the "values" and "into ?" and run the statement in interactive SQL it works fine and generates a result.

The statement is built dynamically, within a loop that will ultimately prepare six variations. I'm wondering if the error message is a red herring and if the error is due to reusing the same preparation ID (prpCount) each time through the loop?

Has anybody come across this issue before or have any ideas.

Thanks in advance for any and all suggestions.

All the best
Jonathan

________________________________
Proud partner of The Ageas Bowl and the Ageas Salisbury International Arts Festival.

Registered Address: Ageas House, Hampshire Corporate Park, Templars Way, Eastleigh, Hampshire, SO53 3YA Registered Number: 354568 England

Authorised by the Prudential Regulation Authority and regulated by the Financial Conduct Authority and the Prudential Regulation Authority

This e-mail together with any attachments are intended for the addressee only and may be private and confidential. If you are not the intended recipient, or the person responsible for delivering it to the intended recipient, you must not open any attachments, or copy, disclose, distribute, retain or use this e-mail, including any attachments, in any way whatsoever; please return it to us immediately using the reply facility on e-mail.

Consider the environment and think before you print this email.