Types of Tables and Columns That CIAI Query Supports
The following information lists the types of tables that CIAI query supports.
| Table Type | Supported for a CIAI Query |
|---|---|
Data (Intersection) |
Yes |
Data (Private) |
Yes |
Data (Public) |
Yes |
Database View |
No |
Dictionary |
No |
Extension |
Yes |
Extension (Siebel) |
Yes |
External |
No |
Interface |
No |
Log |
No |
Repository |
No |
The following table lists the types of columns that CIAI query supports.
| Column Type | Supported for a CIAI Query |
|---|---|
Data (Private) |
Yes |
Data (Public) |
Yes |
Denormalized |
Yes |
Extension |
Yes |
External |
No |
IFMGR: Exists |
No |
IFMGR: FKey |
No |
IFMGR: Status |
No |
IFMGR: ROW_ID |
No |
System |
No |
The following table lists the physical types of columns that CIAI query supports.
| Physical Type | ||
|---|---|---|
| DB Value | Type | Supported for a CIAI Query |
C |
Char |
Yes |
D |
Date |
No |
L |
Long |
Yes |
L |
CLOB |
Yes |
N |
Number |
No |
S |
Time Stamp |
No |
T |
Date Time |
No |
U |
UTC Date Time |
No |
V |
Varchar |
Yes |
X |
Text |
Yes |