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

SQL Anywhere 12.0.1 » 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 only available using DBISQL on Windows.

Note

This statement is not supported by UltraLite Java edition databases.

The recommended method for unloading and reloading UltraLite databases is to use the ulunload and ulload utilities. Note also that the ulinit utility can load schema and data directly from a SQL Anywhere database.

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