Hi all, Im getting a
"Conversion between byte data and types is illegal" error, and I have no idea why.

Using simple code I create two tables which are identicle but with different names and try put the same information into each, it works on the first one but I get the above error message for the second table.

Any ideas guys? Would really appreciate help on this, its doing my head in. Below is the code

Just out of interest sake I had triggers on them but have dropped then since (1st 3 lines) and not put them back on again, and still getting the error.

"DROP TRIGGER KYC_TEST.RET_H_RSK_UPT_TRIG;
DROP TRIGGER KYC_TEST.RET_M_RSK_UPT_TRIG;
DROP TRIGGER KYC_TEST.RET_L_RSK_UPT_TRIG;

DROP TABLE KYC_TEST.RETRO_HIGH_RISK_REVIEW_POP ;
DROP TABLE KYC_TEST.RETRO_MEDIUM_RISK_REVIEW_POP;
DROP TABLE KYC_TEST.RETRO_LOW_RISK_REVIEW_POP;

CREATE TABLE KYC_TEST.RETRO_HIGH_RISK_REVIEW_POP (
BIT_PTY_ID CHAR(10) NOT NULL,
KYC_STA CHAR(1),
DMY_STA CHAR(1),
ACC_CLS_DT DATE,
FLTR_OUT CHAR(1),
TNF_OUT_DT DATE,
TNF_IN_DT DATE,
OUT_OF_SCP_FLG CHAR(1),
OUT_OF_SCP_DETAIL VARCHAR(20),
OUT_OF_SCP_DT DATE,
SYS_IMPT_DA DATE,
RTS_MGR_NM VARCHAR(30)
)
UNIQUE PRIMARY INDEX XRETRO_HIGH_RISK_REVIEW_POP (
BIT_PTY_ID
)
;

CREATE TABLE KYC_TEST.RETRO_MEDIUM_RISK_REVIEW_POP (
BIT_PTY_ID CHAR(10) NOT NULL,
KYC_STA CHAR(1),
DMY_STA CHAR(1),
ACC_CLS_DT DATE,
FLTR_OUT CHAR(1),
TNF_OUT_DT DATE,
TNF_IN_DT DATE,
OUT_OF_SCP_FLG CHAR(1),
OUT_OF_SCP_DETAIL VARCHAR(20),
OUT_OF_SCP_DT DATE,
SYS_IMPT_DA DATE,
RTS_MGR_NM VARBYTE(30)
)
UNIQUE PRIMARY INDEX XRETRO_MEDIUM_RISK_REVIEW_POP (
BIT_PTY_ID
)
;

insert into KYC_TEST.RETRO_HIGH_RISK_REVIEW_POP
select * from KYC_TEST.RETRO_HIGH_RISK_REVIEW_POP_TMP

insert into KYC_TEST.RETRO_MEDIUM_RISK_REVIEW_POP
select * from KYC_TEST.RETRO_HIGH_RISK_REVIEW_POP where bit_pty_id = 05405214
"

Regards
Emile