The SQLSC_ENTRY (SCE) table consists of one row for each query in the Cache.
|
Column Name |
SQL Data Type |
Nullable |
Description |
|---|---|---|---|
|
SCE_ID |
INTEGER |
No |
Unique ID |
|
SCE_HASH-ID |
INTEGER |
No |
internal use |
|
SCE_PLAN_ID |
INTEGER |
No |
ID of the query's SQLSC_PLAN |
|
SCE_QUERY_NO |
INTEGER |
No |
Identifies the query (implementation pending) |
|
SCE_STMT_TYPE |
CHAR(12) |
No |
query/insert/update/delete |
|
Copyright © 2014 CA.
All rights reserved.
|
|