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


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.

The SQLLOAD utility accepts all encoding prefixes supported by the genpassword utility for encoding passwords before transmitting them over the network to the OpenEdge SQL server for authentication. If the password is provided in plain text, it is encoded using aedh0 before being transmitted over the network.

For more information, see genpassword and Encoding prefix.

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, which 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.