Archives of the TeradataForum

Message Posted: Thu, 23 Oct 2003 @ 20:16:19 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

I wrote these instructions a while ago....I think it does what you want:

Reverse Engineering:

In queryman

Select Tools-Options-check 'write all answer sets to a single file'

SEL   'SHOW TABLE '||
      TRIM(DATABASENAME)||'.'||
      TRIM(TABLENAME)||
      ';' AS XQL
FROM  DBC.TABLES
WHERE DATABASENAME = 'PCDW_EBI_TEMP'
AND   TABLEKIND='T'
;

In queryman Select File - export results

Paste the answerset from the first query above into the query window. You have to delete the first line which is the header 'XQL'

Run the query.

When prompted for a file type in the name of the database, a space the word DDL a period then SQL. eg PCDW_AUTO@ DDL.SQL

Edit the file: Remove 'Request Text' from the file.

Erwin does not reverse engineer the following so you have to change them.

Change CHARACTER SET LATIN to /*CHARACTER SET LATIN*/

All character set statements should be commented out.

Change NOT CASESPECIFIC to /*NOT CASESPECIFIC*/

Comment out any Value ordered index statetements.

Various Default values need to be commented out.

There are other things Erwin doesn't like. You should comment those out.

start Erwin
Tools
Reverse Engineer
Next
Check Script File
Browse
Select your DDL created above

You have some options

Infer primary key or indexes

Select NEXT

	<Prev	Next>		<<First	<Prev	Next>	Last>>