Kbase P43548: Loading a table using a data definition (.df) file causes error 188 on certain fields.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
7/7/2004 |
|
Status: Unverified
FACT(s) (Environment):
Progress 9.1x
SYMPTOM(s):
Loading a table using a data definition (.df) file causes error 188 on certain fields.
Data type must be character, integer, decimal, logical, date, or recid. (188)
CAUSE:
Bug# 20020925-023
CAUSE:
If for example you create a table in the PUB schema from SQL-92 with fields containing data type 'tinyint' or 'smallint', then they are displayed from 4GL as data type 'byte' and 'short' respectively. This also results in these fields being dumped with these data types.
FIX:
Starting from OpenEdge 10.0A, it is not possible anymore to dump SQL-92 tables using 4GL tools.
Use the SQLSCHEMA command-line utility to specify which components to dump. This utility selectively writes SQL-92 database schema components to an output file. This way it possible to capture table definitions including table constraints, views, stored procedures (including related privileges), and triggers.