Kbase P14394: SQL-89 VIEW displays only 8 characters when SUBSTRING is use
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/2/2003 |
|
Status: Unverified
GOAL:
Why do SQL-89 created views have field display length limitation of 8 characters when 4GL SUBSTRING function is used either in the CREATE VIEW or in the SELECT ...FROM <view-name> statements?
FIX:
This is a known limitation of SQL-89. Use SQL-92 with ODBC or JDBC connection.