B.11 Content of SQL_DEFINE_SOURCE
SQL_DEFINE_SOURCE stores SQL statement information. Each row stores information for one SQL text.
The following table describes the content of SQL_DEFINE_SOURCE.
|
No. |
Column name |
Data type |
Stored information |
|---|---|---|---|
|
1 |
SOURCE_ID |
INTEGER |
SQL statement ID |
|
2 |
SOURCE_TYPE |
CHAR(1) |
SQL statement type:
|
|
3 |
DEFINE_SOURCE |
VARCHAR(64000) |
|
|
4 |
SOURCE_SIZE |
SMALLINT |
Actual length of SQL statement |
- Note
-
When the dictionary table SQL_DEFINE_SOURCE is searched, only the information on the viewed table defined by the HADB user is output as the search result.
Even if you perform a search by specifying HADB or MASTER for the schema name, the search result will be 0 (no error will occur).