Consultor Eletrônico

Status: Verified

FACT(s) (Environment):

Report Builder

SYMPTOM(s):

Problems creating large reports.

** More than <value> characters in a single statement--use -inp parm. (135)

(247) Unable to understand after -- "DECLARE"

CAUSE:

This is due to the ESQL statement that Report Builder genrates and sends to the Progress SQL engine.
This is not a bug. This issue is simply the result of exceeding the default setting of 4096 characters in a single statement.

FIX:

The customer can increase the -inp setting by adding reference to the -inp parameter to either the EngineParameters setting in the [ReportBuilderDefaults] section of the ini or registry.

Please note that the -inp parameter is a startup parameter, not a connection parameter.

Please note that there is an SQL engine limitation that will prevent a value greater than 8000 from being used. Depending upon the number of fields in the table and the length the field names, 8000 characters may not be enough.

Note also that prior to Progress release 7.3B the select statement that Report Builder creates when building a join includes every field in the table.

To modify the value of the -inp parameter follow the next steps:

In the INI or Registry change/add the following:
[ReportBuilderDefaults]
EngineParameters=-inp 32000

In the rbstart.pf file change/add the following:
-inp 32000