You have created a new UltraLite database, but have a .csv ASCII data file that you cannot import.
The .csv format is not supported by any of the UltraLite administration tools.
You can try one of the following techniques:
Use Interactive SQL (dbisql) to import the data. You can connect to the UltraLite database and then choose Data » Import Data. Alternatively, you can connect to the UltraLite database and run the INPUT statement (this statement cannot be used in an UltraLite PreparedStatement object).
UltraLite requires primary keys. Although Interactive SQL can create the table for you, it does not automatically create the primary keys for them. Always connect to an empty UltraLite database you have created for this purpose.
If you to incorporate this functionality as part of a batch process, you must write your own code.
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |