Hi,
Here is a table I'd like to create:
create table txr
(
txd_id VARCHAR(6) not null ,
txg_id VARCHAR(9) not null ,
txr_id decimal(1,0)
default 0 not null ,
afm_id VARCHAR(6) not null ,
txr_rate decimal(5,3) not null ,
txr_rank decimal(2,0),
txr_taxpay decimal(1,0),
txr_rate_rent decimal(5,3),
CONSTRAINT ckc_txr_id_txr CHECK ((txr_id >= 0. ) AND (txr_id <= 9. ) ),
CONSTRAINT ckc_txr_rate_txr CHECK (txr_rate <= 100 ),
CONSTRAINT pk_txr PRIMARY KEY (txd_id,txg_id,txr_id)
)
... and the error I get :
Error during execution
-->-25010
SQL error -3019 = Invalid exponent:100 (error position: 429)
It seems to me that SAPDB doesn't like the number format for the check
constraint or something like that. Any Idea ?
Nicolas.
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
