Client Database-Request Statement Caching Level (-clstmtCacheLevel)
- Last Updated: February 11, 2026
- 1 minute read
- OpenEdge
- Version 13.0
- Documentation
Use Client Database-Request Statement Caching level
(-clstmtCacheLevel) to enable all future connections to use
client statement cache at the specified level.
| Operating system and syntax | UNIX / Windows |
-clstmtCacheLevel
n
|
||
|---|---|---|---|---|
| Use with | Maximum value | Minimum value | Single-user default | Multi-user default |
| Client Connection, Database Server | 2 | 0 | N/A | 0 |
- n
- An integer in the range of 0 to 2. Set
n as follows to indicate the client statement cache
level setting:
- 0—This default setting disables all future connections to use client statement cache at the specified level.
- 1—(Single) The ABL client reports only reports the current ABL program and line number, or a single SQL statement.
- 2—(Stack) Report the call stack up to the current ABL program and line number.
- Adjust Startup Parameters menu of PROMON—For more information, see Modify database startup parameters online using PROMON.
_DbParamsVST—For more information, see Database startup parameters file status (_DbParams).- Options 3a and 3b of the PROMON
Client Database-Request Statement Caching menu
associated with future user settings.
For more information, see Client Database-Request Statement Cache.3a. Activate for All Future Users 3b. Activate for All Future Users by User Type