Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Urgent: Problem with GENERATE SUBROUTINE POOL

Former Member

‎2007 Aug 11 4:37 PM

0 Likes
501

Hi all,

I tried to use the GENERATE SUBROUTINE POOL but I have the following problem.

If I generate a big report, the system returns the following error:

"The length of the current statement is greater that the allowed maximum length of 28 kilobytes."

How can I solve this problem?

Thanks in advance.

Best regards,

Giulio.

Hi all,

I tried to use the GENERATE SUBROUTINE POOL but I have the following problem.

If I generate a big report, the system returns the following error:

"The length of the current statement is greater that the allowed maximum length of 28 kilobytes."

How can I solve this problem?

Thanks in advance.

Best regards,

Giulio.

Reply
2 REPLIES 2
Read only

Clemenss
Active Contributor

‎2007 Aug 11 5:26 PM

0 Likes
462

Hi giulio,

split your report into modules and generate separately.

BTW: I wonder what needs to be generated.

Regards,

Clemens

Read only

Former Member

‎2007 Aug 11 5:59 PM

0 Likes
462

Hi Clemens,

I have the necessity to create a dynamic query for reading the informations from native sql. But the where conditions is too long, because I have many filter criteria.

Now, I have tried to create a subquery in the where conditions, but Unfortunately the query doesn't return any value.

And it's impossible separate the process, because I have the necessity to extract (in one query) a maximum number of entries indicated by user for the specific filter criteria.

Thanks for your support.

Best regards,

Giulio