User Guide : Map Connectors : Source and Target Map Connectors : Clipper
 
Share this page                  
Clipper
Clipper is a database application that uses a dBASE format. The Clipper connector primary data file usually has a .DBF extension and the memo file has a .DBT extension. Clipper files are structured; for example, both the data and the file structure are stored inside the primary data file.
Connector-Specific Notes
No known limitations specific to Clipper files are known at this time. For general dBASE limitation details, see dBASE IV.
Property Options
You can set the following source (S) and target (T) properties.
Property
S/T
Description
IgnoreMemoErr
S/T
This option determines how dBASE memo files are handled. Choose you selection from the picklist. The following options are available:
• Never – Default. This option causes the integration platform to look for and include any memo file fields when the source data file is read.
• Errors – Selecting this option causes the integration platform to look for and include any memo file fields when a memo file is present. If present, the memo fields are included with the transformed data.
• If the memo file (.DBT) is not in the same directory as the data file (.DBF), the memo file is ignored. This means that the memo fields are not included with the transformed data.
• Always – Selecting this option causes the integration platform to ignore the memo file completely. This means memo fields are not included with the transformed data.
CodePage
S/T
This translation table determines which encoding to use for reading and writing data. The default is ANSI, the standard in the US.
Data Types
The following data types are available:
• Character – may contain alpha or numeric information and may have a field width of 1 to 254 bytes. Use a character field to store numbers that are not used in calculations, such as phone numbers, check numbers, account numbers and zip codes (number fields delete the leading zeros in some zip codes). (default)
• Date – may contain only a date and the date is formatted as yyyymmdd, for a four-digit year, a two-digit month and a two-digit day. Example: The date January 1, 1999 would read 19990101.
• Logical – may contain only one byte and is formatted to contain t, f, T, or F, for true or false.
• Memo – may contain alpha or numeric information and may have a field width of 1 to 16,000 bytes.
• Numeric – may contain only positive or negative numbers and may have a field width of 1 to 20 bytes, including the decimal point, minus sign (–), or plus sign (+). A numeric field may contain decimal places up to 19, but the number of decimal places must be set at one byte less than the total width of the field. Numeric fields are used to store the exact value of a number with a fixed number of digits.
If you are writing to a new table, you may use any of these available data types from the list that appears when you click the arrow in the Type cell of a field.
If you are appending data to an existing table, the data type of each field uses the data type in the selected table by default.
Connectivity Pointers
• As a general rule, when connecting to a database with ODBC, most require the database engine to be running when connection is attempted.
• Tab to Server Name and, if applicable, type your the name of your remote database server. If the database that you want to connect to resides on your LAN or local PC, it is not necessary to enter the Server Name.
• Tab to Data Source and select the desired source as it appears in the User DSN tab in the ODBC administrator, but without the information in parentheses. An example is My Data Source 1.