SYBASE IQ LOAD DATA

LOAD TABLE 语句说明将数据从外部 ASCII 格式文件导入数据库表。语法LOAD [ INTO ] TABLE [ owner ].table-name... ( load-specification [, ...] )... FROM { 'filename-string' | filename-variable } [, ...]... [ CHECK CONSTRAINTS { ON | OFF } ]... [ DEFAULTS { ON | OFF } ]... QUOTES OFF... ESCAPES OFF... [ FORMAT { 'ascii' | 'binary' } ]... [ DELIMITED BY 'string' ]... [ STRIP { ON | OFF } ]... [ WITH CHECKPOINT { ON | OFF } ]... [ { BLOCK FACTOR number | BLOCK SIZE number } ]... [ BYTE ORDER { NATIVE | HIGH | LOW } ]... [ LIMIT number-of-rows ]... [ NOTIFY number-of-rows ]... [ ON FILE ERROR { ROLLBACK | FINISH | CONTINUE} ]... [ PREVIEW { ON | OFF } ]... [ ROW DELIMITED BY 'delimiter-string' ]... [ SKIP number-of-rows ]... [ WORD SKIP number ]... [ START ROW ID number ]... [ UNLOAD FORMAT ]... [ IGNORE CONSTRAINT constrainttype [, ...] ]... [ MESSAGE LOG ‘string’ ROW LOG ‘string’ [ ONLY LOG logwhat [, ...] ]... [ LOG DELIMITED BY ‘string’ ]