data400

► FAQs

► PRICING

► TECA Inc.

14600 S.E. Center St.
Portland, OR 97236 USA

Tel: 503-901-6335
FAX: 503-761-6334

e-mail: sales@teca.com
URL: http://www.teca.com

TECA Data400 ► Download ► BUY NOW

Key Features

Native 32-bit Windows ActiveX Control
Subsecond record-level access using DDM
No ODBC or SQL is required
Data400 is a fully bound data source control
TECADBO COM Library provides full programming support
Supports both SNA and native TCP/IP
Client Access is not required
Supports keyed and non-keyed read, update, and delete access
Supports record locking and commitment control
Executes AS/400 commands
Lists all types of AS/400 objects
Provides access to QTEMP
No host components are required

Where TECA Data400 Can Be Used

You can use TECA Data400 in almost any environment including:

Visual Basic
Delphi
Visual C++
Visual FoxPro
Java
VBScript
Active Server Pages (ASP)
MS Access
MS Word
MS Excel

TECA Data400 Data Source Control

TECA Data400 Data Source Control is a fully bound data source control for the AS/400 that provides subsecond record-level access to AS/400 files. TECA Data400 can read and write any AS/400 file with speeds that are comparable to native RPG and COBOL programs. Being a data source control, TECA Data400 can be bound with other standard data bound control like text boxes, labels, combo boxes, list boxes and grids to easily create high performance AS/400 client/server applications without complicated programming.

Following you can see an example of the TECA Data400 control in the Visual Basic development environment.

In this example, you can see that the TECA Data400 control has been bound to two text boxes in Form1. Properties in the TECA Data400 control identify the AS/400 file that will be opened as well as the type of access (read-only, read-write) that will be permitted.

Like VB's standard data control, the TECA Data400 control is listed in the DataSource property of each bound text box control. Clicking on the DataField property of the text box will list all of the fields from the AS/400 file. All of the required data conversion is handled automatically.

Unlike the standard VB data control, the TECA Data400 control has been extended to provide additional functionality. In addition to the standard Move First, Move Previous, Move Next and Move Last buttons, the TECA Data400 control also provides a Find Key button, an Add New button, an Update button, a Cancel Update button and a Delete button. These extended functions allow you to create functional applications using just standard bound controls in conjunction with the TECA Data400 control. Simple data entry and update applications can be created without any coding.

For more complete programming control, an COM library is also provided with the TECA Data400 control. The COM library provides seamless integration with Visual Basic 6 and other COM compliant development environments.

Back to top

TECADBO COM Library

The TECADBO COM Library allows you to develop custom Windows-AS/400 applications without the complexities of PC oriented data access libraries or configuring ODBC drivers. The TECADBO COM Library is a Windows COM library that provides PC applications with AS/400 record-level access. Being a COM object, the TECADBO library can be used in any development environment that supports COM-based component. This includes Visual Basic, Visual C++, Delphi and others. It does not require the error prone process of creating function declarations. Instead you just add the reference to your COM development environment and the TECADBO objects, properties and methods will be immediately available for use. They can also take advantage of the features of the development environment. For instance, the TECADBO Library has full support for VB's statement prompting.

The TECADBO COM Library has been designed specifically for the AS/400 and uses familiar object concepts like libraries, files, and fields. It is simpler to implement than most other data access object models and it has no requirement to use of SQL. It addition it does not need to be used with well designed relational database files. The TECADBO Engine can access any type of AS/400 file including S/36 Environment files as well as relational AS/400 physical files, logical files and even source files. Since it it designed specifically for the AS/400, the TECADBO COM Library allows you to easily use the AS/400 features. For instance, it can:

Access database files by key
Access file sequentially
Access files by relative record number
Access file members
Perform record locking
Use commitment control
Execute OS/400 commands
Use the library list
Access QTEMP

The TECADBO object framework is presented in the following figure:

As you can see, the basic object in the TECADBO object framework is the dboEngine object. All other objects are contains by the engine. The dboSystem object is at the next level and it represents an AS/400 system. The TECADBO Engine is capable of connecting to multiple AS/400's at the same time. Just like the AS/400 itself, the beneath the system object is the dboLibrary object. Each dboLibrary represents a an AS/400 library. the dboLibrary object contains a collection of dboFile objects where each dboFile object represents an AS/400 file. The dboFile object contains a collection of dboField objects where each field object represents a field in the file.