Kbase P49644: Error 1694 while reading data from a table using SQL-89
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
FACT(s) (Environment):
Windows NT 32 Intel/Windows 2000
SYMPTOM(s):
SQLDA structure not allocated. Call sqlald(). (1694)
SQL-89
Table has 966 fields
Other tables with low number of fields can retrieve the data.
CAUSE:
SQL-89 has a technical limitation of maximum 512 columns per table.
FIX:
To workaround this problem, create a database view with the needed fields and use the view instead of the table. This is an example extracted from the manual on how to create a view using SQL-89:
CREATE VIEW doc
AS SELECT emp_num, name, job
FROM employee
WHERE Dept = 'Documentation'.
Execute this command using any ODBC client. Once the view is created use it to get the data out of the database using the view the same way as with a regular table.