List of modifiers usable in the TABLE MODIFIERS and TABLES MODIFIERS clauses
Here is the list of modifiers that can be specified into the TABLE MODIFIERS and TABLES
MODIFIERS clauses: Figure 1. Modifiers list
For all these modifiers, here are the output formats they are compatible
with:
| Modifier | ASC | DEL | DELIMITED | IXF |
|---|---|---|---|---|
| ANYORDER | X | X | X | X |
| BINARYNUMERICS | X | |||
| CDEANALYZEFREQUENCY | X | X | X | X |
| CHARDEL | X | |||
| COLDEL | X | |||
| DECPT | X | |||
| DECPLUSBLANK | X | X | ||
| DELPRIORITYCHAR | X | X | ||
| DUMPFILE | X | X | X | |
| DUMPFILEACCESSALL | X | X | X | |
| FASTPARSE | X | X | X | |
| FORCEIN | X | |||
| GENERATEDIGNORE | X | X | X | X |
| GENERATEDMISSING | X | X | X | X |
| GENERATEDOVERRIDE | X | X | X | X |
| IDENTITYIGNORE | X | X | X | X |
| IDENTITYMISSING | X | X | X | X |
| IDENTITYOVERRIDE | X | X | X | X |
| IMPLICITLYHIDDENINCLUDE | X | X | X | X |
| IMPLICITLYHIDDENMISSING | X | X | X | X |
| IMPLIEDDECIMAL | X | X | ||
| INDEXFREESPACE | X | X | X | X |
| KEEPBLANKS | X | |||
| MAXANALYZESIZE | X | X | X | X |
| NOCHARDEL | X | |||
| NOCHECKLENGTHS | X | X | ||
| NOROWWARNINGS | X | X | X | X |
| NULLINDCHAR | X | |||
| PACKEDDECIMAL | X | |||
| PAGEFREESPACE | X | X | X | X |
| PERIODIGNORE | X | X | X | X |
| PERIODMISSING | X | X | X | X |
| PERIODOVERRIDE | X | X | X | X |
| ROWCHANGETIMESTAMPIGNORE | X | X | X | X |
| ROWCHANGETIMESTAMPMISSING | X | X | X | X |
| ROWCHANGETIMESTAMPOVERRIDE | X | X | X | X |
|
SECLABELCHAR |
X | X | X | X |
| SECLABELNAME | X | X | X | X |
| STRIPLZEROS | X | |||
| STRIPTBLANKS | X | |||
|
STRIPTNULLS |
X | |||
| TOTALFREESPACE | X | X | X | X |
| TRANSACTIONIDIGNORE | X | X | X | X |
| TRANSACTIONIDMISSING | X | X | X | X |
| TRANSACTIONIDOVERRIDE | X | X | X | X |
| USEDEFAULTS | X | X | X | X |
| USEGRAPHICCODEPAGE | X | X | ||
| ZONEDDECIMAL | X |