DDL for added database

[peluett]

Hello,
in this forum I the beginner.
I have added database SQLBase (Gupta) to the project and have create some tables. Now I generate DDL. There are tree effects.
- the CommentLevel is NONE, but in the script stand the table comment
COMMENT ON TABLE REPORT
   IS 'My Note.'

- in each columne definition stand the keyword "DEFAULT"
- there is a blank line between the definition and the SQL Terminator
CREATE TABLE REPORT (
TOPIC VARCHAR(25) DEFAULT  NOT NULL,
NAME VARCHAR(150) DEFAULT  NOT NULL,
LINK VARCHAR(250) DEFAULT  NOT NULL,
SYSTEM CHAR(5) DEFAULT  NOT NULL,
EXPORTART VARCHAR(25) DEFAULT
)

/

I have look for DDL transformation in this forum, but i can find a way for the problem.

thank you for your assistance
peluett

[thomaskilian]

I can't help much with Gupta, but a) DDL generation is not configurable and b) check the table attributes (columns) frame since it contains a lot of flags you might want to set. Also check that the language for the table is set to you database.