The ddl generated for creating a table is incorrect.
This works in version 1 but there seems to be a problem with the beta version.
Scale and precision should not be generated for user datatypes. (We had encountered this problem in earlier versions).
INDIC is a user datatype with a bound default which should not be generared here.
I tried to isolate the problem with the attached sql file and came up with
create table TEST (
EMPL_NO ADH_REF not null,
POSTAL_ADR1 POSTAL_ADR default ‘102006’ not null
which is also incorrect but not what I was expecting to find.
Run against an ASE 12.5.3.
def_rule.sql (642 Bytes)