Watch, Follow, &
Connect with Us

For forums, blogs and more please visit our
Developer Tools Community.


ID: 17231, IBM Client Access/400 driver for dbExpress

by Peter Sawatzki Email: peter@sawatzki.de


DBEXPCA400.DLL is a driver for connecting to AS/400 databases via
IBM's Client Access/400 through Borlands dbExpress database components.
Version 2.00.24
Download Details
FTP  download also available
CDN Login Required to Download. (You will be redirected to the login page if you click on the Download Link)
To download this, you must have registered:
A free membership

For C++Builder, Version 6.0  to 6.0 343 downloads
Copyright: No significant restrictions


Size: 1,312,130 bytes
Updated on Fri, 08 Feb 2002 14:43:42 GMT
Originally uploaded on Wed, 02 Jan 2002 14:31:16 GMT
SHA1 Hash: 2DF0B69877668D107EC1C499EC1F5A3E425F6F0E
MD5 Hash: 9EF50DDA6C4A00111E2656CE6305D6DF

    Explore the files in this upload

Description
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 (dbexpca400s.dcu, dbexpca400s.obj,
clientaccess.dcu, clientaccess.obj) is free except for companies whose name begins
with "AFI ".

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

Client Access Express V5R1, SI01907
Client Access Express V4R5, SF66513
Client Access Express V4R3, SF65706
Client Access V3R2, SF65353

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 V5R1 of Client Access is required.

Data type mappings
------------------
AS/400 type dbExpress type
=========== ==============
CWBDB_PCSTRING fldZSTRING/fldstFIXED
CWBDB_PCGRAPHIC fldZSTRING/fldstFIXED
CWBDB_PCVARSTRING fldZSTRING
CWBDB_PCVARGRAPHIC fldZSTRING
CWBDB_PCBIGINT fldINT64 (no support in dbExpress yet)
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, 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 and Delphi 6

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

For more information, see http://www.sawatzki.de

   Latest Comments  View All Add New

Move mouse over comment to see the full text

Server Response from: ETNACDC03