Subject | Replication Demo Problem |
---|---|
Author | Gerhardus Geldenhuis |
Post date | 2001-11-09T05:41:07Z |
Hi
I have a table with the following structure:
CREATE TABLE READYMADES
(
CODE VARCHAR(20)NOT NULL,
AMOUNT INTEGER NOT NULL,
CREATESTAMP TIMESTAMP NOT NULL,
BRANCH VARCHAR(10)NOT NULL,
BOOKTYPE VARCHAR(10),
ID INTEGER NOT NULL,
CONSTRAINT PK_READYMADES PRIMARY KEY (CODE, CREATESTAMP, BRANCH)
)
I fill in the following data in the replication demo program.
SOURCETABLENAME/TARGET TABLE NAME=READYMADES
SOUCE/TARGET KEY COLUMNS = CODE,CREATESTAMP,BRANCH
Auto Create Table = False
Target Table Source
CODE VARCHAR(20),
AMOUNT INTEGER NOT NULL,
CREATESTAMP TIMESTAMP NOT NULL,
BRANCH VARCHAR(10) NOT NULL,
BOOKTYPE VARCHAR(10)
When creating it
Column unknown
ID
At line 51, column 81.
The problem is firstly there is only 41 lines. I dont think the problem is
with the demo program but with the metadata component. Is there something
extra I need to fill in.
My source inclussion expr=<<EXP>>BRANCH = 'BOKS'
That works I have tested it independantly.
Groete
Gerhardus
I have a table with the following structure:
CREATE TABLE READYMADES
(
CODE VARCHAR(20)NOT NULL,
AMOUNT INTEGER NOT NULL,
CREATESTAMP TIMESTAMP NOT NULL,
BRANCH VARCHAR(10)NOT NULL,
BOOKTYPE VARCHAR(10),
ID INTEGER NOT NULL,
CONSTRAINT PK_READYMADES PRIMARY KEY (CODE, CREATESTAMP, BRANCH)
)
I fill in the following data in the replication demo program.
SOURCETABLENAME/TARGET TABLE NAME=READYMADES
SOUCE/TARGET KEY COLUMNS = CODE,CREATESTAMP,BRANCH
Auto Create Table = False
Target Table Source
CODE VARCHAR(20),
AMOUNT INTEGER NOT NULL,
CREATESTAMP TIMESTAMP NOT NULL,
BRANCH VARCHAR(10) NOT NULL,
BOOKTYPE VARCHAR(10)
When creating it
Column unknown
ID
At line 51, column 81.
The problem is firstly there is only 41 lines. I dont think the problem is
with the demo program but with the metadata component. Is there something
extra I need to fill in.
My source inclussion expr=<<EXP>>BRANCH = 'BOKS'
That works I have tested it independantly.
Groete
Gerhardus