CPYDB  Features

 Full Story

 Features

 Concept

 

CPYDB seamlessly replicates AS/400 physical and logical files to MS SQL Server, Oracle,  MS Access, MS Excel and importable flat files at high speed. Replicated data provides local and remote end-users fast and simple access to their information without consuming AS/400 resources.

Quick Links

 Ease of use
 Controlled Replication
 Physical and Logical files Friendly Field Names

With an amazing data replication speed, CPYDB is significantly faster than any alternative product. CPYDB also features direct TCP/IP connectivity, eliminating the need and associated costs of installing a gateway.

CPYDBs ease-of-use is made possible by its close resemblance to the AS/400 Copy File (CPYF) command, already familiar to most AS/400 administrators.


Ease of use

CPYDB uses the same syntax and has the same features as the AS/400 Copy File (CPYF) command. As most AS/400 administrators and programmers are familiar with CPYF, no training is required to use CPYDB.


Controlled Replication

CPYDB uses the same syntax and has the same features as the AS/400 Copy File (CPYF) command. As most AS/400 administrators and programmers are familiar with CPYF, no training is required to use CPYDB.


Replicates Physical and Logical files

CPYDB can replicate any AS/400 physical or logical file having a Data Description Specification (DDS). CPYDBs ability to replicate logical files is particularly powerful. First, inherent AS/400 capabilities may be used for high-speed row and field data selection.

Second, multiple AS/400 files may be logically joined together constructing a single SQL or Oracle Server table containing the information most suitable for the end-user, or for their Microsoft Excel, Access, Word or other applications.


User Firendly Field Names

CPYDB's ability to convert 6 character AS/400 field names to database friendly ones is highlighted by how easy it is to implement. Alias names may be automatically taken from either the field's DDS column headings or description. The user may even decide to create logical files just for this purpose. Such files have no impact on system performance if index update is deferred till file open.