Was this helpful?
Btrieve 10
Btrieve is a transactional database interface. To use the Btrieve 10 connector, you must install Btrieve on both the system where the integration platform is used and on the system where transformations are run.
Note:  This connector requires that PervasivePSQLv10Server_x64 be installed. This requirement is for the server, not the client. If you install only client, and try to use this connector, you will get error 3012 when you try to open Btrieve files.
The following table shows read-write capabilities for the Btrieve connectors and Btrieve files.
Connector
v11
Btrieve v9.5 file
RW
Btrieve v9 file
RW
Btrieve v8 file
RW
Btrieve v7 file
RW
Btrieve v6 file
RW
Btrieve v5 file
R
Btrieve v4.11 file
R
Btrieve Data Dictionary Files - Btrieve is a transactional database interface. To use any of the Btrieve connectors, you must install the Btrieve version on both the system where Map Editor is used and on the system where transformations are run. Btrieve can use data dictionary files (DDFs). If your Btrieve files have no DDFs, use Pervasive DDF Builder to create them before connecting to Btrieve source or target data.
Connector-Specific Notes
Single record type files - In general, Btrieve files must be fixed, sequential files. For example, each record must be the same number of bytes and each field must occupy the same set of bytes in each record. For example, if record 1 is 236 bytes long, every record must be 236 bytes long. If the first field in record 1 occupies 4 bytes and is a 32-bit binary data type, then the first field in every record must do the same.
The integration platform does not support Btrieve files with records of variable length except when the variable records are at the end of the file after the fixed records. If so, the integration platform reads only the fixed records.
After writing to a Btrieve target, transformations do not update the Btrieve DDF index file. You must do this in Btrieve.
Multirecord type files - It is possible to work with variable-length multirecord files, with and without a record separator, using certain guidelines. For more information, search for "multiple record" in the documentation.
Truncation Error Trapping - This connector does not support truncation error trapping. If the target field size is too small for the data written to it, the offending record may be skipped or incomplete data may be written to the target. The transformation does not stop due to a truncation error, as do connectors that have truncation support.
Connector Parts
Connector parts are the fields you configure to connect with a data source or target. The fields that are available depend on the connector you select.
For a list of all parts for source connectors, see Specifying Source Connector, Parts, and Properties.
For a list of all parts for target connectors, see Specifying Target Connector, Parts, and Properties.
Property Options
You can specify the following source (S) and target (T) properties:
Property Name
S/T
Description
Page Size
S/T
This option sets the page size for Btrieve data. The default value is 4096. To change the page size, enter a new value in increments of 512. See the Btrieve documentation for your correct page size.
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.
Supported Data Types
The following data types are supported:
32-bit IEEE floating-point
64-bit IEEE floating-point
Autoinc (2 bytes)
Autoinc (4 bytes)
Bfloat (4 bytes)
Bfloat (8 bytes)
Bit
BLOB
Character (default)
CLOB
Comp
Comp-1
Comp-3
Comp-5
Comp-X
Currency
Date
Decimal
Float (4 bytes)
Float (8 bytes)
GUID (Btrieve 10 only)
Integer (1 byte)
Integer (2 bytes)
Integer (4 bytes)
Integer (8 bytes)
Logical
Logical (2 bytes)
Lstring
Lvar
Magic PC Date
Magic PC Extended
Magic PC Number
Magic PC Real
Magic PC Time
Microsoft BASIC double
Microsoft BASIC float
Money
Note
Numeric
NumericSA
NumericSTS
Packed decimal
Sales Ally time-2
Sales Ally date
Sales Ally time-1
Time
Timestamp
Unsigned (1 byte)
Unsigned (2 bytes)
Unsigned (4 bytes)
Unsigned (8 bytes)
Wstring
Wzstring
Zoned decimal
Zstring
Last modified date: 07/26/2024