Consultor Eletrônico

Status: Unverified

GOAL:

Is there a VST for client statement cache?

GOAL:

What VST should I use fo client statement cache?

GOAL:

What virtual system table can I use for client statement cache?

FACT(s) (Environment):

All Supported Operating Systems
OpenEdge 10.1C
OpenEdge 10.2x

FIX:

Yes, the VST is _connect.
Specifically, these are the fields that can be queried using ABL code.

_Connect-CacheInfoType

CHARACTER

Displays the client datbase-request statement cache types, which include:
* S ? SQL statements.
* A ? Current ABL program and line number.
* T ? The ABL program stack. Includes up to 32 ABL fully qualified program names with line numbers. This field controls the contents of _Connect-Trace-Info and _Connect-CacheLineNumber.
_Connect-CacheInfo

CHARACTER

Contains tracing information; this field includes:
* A ? Extent 1 contains the fully qualified ABL program.
* R ? Each extent contains a fully qualified ABL program name. Only the most current 32 program names are returned.
* S ? A SQL statement.
_Connect-CacheLineNumber

INTEGER

Contains line numbers; this field includes:
* A ? Extent 1 contains the line number of the current ABL program.
* R ? Each extent contains the line number of the fully qualified ABL program name. Only the most current 32 program names are returned.
* S ? Unknown.
_Connect-CacheLastUpdate

CHARACTER

The current date and time of the client database-request statement cache
_Connect-CachingType

CHARACTER

The type of client database-request statement caching performed by the client; this field includes:
* 1 ? One ABL program or a single SQL statement will be stored in the client database-request statement cache.
* 2 ? An ABL program stack or a single SQL statement stored in the client database-request statement cache.
* 3 ? The client sends an ABL program stack or a single SQL statement to the client database-request statement cache.