Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 (Français) » UltraLite - Database Management and Reference » UltraLite SQL reference » UltraLite SQL statements

 

LOAD TABLE statement [UltraLite]

Use this statement to import bulk data into a database table from an external file. This statement also provides support for handling the output of the SQL Anywhere dbunload utility (the reload.sql file). LOAD TABLE is not supported on devices (Windows Mobile, iPhone, embedded Linux).

LOAD [ INTO ] TABLE [ owner.]table-name 
( column-name, ... ) 
FROM stringfilename
[ load-option ... ]
load-option :
CHECK CONSTRAINTS { ON | OFF } 
| COMPUTES { ON | OFF}
| DEFAULTS { ON | OFF }
| DELIMITED BY string
| ENCODING encoding
| ESCAPES { ON }
| FORMAT { ASCII | TEXT}
| ORDER { ON | OFF}| 
| QUOTES { ON | OFF }
| SKIP integer
| STRIP { ON | OFF | BOTH }
| WITH CHECKPOINT { ON | OFF }
comment-prefix : string
encoding : string
 Parameters
 Remarks
 Side effects
 See also
 Standards and compatibility
 Example