Completing the Database Export Wizard

Summary

• Dataset. The IBM® SPSS® Statistics session name for the dataset that is used to export data. This information is primarily useful if you have multiple open data sources. A data source opened with command syntax has a dataset name only if one is explicitly assigned.
• Table. The name of the table to be modified or created.
• Cases to Export. Either all cases are exported or cases that are selected by a previously defined filter condition are exported.
• Action. Indicates how the database is modified (for example, create a new table, add fields or records to an existing table).
• User-Missing Values. User-missing values can be exported as valid values or treated the same as system-missing for numeric variables and converted to blank spaces for string variables. This setting is controlled in the panel in which you select the variables to export.

Bulk Loading

Bulk load. Submits data to the database in batches instead of one record at a time. This action can make the operation much faster, particularly for large data files.

• Batch size. Specifies the number records to submit in each batch.
• Batch commit. Commits records to the database in the specified batch size.
• ODBC binding. Uses the ODBC binding method to commit records in the specified batch size. This option is only available if the database supports ODBC binding. This option is not available on macOS.
  • Row-wise binding. Row-wise binding typically improves speed compared to the use of parameterized inserts that insert data on a record-by-record basis.
  • Column-wise binding. Column-wise binding improves performance by binding each database column to an array of n values.

What would you like to do?

• Export the data. Exports the data to the database.
• Paste the syntax. Pastes the command syntax for exporting the data to a syntax window. You can modify and save the pasted command syntax.