DB Structure: Create Table Script (10.2B)

Posted by Stefan Marquardt on 06-Jan-2010 02:38

I design new tables within OEA in the DB Structure TAB.

What sense makes the function "Create Table Script" that does not create the table as it was before?

If this doesn't work, where is the function for exporting the schema within(!) OEA?

All Replies

Posted by Matt Baker on 06-Jan-2010 07:34

The create table script is part of the sql explorer plugin upon which Progress db navigator is built.  This functionality generates a SQL script to create the ABL table.

Outside of db navigator you would normally use the ABL data administration tool (available from the openedge->admin menu) to export a .df.  This is the OpenEdge specific way of generating a table creation script.  This does not use SQL, but instead uses a text file with a .df extension that contains the table(s) definition.

Posted by Stefan Marquardt on 06-Jan-2010 10:18

But if you create this script, delete the table and run the script the table cannot be the same.

All field names are uppercase, ABL formats are missing, ...

I don't see the sense of this script for ABL development.

Posted by Thomas Mercer-Hursh on 06-Jan-2010 11:36

Bottom line, SQL scripts for creating OE schema are OK for a SQL application like Enterprise Architect since those applications won't pay any attention to the richer schema in OE anyway, but if you are creating schema for an ABL application, use the Dictionary tools.

This thread is closed