Release 10.1A: OpenEdge Development:
Internationalizing Applications

> ## SQLLOAD

> `SQLLOAD` lets you load SQL databases. The syntax for `SQLLOAD` (for UNIX and Windows) is:

> Syntax
> sqlload -u `username` -a `password` -t `table-name`[,`table-name` ...]`database-url` [-b `bad-row-filename`] [-C `charset`] [-e `max-errors`] [-F { comma | quote }] [-f `command-filename`] [-l `log-filename`] [-n error-check]

> `username`, `password`

> User authentication.

> ``table-name`[,`table-name` ...]`

> One or more tables to load . Multiple tables can be specified, in a comma-separated list. Specify a `table` of `%` to load all tables. The `-t` option can be specified only if the `-f` option is not.

> ``database-url``

> The database to which you want to connect. This has the following form:

> `progress:T:``host-name``:``service-name``:``database-name`

> ``bad-row-filename``

> The file where `SQLLOAD` writes rows that were not loaded. The default is `screen`.

> ``charset``

> The name of the character set of the tables to be loaded.

> ``maxerrors``

> The maximum number of errors allowed before processing is terminated. The default is 50.

> `{ comma | quote }`

> If `comma` is specified, load in comma-delimited format. If `quote` is specified, load in quote-delimited format. The default is `quote`.

> ``command-filename``

> The file where `SQLLOAD` reads commands on how and what to load. The `-f` option can be specified only if the `-t` option is not.

> `log-filename`

> The file where `SQLLOAD` writes errors and statistics. The default is `screen`.

> `error-check`

> Check for syntax errors without loading any rows.

Copyright © 2005 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095