IBM Client Access/400 driver for dbExpress (ID #18240)

Peter Sawatzki

DBEXPCA400.DLL is a driver for connecting to AS/400 databases via
IBM's Client Access/400 through Borlands dbExpress database components.

Licensing
---------
Usage of DBEXPCA400.dll and the static variants (dbexpca400.dcu, dbexpca400.obj,
clientaccess.dcu, clientaccess.obj) is free except for companies whose name begins
with "AFI ".

Requirements
------------
Delphi version 7 or earlier or C++Builder version 6. An installed version of Client Access/400
is required. The driver has so far been tested with

Client Access Express V5R1, SI05361 (01-Aug-2002)
Client Access Express V4R5, SF67104 (23-Apr-2002)
Client Access Express V4R4, SF65706 (15-May-2001)
Client Access V3R2, SF67055 (final release)

On the OS/400 side make sure the latest PTFs are applied, especially if
you want to use the LOB features. The following DB2 group PTFs are
recommended:

OS/400 V5R1: SF99501
OS/400 V4R5: SF99105
OS/400 V4R4: SF99104

Currently most of driver testing is done with Client Access V5R1 against
OS/400 V4R5. For LOB support at least V5R1 of Client Access and at least
OS/400 V4R5 are required.

Data type mappings
------------------

AS/400 type dbExpress type
=========== ==============
CWBDB_PCSTRING fldZSTRING/fldstFIXED
CWBDB_PCGRAPHIC fldZSTRING/fldstFIXED
CWBDB_PCVARSTRING fldZSTRING
CWBDB_PCVARGRAPHIC fldZSTRING
CWBDB_PCVARDATALINK fldZSTRING
CWBDB_PCBIGINT fldINT64 (no support in dbExpress yet but works with this driver)
CWBDB_PCLONG fldINT32
CWBDB_PCSHORT fldINT16
CWBDB_PCFLOAT fldFLOAT
CWBDB_PCDOUBLE fldFLOAT
CWBDB_PCPACKED(1..9,0) fldINT32
CWBDB_PCPACKED fldBCD
CWBDB_PCZONED(1..9,0) fldINT32
CWBDB_PCZONED fldBCD
CWBDB_SQLDate fldDATE
CWBDB_SQLTime fldTIME
CWBDB_SQLTimeStamp fldDATETIME
CWBDB_PCBLOB fldBLOB/fldstBINARY (needs at least CA V5R1 and OS/400 V4R5)
CWBDB_PCBLOBLOCATOR fldBLOB/fldstBINARY (needs at least CA V5R1 and OS/400 V4R5)
CWBDB_PCCLOB fldBLOB/fldstMEMO (needs at least CA V5R1 and OS/400 V4R5)
CWBDB_PCCLOBLOCATOR fldBLOB/fldstMEMO (needs at least CA V5R1 and OS/400 V4R5)

Note
----
Although VendorLib is set to cwbdb.dll, but changing this value has no effect.
In fact cwbdb.dll, cwbnl.dll, cwbsv.dll and cwbsy.dll are used.

Release History
---------------
1.0.56 surface logical files as Indices in metadata
1.0.57 corrected readme bug (LocalCode contained an invalid hex code)
1.0.60 fixed several bugs
1.0.65 added support for OS/400 V4R3 and Client Access V4R4
1.0.68 use logical catalog files (QADBLDEP, ..) instead of physical
1.0.69 added automatic conversion of zoned(N,0) and packed(N,0) to int
1.0.70 added parameter binding for zoned(N,0) and packed(N,0)
1.0.75 added affected rows by using a hidden feature in CA/400
1.0.80 added float support
1.0.85 added BCD support
1.0.95 added DATE, TIME and TIMESTAMP support
2.0.00 driver rewritten in Delphi
2.0.05 support LOBs
2.0.10 support long filenames, long field names, system naming
2.0.24 release for C++ Builder 6
2.0.30 add support for service usage, use cwbco.dll for login
2.0.32 add describe option
2.0.33 speed things up by using cwbDB_PrepareDescribe
2.0.34 add support for SP output parameters and multiple result sets
2.0.35 metadata implementation for SPs and their parameters
2.0.36 add transaction support and commitretain
2.0.37 speed things up with SetAmbiguousSelectOption = READONLY
2.0.38 speed up string conversions a lot
2.0.40 add usage of default system
2.0.50 release for Delphi 7

Link
----
See http://www.sawatzki.de for the latest version

IBM Client Access/400 driver for dbExpress home page