Kbase P19620: What are the difference between sql-92 table and tables created by the 4GL?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
What are the difference between SQL-92table and tables created by the 4GL?
FIX:
By the term "SQL-92 tables? we assume database tables created by the
SQL-92 "create table" statement
There is a huge difference in these, much more than can be covered in one
solution.. I am not sure the SQL-92 doc covers it completely.
Essentially, the Progress 4GL database is a subset of the SQL/92 schema.
The Progress 4GL database contains a limited number of datatypes (there are certain SQL-92 datatypes, like Float or Timestamp, which the 4GL does not currently understand.), has smaller maximum record sizes, and contains some concepts (such as arrays) that don't fit the SQL standard. But it was the original Progress database, the only one what works directly with the 4GL
Tables created in either 4GL or SQL-92 are inter-operable. That is, the 4GL can use tables created by SQL-92, and vice versa. There are limits on the interoperability. SQL-92 tables not in the PUB schema cannot be seen by the 4GL.