SYSTEMSQLPRECOMPILEDEXPRESSIONS: Data Dictionary SQL Pre-compiled Expressions |
All compiled SQL statements executed by Invantive's UniversalSQL 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 UniversalSQL 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. |
18-10-2024 06:49 Version 24.0.345-PROD+4945