dbload

Converts the query result into an SQL query command and provides it into an external SQL server. It has the same functionality as the dboutput command, and only the default value of the rowretry option is different.

Syntax

dbload PROFILE [OPTIONS] table=TABLE FIELD, ...
Required Parameters
PROFILE

JDBC connection profile. You can configure the connect profile in the web console.

table=TABLE

Name of table in which to input the data.

FIELD, ...

Field names to be provided in the database, separated by a comma(,). The field name must match the column name of the target table.

If you prefix the plus sign (+) with the field name, it is recognized as a key column.

Tip
If the field and column names do not match, use the 'rename' command before the 'dbload' command to match the name of the column in the SQL database.
Optional Parameters
batchsize=INT

Processing unit to be applied to the database batch transaction. Larger units are more efficient because they are committed at once, but if the transaction fails, the number of rollback records also increases. 2000 is recommended.

If you do not specify a processing unit size, the processing speed may be slow because the command commits the transaction one by one.

database=SCHEMA

Schema or database to switch to when connecting to the server.

rowretry=BOOL

Option to retry transaction row by row if any query fails (default: t). When enabled, performance may be degraded, but data loss can be minimized.

  • t: Retries the transaction row by row after the batch transaction fails.
  • f: NOT retry the transaction row by row after the batch transaction fails.
stoponfail=BOOL

Option to stop the query when transaction fails (default: f).

  • t: Stops the query when the transaction fails.
  • f: Skips the failed transaction and executes the next transaction.
type=update

Type of SQL query: either insert or update (default: insert). If you set it to update, you MUST specify one or more fields as key columns. This command finds a record by key.