EXT_DATABANKS
The EXT_DATABANKS system view shows databanks on which the current ident has table privilege.
An ident with the system privileges BACKUP or SHADOW may see all databanks in the system.
Column name
|
Data type
|
Description
|
| DATABANK_
CREATOR |
VARCHAR(128) |
The name of the authorization ident that created the databank. |
| DATABANK_NAME |
VARCHAR(128) |
The name of the databank. |
| DATABANK_TYPE |
VARCHAR(20) |
One of:
"LOG"
"TRANS"
"NULL"
"WORK". |
| IS_MASTER |
VARCHAR(3) |
One of:
"YES" = the databank is a master databank
"NO" = the databank is not a master databank. |
| IS_ONLINE |
VARCHAR(3) |
One of:
"YES" = the databank is online
"NO" = the databank is offline. |
| FILE_NUMBER |
INTEGER |
Ordinal number for databank file. |
| FILE_NAME |
VARCHAR(256) |
File name for databank. |
