Consultor Eletrônico



Kbase 17544: Actuate - More than 4096 characters in a single stmt (135)
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   10/05/1998
Actuate - More than 4096 characters in a single stmt (135)

When using Actuate and getting the error:

More than 4096 characters in a single statement-use -inp parm. (135)

the SQL SELECT statement is larger than the default limit of
4096 characters.

To fix this problem the -inp and -tok startup parameters need to
be used. The OIB will not pass these startup parameters to the OID,
instead the parameters must be placed in a .pf file that all
of Progress reads. This way the OID will read the values from
the .pf file.

The default file is c:\dlc\startup.pf.
If you want to use another .pf, the PROSTARTUP environment variable
must be set to point to this new .pf.
For example:

SET PROSTARTUP=c:\actuate\new.pf

An example of new.pf

-inp 8192 # max value is 32000
-tok 1600 # max value is 1600

Progress Software Technical Support Note # 17544