Kbase P114610: Is a 4GL table the same as a SQL table in OpenEdge 10.1A ?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
3/27/2006 |
|
Status: Unverified
GOAL:
Is a 4GL table the same as a SQL table in OpenEdge 10.1A ?
GOAL:
Is a table created in the Database Navigator the same as a table created in the Data Dictionary ?
FACT(s) (Environment):
OpenEdge 10.1A
FIX:
When tables are created from the Database Navigator (SQL):
As long as the tables are in the PUB schema and do not contain any fields with 4GL incompatible data types, then there will be no difference. The wizards in the Database Navigator only allow the creation of tables with 4GL supported data types. The only way to create tables with 4GL incompatible data types is through the CREATE TABLE statement.
When tables are created from the Data Dictionary (4GL):
The tables will be created in the same way as if they were created from the Database Navigator wizards.