SQL Options

The configuration options for SQL export are listed below.

Table Name

Table Name sets the target table used in the generated SQL.

Default: myTable

Example:

INSERT INTO myTable (...) values (...);

Max Values controls how many row tuples are added in a single INSERT statement.

Default: 100

If there are more rows than this value, AnyWayData creates additional INSERT statements.

For example with Max Values = 2, five data rows would generate three insert statements.

Quote Numeric controls whether numeric-looking values are emitted as strings or numbers.

When enabled (default), numeric-looking values are quoted:

('Monica','29')

When disabled, numeric-looking values are emitted without quotes:

('Monica',29)

This can help when loading into strongly typed numeric columns.

Dialect controls SQL dialect-specific behavior for quoted identifiers and transaction wrappers.

Supported values:

Quote Identifiers controls whether table names and column names are quoted in the generated SQL.

When enabled, quoting style follows the selected Dialect:

This helps avoid issues with reserved words, spaces, and special characters in headers.

Null Handling controls how empty values and NULL-like text are exported.

Available modes:

Keep Empty As '' - empty values are generated as empty strings.
Empty As NULL - empty values become unquoted NULL.
Empty Or NULL Literal As NULL - empty values and NULL text become unquoted NULL.

Wrap Transaction adds transaction wrapper statements around generated INSERT statements.

The wrapper syntax follows the selected Dialect, e.g.: