ODBC Data Sources
Previous Topic  Next Topic 

Stat/Transfer can read or write data for any file type for which you have, or can obtain, an ODBC driver.  These include such relational databases as Oracle, Sybase, DB2, or Informix, or flat file databases such as Btrieve.


Standard extension: [none]


Reading and Writing ODBC Data Sources

Depending on the driver, you may need to configure your data source from the Windows control panel.


When connecting to an ODBC data source, you may need to supply a password or other information.  If a particular data source requires such information, you will be prompted automatically.


Note that for client server databases in particular, some configuration and installation of database-specific components may well be required.  If you have difficulty connecting to a data source with Stat/Transfer, please try to connect with another tool such as Excel, or one supplied by your database vendor.  If you have difficulty with another tool, you should first talk to a local database administrator or the database vendor's support organization before contacting Circle Systems for support.


Reading

For ODBC, the Stat/Transfer user interface will present a list of installed data sources, instead of the Open or Save dialog boxes.  For details on using ODBC data sources with the command processor, see The DBR and DBW Commands and Running Batch Jobs with ODBC.


Stat/Transfer can either read single tables or multiple tables that are joined in a "view".


Writing

On output, tables can be created in a new file, new tables can be created in an existing file, or existing tables can be overwritten with a new table.


In addition, new data can be now appended to an existing database table.  This option is off by default and must be turned on by using the Append to Access and ODBC Tables option in the ODBC/Access Options section of the Options dialog box or the SET command DB-TABLE-APPEND in the command processor.


Stat/Transfer will match as many variables as 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, such as those requiring unique keys, that would prohibit a simple "append' operation.


Missing Values

Support for missing values depends on the ODBC driver you are using.  However, in most cases, missing values are supported.


Output Variable Types

The output variable type that results from each target variable type is given in the following table:



Target Type

Output Type


byte

int

Smallint


long 

Integer


float

Real


double

Double


date

Date


time

Time


date/time

Timestamp


string

Character