Loader Keywords: Overview 
Keywords are part of Loader commands that define the function of the command. The keywords are modified by arguments and options. Loader uses the keywords listed below. In some cases, you can also use the alternative keywords.
Keywords |
Alternative Keywords |
|---|---|
AND |
|
ANSI |
|
APPEND |
|
ASCII |
|
AUTOCOMMIT |
|
BINARY |
|
BOOLEAN |
|
BY |
|
CATALOG |
|
CHAR |
|
CODESET |
|
CODETYPE |
|
COLUMNS |
|
CONFIGURATION |
|
COUNT |
|
CSV |
COMPRESSED |
CURRENT |
|
DATA |
|
DATE |
|
DB |
|
DB2 |
|
DDL |
|
DEC |
|
DECIMAL |
|
DEFAULT |
|
DELIMITER |
|
DUPLICATES |
|
EBCDIC |
|
EUR |
|
EXPORT |
|
FILE |
|
FOR |
|
FWV |
FORMATTED |
FWV BINARY |
FORMATTED BINARY |
HEX |
|
HILO |
|
IF |
|
IGNORE |
|
IMPORT |
|
INSTALLATION |
|
INSTREAM |
|
INSTREAM FILE |
INFILE |
INTERNAL |
|
INTEGER |
|
ISO |
|
ISOLATION |
|
JIS |
|
KEY |
|
LANGUAGE |
|
LOB INSTREAM FILE |
LONGFILE |
LOB OUTSTREAM FILE |
LONGFILE |
LOHI |
|
MAPCOLUMNS |
|
MAPSCHEMA |
|
MAXRECORDS |
|
MAXROWS |
|
MESSAGE |
|
NOT |
|
NULL |
|
NUMBER |
|
OFF |
|
ON |
|
OR |
|
ORACLE |
|
ORDER |
|
OTHERWISE |
|
OUTSTREAM |
|
OUTSTREAM FILE |
OUTFILE |
PACKAGE |
|
PAGE |
|
PAGES |
|
PIPE |
|
POS |
|
REAL |
|
RECORDS |
|
REJECT |
|
RELEASE |
|
RESTART |
|
ROUND |
|
ROW |
|
ROWS |
|
SCALE |
|
SCHEMA |
|
SEPARATOR |
|
SEQNO |
|
SERVERDB |
|
SET |
|
SQLMODE |
|
STAMP |
|
START |
|
SQLID |
|
SYSDATE |
|
SYSTEM |
|
TABLE |
|
TAPE |
|
TIME |
|
TIMESTAMP |
|
TO |
|
TRUNC |
|
UID |
|
UPDATE |
|
USA |
|
USAGE |
|
USE |
|
USER |
|
USERGROUP |
|
USERKEY |
|
VERSION |
|
WITH |
|
ZONED |
More Information
Syntax Rules: Sorted Alphabetically
Syntax Rules: Sorted Semantically
SQL Reference Manual, Keyword (keyword)