| SQLTAB |
Table Name |
CHAR |
30 |
0 |
DD02L
|
TABNAME
|
|
| INDEXNAME |
Unique Index ID in a Table |
CHAR |
3 |
0 |
|
INDEXID
|
|
| AS4LOCAL |
Activation State of Repository Object |
CHAR |
1 |
0 |
|
AS4LOCAL
|
| A |
Entry was activated or generated in this form |
| L |
Lock entry (first N version) |
| N |
Entry was edited, but not activated |
| S |
Previously active entry, backup copy |
| T |
Temporary version when editing |
|
| AS4VERS |
Version of the entry (not used) |
NUMC |
4 |
0 |
|
AS4VERS
|
|
| AUTHCLASS |
Activation type |
NUMC |
2 |
0 |
|
AUTHCLASS_
|
|
| UNIQUEFLAG |
Flag for UNIQUE indexes |
CHAR |
1 |
0 |
|
UNIQUEFLAG
|
|
| AS4USER |
Last Changed By |
CHAR |
12 |
0 |
|
AS4USER
|
|
| AS4DATE |
Last Changed On |
DATS |
8 |
0 |
|
AS4DATE
|
|
| AS4TIME |
Last changed at |
TIMS |
6 |
0 |
|
AS4TIME
|
|
| ACTFLAG |
Activation flag |
CHAR |
1 |
0 |
|
ACTFLAG
|
|
Start of activation or activation successful |
| I |
Internal checks successful |
| U |
External checks for object OK or error in table as dependent |
|
| DBINDEX |
Database index |
CHAR |
40 |
0 |
|
DBINDEX_D
|
|
| DBSTATE |
Status of index on the database |
CHAR |
1 |
0 |
|
DDIXDBSTAT
|
|
Create on database |
| D |
Create on database depending on DB system |
| O |
Do not create on database |
|
| DBINCLEXCL |
List of DB systems used as list of inclusions/exclusions |
CHAR |
1 |
0 |
|
DDIXINCEX
|
| E |
List of exclusions: Do not create index on these DB systems |
| I |
List of inclusions: Create index on these DB systems |
|
| DBSYSSEL1 |
Choose a database system for DB-specific indexes |
CHAR |
3 |
0 |
|
DDIXDBSEL
|
| ADA |
ADABAS D |
| DB2 |
DB2 for MVS |
| DB4 |
DB2 for AS/400 |
| DB6 |
DB2 common server |
| HDB |
SAP HANA Database |
| INF |
INFORMIX |
| MSS |
MSS SQL Server |
| ORA |
ORACLE |
| SYB |
SYBASE |
|
| DBSYSSEL2 |
Choose a database system for DB-specific indexes |
CHAR |
3 |
0 |
|
DDIXDBSEL
|
| ADA |
ADABAS D |
| DB2 |
DB2 for MVS |
| DB4 |
DB2 for AS/400 |
| DB6 |
DB2 common server |
| HDB |
SAP HANA Database |
| INF |
INFORMIX |
| MSS |
MSS SQL Server |
| ORA |
ORACLE |
| SYB |
SYBASE |
|
| DBSYSSEL3 |
Choose a database system for DB-specific indexes |
CHAR |
3 |
0 |
|
DDIXDBSEL
|
| ADA |
ADABAS D |
| DB2 |
DB2 for MVS |
| DB4 |
DB2 for AS/400 |
| DB6 |
DB2 common server |
| HDB |
SAP HANA Database |
| INF |
INFORMIX |
| MSS |
MSS SQL Server |
| ORA |
ORACLE |
| SYB |
SYBASE |
|
| DBSYSSEL4 |
Choose a database system for DB-specific indexes |
CHAR |
3 |
0 |
|
DDIXDBSEL
|
| ADA |
ADABAS D |
| DB2 |
DB2 for MVS |
| DB4 |
DB2 for AS/400 |
| DB6 |
DB2 common server |
| HDB |
SAP HANA Database |
| INF |
INFORMIX |
| MSS |
MSS SQL Server |
| ORA |
ORACLE |
| SYB |
SYBASE |
|
| ISEXTIND |
DD: Flag if index is extension index |
CHAR |
1 |
0 |
|
DDISEXTIND
|
|
| FULL_TEXT |
DD: Full Text Index |
CHAR |
1 |
0 |
|
DDFULLTEXT
|
|
| LANGU_COLUMN |
DD: Language Column for Full-Text Index |
CHAR |
30 |
0 |
|
DD_FTI_LANGU_COLUMN
|
|
| MIME_TYPE_COL |
DD: Column for Mime Type |
CHAR |
30 |
0 |
|
DD_FTI_MIME_TYPE_COL
|
|
| MIME_TYPE |
DD: Mime Type for Full-Text Index |
CHAR |
127 |
0 |
DDMIMETYPES
|
DD_FTI_MIME_TYPE
|
|
| LANGU_DETECTION |
DD: Languages for Automatic Language Detection |
CHAR |
200 |
0 |
|
DD_FTI_LANGU_DETECTION
|
|
| FAST_PREPROCESS |
DD: Fast Preprocessing On/Off |
CHAR |
1 |
0 |
|
DD_FTI_FAST_PREPROCESS
|
|
Fast Preprocessing Off |
| X |
Fast Preprocessing On |
|
| FUZZY_SEARCH_INDX |
DD: Additional Index for Fuzzy Search |
CHAR |
1 |
0 |
|
DD_FTI_FUZZY_SEARCH_INDX
|
|
No additional index for Fuzzy Search |
| X |
Create additional index for fuzzy search |
|
| SEARCH_ONLY |
DD: Original formatting will be removed |
CHAR |
1 |
0 |
|
DD_FTI_SEARCH_ONLY
|
|
Save original formatting in index |
| X |
Remove original formatting |
|
| UPDATE_MODE |
DD: Update Mode of Full-Text Index |
CHAR |
10 |
0 |
|
DD_FTI_UPDATE_MODE
|
| ASYNC |
Asynchronous change of full text index |
| SYNC |
Synchronous change of full text index |
|
| CONFIGURATION |
DD: Type of Text Analysis |
CHAR |
1 |
0 |
|
DD_FTI_CONFIGURATION
|
| 0 |
No special type of text analysis |
| 1 |
LINGANALYSIS_BASIC |
| 2 |
LINGANALYSIS_STEMS |
| 3 |
LINGANALYSIS_FULL |
| 4 |
EXTRACTION_CORE |
| 5 |
EXTRACTION_CORE_VOICEOFCUSTOMER |
|
| PHRASE_INDX_RATIO |
DD: Ratio Phrase Index to Full-Text Index |
NUMC |
3 |
0 |
|
DD_FTI_PHRASE_INDX_RATIO
|
|
| TEXT_ANALYSIS |
DD: Switches on the text analysis |
CHAR |
1 |
0 |
|
DD_FTI_TEXT_ANALYSIS
|
|
No text analysis |
| X |
Text analysis for enhanced information on DB switched on |
|
| TOKEN_SEPARATORS |
DD: Token Delimiters |
CHAR |
50 |
0 |
|
DD_TFI_TOKEN_SEP
|
|