EXECUTE IMMEDIATE 'CREATE TABLE "generictypes"
(
"intgenexp" INTEGER GENERATED ALWAYS AS 2 NOT NULL
)

---

 Comments and Workarounds

---

The problem was with the parser getting confused by the 2 NOT NULL expression. The workaround was to use this instead:

CREATE TABLE "generictypes"
(
"intgenexp" INTEGER GENERATED ALWAYS AS 2
CONSTRAINT "intgenexp_req" CHECK "intgenexp" IS NOT NULL
)

---

 Resolution

---

Fixed Problem on 1/8/2010 in version 2.03 build 7

---

 Products Affected

---

ElevateDB Additional Software and Utilities
ElevateDB DAC Client-Server
ElevateDB DAC Client-Server with Source
ElevateDB DAC Standard
ElevateDB DAC Standard with Source
ElevateDB DAC Trial
ElevateDB LCL Standard with Source
ElevateDB VCL Client-Server
ElevateDB VCL Client-Server with Source
ElevateDB VCL Standard
ElevateDB VCL Standard with Source
ElevateDB VCL Trial