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 )
)
/
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© 2025 Quest Software Inc. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center