Data Dictionary Data Model|
SYSTEMSQLPRECOMPILEDEXPRESSIONS: Data Dictionary SQL Pre-compiled Expressions |
Contents Previous Home Next More |
All compiled SQL statements executed by the Invantive SQL engine.
Catalog: DataDictionary
Schema: Invantive
Alias: spn
Label: SQL Pre-compiled Expressions
This is a read-only view. The Data Dictionary API may not support changing the data or the Invantive SQL driver for Data Dictionary does not cover it. In the latter case, please use the table NativePlatformScalarRequests to upload data to the Data Dictionary API.
View Columns
The columns of the view SYSTEMSQLPRECOMPILEDEXPRESSIONS are shown below. Each column has an SQL data type.
Name |
Data Type |
Label |
Required |
Documentation |
|---|---|---|---|---|
CACHE_KEY |
string(240) |
Cache Key |
☑ |
Unique cache key. |
EXPRESSION |
string |
Expression |
☐ |
Debug view. |
FIRST_SOURCE_CODE |
string |
First Source Code |
☐ |
First source code. |
ID |
int64 |
ID |
☑ |
Unique ID of the precompiled expression. |
INITIAL_REGISTRATION |
datetime |
Initial Registration |
☑ |
Initial registration. |
LAST_USAGE |
datetime |
Last Usage |
☑ |
Last time used. |
USAGE_COUNTER |
int32 |
Usage Counter |
☑ |
Number of times the pre-compiled expression was used. |
17-05-2021 11:57 Version 20.1.419-BETA+3191
