|
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.
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.
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
|
|