ODBC/Access Options

The following options allow you to fine-tune your ODBC transfers.  They are generally for advanced users.


Use NULL instead of empty strings

A null string is a string for which a value has never been entered while an empty string has zero length.  Most databases support both NULL and empty strings (Oracle is the exception which converts empty strings to NULL strings).  If you check this box, Stat/Transfer will write NULLS instead of empty strings into your database.



Prefer "datetime" over "smalldatetime" for MS SQL/MySQL

The 'smalldatetime' type in MS SQL Server represents the dates between Jan 1,1900  to June 6, 2079 with accuracy to a minute.  If this is sufficient for your needs and you want to save space, uncheck this option.  The 'DateTime' type, in contrast, represents time values to an accuracy of close to 3 milliseconds and dates back to 1753.


Prefer (W)VARCHARover (W)CHAR

On output, if your data are stored in 'char' or its Unicode variant 'wchar', the length of the field will be equal to the length of its widest member.  On the other hand, 'varchar' is stored in variable length fields that save storage when the length of the string data varies between cases.  In general, you will want to leave this option at its default and write variable length string types when these are permitted.


Show the name of the table/view owner

A table or view in a database is identified by its owner and its name.  If you are in an environment in which tables with different owners have the same name, you will need to check this option to make sure that you can select the proper table.


Rows to read when scanning datetime variables

In some databases (including Access) there is only one date type, which can hold dates, times, and date/time values.  Stat/Transfer will, by default, read ten rows of data to determine the type of such variables.  If ten rows are not enough for your data, you can set a higher number here.


Append to Access and ODBC tables

This option (which is off by default), allows you to append your data to an existing database table.

Stat/Transfer will match as many variables as is possible to those already in the table and add your data to the matching columns. Obviously at least one column must match exactly and, in addition, the table must be free of constraints that would prohibit a simple 'append' operation, such as those requiring unique keys.


Drill Schema Name

When reading Apache Drill, if the name of the schema is not specified in the data source options, it can be specified here.