CPYDB  Concept

 Full Story

 Features

 Concept

 

CPYDB is part of our Data Distributor product, it enables IBM AS/400 to replicate physical and logical files to MS SQL Server, Oracle,  MS Access, MS Excel and importable flat files. CPYDB is an AS/400 command, similar to the CPYF (Copy File) command, it provides great flexibility in customizing and filtering the replicated data.

Quick Links

 Data Awareness
 Ease of use

CPYDB utilizes sockets over TCP/IP networks, and raw APPC over SNA networks. As a result, CPYDB consumes fewer AS/400 resources than competitive products which rely on FTP, DRDA or DDM protocols.


Data Awareness

CPYDB can easily be incorporated in your AS/400 jobs and make data replication part of your standard procedures. In lots of cases, the host publishing it's data knows better when the data is ready and available for replication, CPYDB provides the benefit of giving the publishing host, the control of initiating the data replication. 

CPYDB can do on the fly replication, similarly to the CPYF command, it can initiate publications that were previously  defined in Data Distributor, it can also create new publications in Data Distributor so it can be reused in future replications.


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.

                    Copy File to Database (CPYDB) 

Type  choices, press  Enter. 

From file . . . . . . . . . . . > CUSTOMERS Name 
Library . . . . . . . . . . . . > SALES  Name, *LIBL, *CURLIB 
Data Replicator Service . . . . > NT_CORP 
Subscriber Type . . . . . . . . > *SQL *SQL, *NETWORK, *FTPPUBLIC... 
To: 
SQL Subscriber  . . . . . . . . > SQLSVR1 Name 
Database  . . . . . . . . . . . > Sales Name 
Destination Table . . . . . . . > Customers  Name, *FROMFILE 
Save  Option: 
Save Publication  . . . . . . . > *NO  Name, *NO, *CALC 
Replace existing publication  . > *NO *NO, *YES 

Additional Parameters 

Create  Table/File  . . . . . . > *NEW *NO, *YES, *NEW 
Replace or add records  . . . . > *REPLACE *NONE, *ADD, *REPLACE 

More... 

F3=Exit F4=Prompt F5=Refresh F12=Cancel F13=How to use this display 
F24=More keys 

 

                    Copy File to Database (CPYDB) 

Type choices, press Enter. 

Create index . . . . . . . . . > *NO *NO, *NCLUSTERED, *CLUSTERED 
Wait . . . . . . . . . . . . . > *YES *NO, *YES 
Fields to include . . . . . . .> *ALL Name, *ALL 
+ for more values 
Generate aliases . . . . . . . > *NO *NO, *COLHDG, *ALIAS, *TEXT 
Date field names . . . . . . . > *NONE Name, *NONE 
+ for more values 
Date field format  . . . . . . > *MMDDYY *MMDDYY, *DDMMYY, *YYMMDD... 
Date field time format . . . . > *NONE *NONE, *HHMM, *HHMMSS 
Year 2000 cut off  . . . . . . > 25 Number, *NONE 
From member  . . . . . . . . . > *ALL Name, generic*, *FIRST, *ALL 
Copy from record number  . . . > *START Number, *START 
Copy to record number  . . . . > *END Number, *END 



More... 

F3=Exit F4=Prompt F5=Refresh F12=Cancel F13=How to use this display 
F24=More keys 

 

                    Copy File to Database (CPYDB) 

Type choices, press Enter. 

Copy from record key: 
Number of key fields . . . . . *NONE Number, *NONE, *BLDKEY 
Key value . . . . . . . . . . 

+ for more values 

Copy to record key: 
Number of key fields . . . . . *NONE Number, *NONE, *BLDKEY 
Key value . . . . . . . . . . 

+ for more values 

Number of records to copy . . . *END Number, *END 

More... 

F3=Exit F4=Prompt F5=Refresh F12=Cancel F13=How to use this display 
F24=More keys 

 

                    Copy File to Database (CPYDB) 

Type choices, press Enter. 

Include records by char test: 
Field . . . . . . . . . . . . *NONE Name, *NONE, *RCD, *FLD 
Character position  . . . . . Number 
Relational operator . . . . . *EQ, *GT, *LT, *NE, *GE... 
Value . . . . . . . . . . . . 

Include records by field test: 
Relationship  . . . . . . . . *NONE *NONE, *IF, *AND, *OR 
Field . . . . . . . . . . . .  Name 
Relational operator . . . . . *EQ, *GT, *LT, *NE, *GE... 
Value . . . . . . . . . . . . 

+ for more values 
Errors allowed  . . . . . . . 0 Number, *NOMAX 

Bottom 
F3=Exit F4=Prompt F5=Refresh F12=Cancel F13=How to use this display 
F24=More keys