The Generated DDL tool no longer includes physical, external, or table properties in the SQL code after upgrading to version 4.0; I was on version 3.6 prior.
For example:
On an existing model in version 3.6, I get the following SQL generated:
CREATE TABLE "ext_tbl"(
"empno" Char(4 ),
"ename" Char(20 ),
"job" Char(20 ),
"deptno" Char(2 )
)
ORGANIZATION EXTERNAL
(TYPE ORACLE_LOADER
DEFAULT DIRECTORY "ext"
ACCESS PARAMETERS (FIELDS TERMINATED BY ','
MISSING FIELD VALUES ARE NULL
(empno, ename, job, deptno))
LOCATION ('demo1.dat','demo2.dat'))
REJECT LIMIT 0
/
But in version 4.0, the generated SQL is missing the Physical and Table Properties:
CREATE TABLE "ext_tbl"(
"empno" Char(4 ),
"ename" Char(20 ),
"job" Char(20 ),
"deptno" Char(2 )
)
/
Some options are turned off by default.
Adjust the options in the Generate DDL tool for the entity.
1. Launch the Generate DDL Script tool and expand the Entity property on the new window.
2. Check the Physical Properties and Table Properties check boxes.
3. Click on the Save Settings button.
4. Click on the Generate button to create the new script with the desired code.
